1 PACKAGE PA_Client_Extn_Bill_Cycle AUTHID CURRENT_USER AS
2 -- $Header: PAXIBCXS.pls 120.3 2006/07/25 06:36:40 lveerubh noship $
3 /*#
4 * This extension contains a function to derive the next billing date for a project.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Billing Cycle Extension
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_INVOICE
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14 /*----------------------------------------------------------------------------*/
15 -- Start of Comments
16 -- API Name : Get_Next_Billing_Date
17 -- Type : Public
18 -- Pre-Reqs : None
19 -- Function : Oracle Projects Billing Client Extension for Determining
20 -- the Next Billing Date
21 -- Parameters :
22 -- IN X_Project_ID IN NUMBER Required
23 -- Project Identifier. Corresponds to the Column
24 -- PROJECT_ID of PA_PROJECTS_ALL Table
25 -- X_Project_Start_Date IN Date Optional
26 -- Project Start Date. Corresponds to the Column
27 -- START_DATE of PA_PROJECTS_ALL Table
28 -- and used as NVL( START_DATE, CREATION_DATE)
29 -- X_Billing_Cycle_ID IN NUMBER Optional
30 -- Billing Cycle ID. Corresponds to the Column
31 -- BILLING_CYCLE_ID of PA_PROJECTS_ALL Table
32 -- X_Bill_Thru_Date IN DATE Required
33 -- Bill Through Date for the Invoice Generation
34 -- Process.
35 -- X_Last_Bill_Thru_Date IN DATE Required
36 -- Last Bill Through Date. Corresponds to the Column
37 -- BILL_THROUGH_DATE of PA_DRAFT_INVOICES_ALL Table
38 -- RETURNS DATE
39 --
40 -- End of Comments
41 /*#
42 * This function returns a value for the next billing date.
43 * @return Returns the next billing date
44 * @param X_Project_ID The identifier of the project
45 * @rep:paraminfo {@rep:required}
46 * @param X_Project_Start_Date The start date of the project
47 * @rep:paraminfo {@rep:required}
48 * @param X_Billing_Cycle_ID The identifier of the billing cycle code
49 * @rep:paraminfo {@rep:required}
50 * @param X_Bill_Thru_Date The bill through date entered for the process
51 * @rep:paraminfo {@rep:required}
52 * @param X_Last_Bill_Thru_Date The last bill through date of the project
53 * @rep:paraminfo {@rep:required}
54 * @rep:scope public
55 * @rep:lifecycle active
56 * @rep:displayname Get Next Billing Date
57 * @rep:compatibility S
58 */
59 function Get_Next_Billing_Date (
60 X_Project_ID IN Number,
61 X_Project_Start_Date IN Date,
62 X_Billing_Cycle_ID IN Number,
63 X_Bill_Thru_Date IN Date,
64 X_Last_Bill_Thru_Date IN Date
65 ) RETURN Date;
66 pragma RESTRICT_REFERENCES ( Get_Next_Billing_Date, WNDS, WNPS );
67
68 END PA_Client_Extn_Bill_Cycle;
69
[Home] [Help]