1 PACKAGE PA_Client_Extn_Funding_Reval AS
2 /* $Header: PAXBFRCS.pls 120.4 2006/07/25 06:35:51 lveerubh noship $ */
3 /*#
4 * This extension can be customized to specify funding revaluation factor to revise the funding amount.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Funding Revaluation Factor 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
16 /*----------------------------------------------------------------------------*/
17 -- Start of Comments
18 -- API Name : Funding_Revaluation_factor
19 -- Type : Public
20 -- Pre-Reqs : None
21 -- Function : Oracle Projects Billing Client Extension for
22 -- Funding Revalution Factor.
23 -- Parameters :
24 -- IN P_Project_ID IN NUMBER Required
25 -- Project Identifier. Corresponds to the Column
26 -- PROJECT_ID of PA_PROJECTS_ALL Table
27 -- P_Top_Task_ID IN NUMBER Optional
28 -- Top Task Identifier. Corresponds to the Column
29 -- TASK_ID of PA_TASKS Table
30 -- P_Agreement_ID IN NUMBER Required
31 -- Agreement Identifier. Corresponds to the Column
32 -- AGREEMENT_ID of the PA_AGREEMENTS_ALL Table
33 -- P_Funding_Currency IN VARCHAR2 Required
34 -- Funding Currency .
35 -- FUNDING_CURRENCY_CODE of the PA_SUMMARY_PROJECT_FUNDINGS Table
36 -- P_InvProc_Currency IN VARCHAR2 Required
37 -- Invoice Processing Currency .
38 -- INVPROC_CURRENCY_CODE of the PA_SUMMARY_PROJECT_FUNDINGS Table
39 -- P_reval_through_date IN DATE Required
40 -- Revaluation Through Date
41 -- P_reval_rate_date IN DATE Required
42 -- Revaluation Rate Date
43 -- P_reval_rate_type IN VARCHAR2 Required
44 -- Revaluation Rate Type
45 -- P_revaluation_rate IN NUMBER Required
46 -- Revaluation Exchange Rate
47 -- P_Funding_Backlog_Amount IN NUMBER Required
48 -- Backlog Amount in Funding Currency .
49 -- P_Funding_paid_Amount IN NUMBER Required
50 -- Paid Amount in Funding Currency .
51 -- P_Funding_Unpaid_Amount IN NUMBER Required
52 -- Unpaid Amount in Funding Currency .
53 -- P_Projfunc_Backlog_Amount IN NUMBER Required
54 -- Backlog Amount in Project Functional Currency .
55 -- P_Projfunc_paid_Amount IN NUMBER Required
56 -- Paid Amount in Project Functional Currency .
57 -- P_Projfunc_Unpaid_Amount IN NUMBER Required
58 -- Unpaid Amount in Project Functional Currency .
59 -- P_Invproc_Backlog_amount IN NUMBER Optional
60 -- Backlog Amount in Invoice Processing Currency .
61 -- X_funding_reval_factor OUT NUMBER DEFAULT 1
62 -- X_Status OUT VARCHAR2 Optional
63 -- Return Status of the Procedure. Values are
64 -- = 0 - Successfull Execution
65 -- < 0 - Oracle Error
66 -- > 0 - Application Error
67 --
68 -- End of Comments
69 /*----------------------------------------------------------------------------*/
70
71
72
73 /*#
74 * This extension is used to apply a funding revaluation to the funding backlog amount.
75 * @param P_Project_ID Identifier of the project for which the revaluation process will be applied.
76 * Please provide a value.
77 * @rep:paraminfo {@rep:required}
78 * @param P_Top_Task_ID The identifier of the top task
79 * @rep:paraminfo {@rep:precision 1} {@rep:required}
80 * @param P_Agreement_ID Identifier of the agreement for which the revaluation process will be applied
81 * @rep:paraminfo {@rep:required}
82 * @param P_Funding_Currency The funding currency code
83 * @rep:paraminfo {@rep:required}
84 * @param P_Projfunc_currency The project functional currency code
85 * @rep:paraminfo {@rep:required}
86 * @param P_InvProc_Currency The invoice processing currency code
87 * @rep:paraminfo {@rep:required}
88 * @param P_reval_through_date The revaluation through date
89 * @rep:paraminfo {@rep:required}
90 * @param P_reval_rate_date The date for the revaluation rate
91 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
92 * @param P_projfunc_rate_type The rate type of the project functional currency
93 * @rep:paraminfo {@rep:required}
94 * @param P_reval_projfunc_rate The project functional rate for the revaluation
95 * @rep:paraminfo {@rep:required}
96 * @param P_invproc_rate_type The rate type of the invoice processing currency
97 * @rep:paraminfo {@rep:required}
98 * @param P_reval_invproc_rate The revaluation rate for the invoice processing currency
99 * @rep:paraminfo {@rep:required}
100 * @param P_Funding_Backlog_Amount The funding backlog amount
101 * @rep:paraminfo {@rep:required}
102 * @param P_Funding_paid_Amount The paid funding amount
103 * @rep:paraminfo {@rep:required}
104 * @param P_Funding_Unpaid_Amount The unpaid funding amount
105 * @rep:paraminfo {@rep:required}
106 * @param P_Projfunc_Backlog_Amount The backlog amount in project functional currency
107 * @rep:paraminfo {@rep:required}
108 * @param P_Projfunc_paid_Amount The paid amount in project functional currency
109 * @rep:paraminfo {@rep:required}
110 * @param P_Projfunc_Unpaid_Amount The unpaid amount in project functional currency
111 * @rep:paraminfo {@rep:required}
112 * @param P_Invproc_Backlog_amount The backlog amount in invoice processing currency
113 * @rep:paraminfo {@rep:required}
114 * @param X_funding_reval_factor The funding revaluation factor. This factor is applied
115 * to the backlog funding amount.
116 * @rep:paraminfo {@rep:required}
117 * @param X_Status Displays the status of the process. Indicates whether the process had errors or not.
118 * @rep:paraminfo {@rep:required}
119 * @rep:scope public
120 * @rep:lifecycle active
121 * @rep:displayname Funding Revaluation Factor Extension
122 * @rep:compatibility S
123 */
124
125
126 Procedure Funding_Revaluation_factor (
127 P_Project_ID IN NUMBER,
128 P_Top_Task_ID IN NUMBER,
129 P_Agreement_ID IN NUMBER,
130 P_Funding_Currency IN VARCHAR2,
131 P_Projfunc_currency IN VARCHAR2,
132 P_InvProc_Currency IN VARCHAR2,
133 P_reval_through_date IN DATE,
134 P_reval_rate_date IN DATE,
135 P_projfunc_rate_type IN VARCHAR2,
136 P_reval_projfunc_rate IN NUMBER,
137 P_invproc_rate_type IN VARCHAR2,
138 P_reval_invproc_rate IN NUMBER,
139 P_Funding_Backlog_Amount IN NUMBER ,
140 P_Funding_paid_Amount IN NUMBER,
141 P_Funding_Unpaid_Amount IN NUMBER,
142 P_Projfunc_Backlog_Amount IN NUMBER,
143 P_Projfunc_paid_Amount IN NUMBER,
144 P_Projfunc_Unpaid_Amount IN NUMBER,
145 P_Invproc_Backlog_amount IN NUMBER,
146 X_funding_reval_factor OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
147 X_Status OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
148
149 END PA_Client_Extn_Funding_Reval;