1 PACKAGE PA_CLIENT_EXTN_PWP AUTHID CURRENT_USER AS
2 -- $Header: PAPWPEXTS.pls 120.0.12010000.5 2009/10/21 10:04:36 vchilla noship $
3 /*#
4 * Oracle Projects provides a template package that contains a procedure that you can modify to implement
5 * Release Pay When Paid Holds extension. The name of the package is (PA_CLIENT_EXTN_PWP) PAPWPEXTB.pls .
6 * The name of the procedure is RELEASE_INV.
7 * @rep:scope public
8 * @rep:product PA
9 * @rep:lifecycle active
10 * @rep:displayname Release Pay When Paid Holds Extension
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY PA_PROJECT
13 * @rep:category BUSINESS_ENTITY PA_PAYABLE_INV_COST
14 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
15 */
16
17
18 /*#
19 * Procedure that can be modified to implement Release Pay When Paid Holds extension
20 * @param P_REQUEST_ID The request id of concurrent program from which the extension is called
21 * @rep:paraminfo {@rep:required}
22 * @param P_PROJECT_TYPE The Project Type for which release holds program is executed.
23 * @rep:paraminfo {@rep:required}
24 * @param P_FROM_PROJ_NUM The starting Project Number for which Release holds program is executed.
25 * @rep:paraminfo {@rep:required}
26 * @param P_TO_PROJ_NUM The end Project Number for which Release holds program is executed.
27 * @rep:paraminfo {@rep:required}
28 * @param P_CUSTOMER_NAME The Customer Name
29 * @rep:paraminfo {@rep:required}
30 * @param P_CUSTOMER_NUMBER The Customer Number
31 * @rep:paraminfo {@rep:required}
32 * @param P_REC_DATE_FROM The date from which receipts are to be considered.
33 * @rep:paraminfo {@rep:required}
34 * @param P_REC_DATE_TO The date to which receipts are to be considered.
35 * @rep:paraminfo {@rep:required}
36 * @param X_RETURN_STATUS Return Status
37 * @rep:paraminfo {@rep:required}
38 * @param X_ERROR_MESSAGE_CODE Error Code
39 * @rep:paraminfo {@rep:required}
40 * @rep:scope public
41 * @rep:lifecycle active
42 * @rep:displayname Transaction Control Extension
43 * @rep:compatibility S
44 */
45
46
47
48 LOG NUMBER := 1;
49
50 PROCEDURE RELEASE_INV (
51 P_REQUEST_ID IN NUMBER
52 , P_PROJECT_TYPE IN VARCHAR2
53 , P_FROM_PROJ_NUM IN VARCHAR2
54 , P_TO_PROJ_NUM IN VARCHAR2
55 , P_CUSTOMER_NAME IN VARCHAR2
56 , P_CUSTOMER_NUMBER IN NUMBER
57 , P_REC_DATE_FROM IN VARCHAR2
58 , P_REC_DATE_TO IN VARCHAR2
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_error_message_code OUT NOCOPY VARCHAR2);
61
62
63
64
65
66
67 END PA_CLIENT_EXTN_PWP;