1 PACKAGE PA_PCO_DOC_NUMBER_CLIENT_EXTN AUTHID CURRENT_USER AS
2 /* $Header: PAPCORXS.pls 120.1.12010000.2 2009/10/21 06:13:52 sosharma noship $ */
3 /*#
4 * Oracle Projects provides a template package that contains a procedure that you
5 * can modify to implement Potential Change Order Report document numbering
6 * extension. The name of the package is pa_pco_doc_number_client_extn.The
7 * name of the procedure is get_next_number.
8 * @rep:scope public
9 * @rep:product PA
10 * @rep:lifecycle active
11 * @rep:displayname Potential Change Order Report Document Numbering Extension
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY PA_PROJECT
14 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
15 */
16
17 /*#
18 * Procedure that can be modified to implement Potential Change Order
19 * Report Document Numbering
20 * @param p_project_id The identifier of the project
21 * @rep:paraminfo {@rep:required}
22 * @param p_customer_appr The Customer Approver for Change Request
23 * @rep:paraminfo {@rep:required}
24 * @param p_change_req_id The Change Request Identifier
25 * @rep:paraminfo {@rep:required}
26 * @param p_chage_req_ver The Change Request Version
27 * @rep:paraminfo {@rep:required}
28 * @param p_next_number The Document Number generated
29 * @rep:paraminfo {@rep:required}
30 * @param x_return_status Return Status:S = Success, E = Error
31 * @rep:paraminfo {@rep:required}
32 * @param x_msg_count The Error message Count
33 * @rep:paraminfo {@rep:required}
34 * @param x_msg_data The Error message Data
35 * @rep:paraminfo {@rep:required}
36 * @rep:scope public
37 * @rep:lifecycle active
38 * @rep:displayname Potential Change Order Report Document Numbering Extension
39 * @rep:compatibility S
40 */
41
42 PROCEDURE GET_NEXT_NUMBER (
43 p_project_id IN NUMBER
44 ,p_customer_appr IN VARCHAR2
45 ,p_change_req_id IN NUMBER
46 ,p_chage_req_ver IN NUMBER
47 ,p_next_number IN OUT NOCOPY VARCHAR2
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2);
51
52 END PA_PCO_DOC_NUMBER_CLIENT_EXTN;
53