Open-Source Enterprise Project Management

]project-open[ : @This Wiki

Welcome, Unregistered Visitor

Follow @projop · · · Index · Login/Register

General
- Architecture
- Contact the ]po[ Team
- Conventions & Policies
- Free License
- Licensing
- Open-Source
- Roadmap
- Security
- This Wiki
- Press
  - News
  - V4.0 Press Kit (English)
  - What the Press Writes About Us
  - V3.4 Press Releases
  - V4.0 Press Releases
- Glossary
  - Glossary of ]po[ Terms
- Other
  - Contributors
  - How to write a Success Story
FAQ
Partners
- About Partners
- Abakus
- Access-Business Solutions S.A.
- Ad Axem
- Cogito
- Cosmo Commerce Corp.
- EFEXCON AG
- Elego
- GEDPRO
- Globalme
- Gongolabs
- IcoText LLC
- Intelligent Orange
- Intellligent Orange
- Konsultex
- KryStone
- LaiKA iT
- Leinhäuser Solutions
- Localization to Russian
- Nuvento
- Odin Consultores
- Pentamino GmbH
- Qabiria
- SPIR-IT
- Sesmic Technologies
- Spazio IT - Soluzioni Informatiche
- Stoquart
- Thiqah
- Venkat Mangudi Consulting Pvt Ltd
- Webbudget
- Wizentis
- Zensar
- cognovís
- Material for ]po[ Partner
  - @Marketing Material
  - Customer Types
  - Rollout Plan and Tutorial
Processes
Modules
Packages
Pages & Portlets
Business Intelligence
- Indicators
- Reports
Tutorials
Installers
Configuration
- About Configuration
- GUI Configuration
- Maintenance & Updates
- Basic Configuration
- Privileges & Permissions
- Timesheet
  - Timesheet Configuration
- Workflow
  - Absence Workflow Configuration
- Mail System
- Dynamic Fields and Views
- Templates
  - FI List of Placeholder variables for templates
  - Financial Document Configuration
- Other
Developers
Languages & Localization
- About Languages
- About Localization
- Arabic
- Bulgarian
- Chinese (Simplified)
- Dutch
- English (US)
- French
- German
- Italian
- Japanese
- Localization Terminology
- Polish
- Portuguese (Brazil)
- Russian
- Slovakian
- Spanish (Spain)
- Turkish
- Vietnamese
- Localization Terminologies
  - Dutch
  - Spanish
Integration With Other Tools
PM Methodologies

7 registered users

in last 24 hours

]po[ Helpdesk & ITSM PL/SQL API

The following PL/SQL API functions are related to the ]po[ helpdesk and ITSM functionality.

Configuration Item PL/SQL API

Please refer to the configuration item object type documentation for details on the object and the data model.

Function	Returns	Arguments	Description
[im_conf_item__delete]	integer	integer	Destructor
[im_conf_item__name]	varchar	integer	Name function
[im_conf_item__new]	integer	integer, varchar, timestamptz, integer, varchar, integer, varchar, varchar, integer, integer, integer	Constructor
[im_conf_item_name_from_id]	varchar	integer	Shortcut function to return the name of the object.
[im_conf_item_nr_from_id]	varchar	integer	Shortcut function to return the conf_item_nr of the object.

The following API functions allow to associate configuration items to projects, indicating that the configuration item has been modified as part of the project. Please refer to the [configuration item - project relationship] documentation for details on the functionality.

Function	Returns	Arguments	Description
[im_conf_item_project_rel__delete]	integer	integer	Destructor (specifying the relatinship_id).
[im_conf_item_project_rel__delete]	integer	integer, integer	Destructor (specifying the conf_item_id and the project_id).
[im_conf_item_project_rel__new]	integer	integer, varchar, integer, integer, integer, integer, varchar, integer	Constructor

Release Items PL/SQL API

Please refer to the [release item object type] documentation for details on the object and the data model.

Function	Returns	Arguments	Description
[im_release_item__delete]	integer	integer	Destructor
[im_release_item__delete]	integer	integer, integer	Destructor
[im_release_item__new]	integer	integer, varchar, integer, integer, integer, integer, varchar, integer, integer	Constructor

Helpdesk Ticket PL/SQL API

Please refer to the ITSM module overview and the helpdesk ticket object type documentation for details on the object and the data model.

Function	Returns	Arguments	Description
[im_ticket__classify]	integer	integer, text, text	PL/SQL function to classify the ticket into the ticket hierarchy and optionally assign the ticket to a specific queue.
[im_ticket__delete]	integer	integer	Destructor
[im_ticket__name]	varchar	integer	Name function
[im_ticket__new]	integer	integer, varchar, timestamptz, integer, varchar, integer, varchar, integer, integer, integer	Constructor

Ticket Queue PL/API

Please refer to the ITSM module overview and the [ticket queue object type] documentation for details on the object and the data model.

Function	Returns	Arguments	Description
[im_ticket_queue__delete]	integer	integer	Destructor
[im_ticket_queue__new]	integer	integer, varchar, varchar, varchar, timestamptz, varchar, varchar, integer, integer, timestamptz, varchar, varchar	Constructor

Ticket-Ticket Relationship PL/API

The ticket-ticket relationship allows associating problem tickets with issue tickets, and tickets with other tickets in general.

Function	Returns	Arguments	Description
[im_ticket_ticket_rel__delete]	integer	integer	Destructor (providing a relationship_id)
[im_ticket_ticket_rel__delete]	integer	integer, integer	Destructor (providing two ticket_id's)
[im_ticket_ticket_rel__new]	integer	integer, varchar, integer, integer, integer, integer, varchar, integer	Constructor

Categories: PL/SQL API (Contents)