1 PACKAGE PA_DM_NUMBER_CLIENT_EXTN AUTHID CURRENT_USER AS
2 /* $Header: PADMNRXS.pls 120.0.12010000.3 2009/10/21 10:03:32 vchilla noship $ */
3 /*#
4 * Oracle Projects provides a template package that contains a procedure that you can modify to implement
5 * Debit memo number generation. The name of the package is pa_dm_number_client_extn. The name of the
6 * procedure is get_next_number.
7 * @rep:scope public
8 * @rep:product PA
9 * @rep:lifecycle active
10 * @rep:displayname Client Extension for Debit Memo Number Generation
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 * Procedure that can be modified to implement Debit Memo Number Generation
19 * @param p_project_id Identifier of the Project (Project_Id)
20 * @param p_vendor_id Identifier of the Vendor (Vendor_Id)
21 * @param p_vendor_site_id Vendor Site Id
22 * @param p_org_id Org Id
23 * @param p_po_header_id PO Header Id
24 * @param p_ci_id Control Item Id
25 * @param p_dctn_req_date Deduction Request Date
26 * @param p_debit_memo_date Debit Memo Date
27 * @param p_next_number Debit Memo Number to be returned
28 * @rep:paraminfo {@rep:required}
29 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
30 * @rep:paraminfo {@rep:precision 1} {@rep:required}
31 * @param x_msg_count API standard: number of error messages
32 * @rep:paraminfo {@rep:required}
33 * @param x_msg_data API standard: error message
34 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
35 * @rep:scope public
36 * @rep:lifecycle active
37 * @rep:displayname Generate Next Debit Memo Number
38 * @rep:compatibility S
39 */
40
41 PROCEDURE GET_NEXT_NUMBER (
42 p_project_id IN NUMBER
43 ,p_vendor_id IN NUMBER
44 ,p_vendor_site_id IN NUMBER
45 ,p_org_id IN NUMBER
46 ,p_po_header_id IN NUMBER
47 ,p_ci_id IN NUMBER
48 ,p_dctn_req_date IN DATE
49 ,p_debit_memo_date IN DATE
50 ,p_next_number IN OUT NOCOPY VARCHAR2
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2);
54
55 END;
56