1 PACKAGE PA_PROJECT_FUNDINGS_PKG as
2 /* $Header: PAINPFDS.pls 120.1 2005/08/05 00:16:14 rgandhi noship $ */
3
4
5 PROCEDURE Insert_Row(
6 X_Rowid IN OUT NOCOPY VARCHAR2,/*File.sql.39*/
7 X_Project_Funding_Id IN OUT NOCOPY NUMBER,/*File.sql.39*/
8 X_Last_Update_Date IN DATE,
9 X_Last_Updated_By IN NUMBER,
10 X_Creation_Date IN DATE,
11 X_Created_By IN NUMBER,
12 X_Last_Update_Login IN NUMBER,
13 X_Agreement_Id IN NUMBER,
14 X_Project_Id IN NUMBER,
15 X_Task_Id IN NUMBER,
16 X_Budget_Type_Code IN VARCHAR2,
17 X_Allocated_Amount IN NUMBER,
18 X_Date_Allocated IN DATE,
19 X_Attribute_Category IN VARCHAR2,
20 X_Control_Item_ID IN NUMBER DEFAULT NULL, /* Added for FP_M changes */
21 X_Attribute1 IN VARCHAR2,
22 X_Attribute2 IN VARCHAR2,
23 X_Attribute3 IN VARCHAR2,
24 X_Attribute4 IN VARCHAR2,
25 X_Attribute5 IN VARCHAR2,
26 X_Attribute6 IN VARCHAR2,
27 X_Attribute7 IN VARCHAR2,
28 X_Attribute8 IN VARCHAR2,
29 X_Attribute9 IN VARCHAR2,
30 X_Attribute10 IN VARCHAR2,
31 X_pm_funding_reference IN VARCHAR2,
32 X_pm_product_code IN VARCHAR2,
33 x_funding_currency_code IN VARCHAR2,
34 x_project_currency_code IN VARCHAR2,
35 x_project_rate_type IN VARCHAR2,
36 x_project_rate_date IN DATE,
37 x_project_exchange_rate IN NUMBER,
38 x_project_allocated_amount IN NUMBER,
39 x_projfunc_currency_code IN VARCHAR2,
40 x_projfunc_rate_type IN VARCHAR2,
41 x_projfunc_rate_date IN DATE,
42 x_projfunc_exchange_rate IN NUMBER,
43 x_projfunc_allocated_amount IN NUMBER,
44 x_invproc_currency_code IN VARCHAR2,
45 x_invproc_rate_type IN VARCHAR2,
46 x_invproc_rate_date IN DATE,
47 x_invproc_exchange_rate IN NUMBER,
48 x_invproc_allocated_amount IN NUMBER,
49 x_revproc_currency_code IN VARCHAR2,
50 x_revproc_rate_type IN VARCHAR2,
51 x_revproc_rate_date IN DATE,
52 x_revproc_exchange_rate IN NUMBER,
53 x_revproc_allocated_amount IN NUMBER,
54 x_funding_category IN VARCHAR2, /* For Bug 2244796 */
55 x_revaluation_through_date IN DATE DEFAULT NULL,
56 x_revaluation_rate_date IN DATE DEFAULT NULL,
57 x_reval_projfunc_rate_type IN VARCHAR2 DEFAULT NULL,
58 x_reval_invproc_rate_type IN VARCHAR2 DEFAULT NULL,
59 x_revaluation_projfunc_rate IN NUMBER DEFAULT NULL,
60 x_revaluation_invproc_rate IN NUMBER DEFAULT NULL,
61 x_funding_inv_applied_amount IN NUMBER DEFAULT NULL,
62 x_funding_inv_due_amount IN NUMBER DEFAULT NULL,
63 x_funding_backlog_amount IN NUMBER DEFAULT NULL,
64 x_projfunc_realized_gains_amt IN NUMBER DEFAULT NULL,
65 x_projfunc_realized_losses_amt IN NUMBER DEFAULT NULL,
66 x_projfunc_inv_applied_amount IN NUMBER DEFAULT NULL,
67 x_projfunc_inv_due_amount IN NUMBER DEFAULT NULL,
68 x_projfunc_backlog_amount IN NUMBER DEFAULT NULL,
69 x_non_updateable_flag IN VARCHAR2 DEFAULT NULL,
70 x_invproc_backlog_amount IN NUMBER DEFAULT NULL,
71 x_funding_reval_amount IN NUMBER DEFAULT NULL,
72 x_projfunc_reval_amount IN NUMBER DEFAULT NULL,
73 x_projfunc_revalued_amount IN NUMBER DEFAULT NULL,
74 x_invproc_reval_amount IN NUMBER DEFAULT NULL,
75 x_invproc_revalued_amount IN NUMBER DEFAULT NULL,
76 x_funding_revaluation_factor IN NUMBER DEFAULT NULL,
77 x_request_id IN NUMBER DEFAULT NULL,
78 x_program_application_id IN NUMBER DEFAULT NULL,
79 x_program_id IN NUMBER DEFAULT NULL,
80 x_program_update_date IN DATE DEFAULT NULL
81 );
82
83 PROCEDURE Lock_Row(
84 X_Rowid IN VARCHAR2,
85 X_Project_Funding_Id IN NUMBER,
86 X_Agreement_Id IN NUMBER,
87 X_Project_Id IN NUMBER,
88 X_Task_Id IN NUMBER,
89 X_Budget_Type_Code IN VARCHAR2,
90 X_Allocated_Amount IN NUMBER,
91 X_Date_Allocated IN DATE,
92 X_Attribute_Category IN VARCHAR2,
93 X_Attribute1 IN VARCHAR2,
94 X_Attribute2 IN VARCHAR2,
95 X_Attribute3 IN VARCHAR2,
96 X_Attribute4 IN VARCHAR2,
97 X_Attribute5 IN VARCHAR2,
98 X_Attribute6 IN VARCHAR2,
99 X_Attribute7 IN VARCHAR2,
100 X_Attribute8 IN VARCHAR2,
101 X_Attribute9 IN VARCHAR2,
102 X_Attribute10 IN VARCHAR2,
103 X_pm_funding_reference IN VARCHAR2,
104 X_pm_product_code IN VARCHAR2,
105 x_funding_currency_code IN VARCHAR2,
106 x_project_currency_code IN VARCHAR2,
107 x_project_rate_type IN VARCHAR2,
108 x_project_rate_date IN DATE,
109 x_project_exchange_rate IN NUMBER,
110 x_project_allocated_amount IN NUMBER,
111 x_projfunc_currency_code IN VARCHAR2,
112 x_projfunc_rate_type IN VARCHAR2,
113 x_projfunc_rate_date IN DATE,
114 x_projfunc_exchange_rate IN NUMBER,
115 x_projfunc_allocated_amount IN NUMBER,
116 X_funding_category IN VARCHAR2 /* For Bug 2244796 */
117 );
118
119
120
121 PROCEDURE Update_Row(
122 X_Rowid IN VARCHAR2,
123 X_Project_Funding_Id IN NUMBER,
124 X_Last_Update_Date IN DATE,
125 X_Last_Updated_By IN NUMBER,
126 X_Last_Update_Login IN NUMBER,
127 X_Agreement_Id IN NUMBER,
128 X_Project_Id IN NUMBER,
129 X_Task_Id IN NUMBER,
130 X_Budget_Type_Code IN VARCHAR2,
131 X_Allocated_Amount IN NUMBER,
132 X_Date_Allocated IN DATE,
133 X_Attribute_Category IN VARCHAR2,
134 X_Attribute1 IN VARCHAR2,
135 X_Attribute2 IN VARCHAR2,
136 X_Attribute3 IN VARCHAR2,
137 X_Attribute4 IN VARCHAR2,
138 X_Attribute5 IN VARCHAR2,
139 X_Attribute6 IN VARCHAR2,
140 X_Attribute7 IN VARCHAR2,
141 X_Attribute8 IN VARCHAR2,
142 X_Attribute9 IN VARCHAR2,
143 X_Attribute10 IN VARCHAR2,
144 X_pm_funding_reference IN VARCHAR2,
145 X_pm_product_code IN VARCHAR2,
146 x_funding_currency_code IN VARCHAR2,
147 x_project_currency_code IN VARCHAR2,
148 x_project_rate_type IN VARCHAR2,
149 x_project_rate_date IN DATE,
150 x_project_exchange_rate IN NUMBER,
151 x_project_allocated_amount IN NUMBER,
152 x_projfunc_currency_code IN VARCHAR2,
153 x_projfunc_rate_type IN VARCHAR2,
154 x_projfunc_rate_date IN DATE,
155 x_projfunc_exchange_rate IN NUMBER,
156 x_projfunc_allocated_amount IN NUMBER,
157 x_invproc_currency_code IN VARCHAR2,
158 x_invproc_rate_type IN VARCHAR2,
159 x_invproc_rate_date IN DATE,
160 x_invproc_exchange_rate IN NUMBER,
161 x_invproc_allocated_amount IN NUMBER,
162 x_revproc_currency_code IN VARCHAR2,
163 x_revproc_rate_type IN VARCHAR2,
164 x_revproc_rate_date IN DATE,
165 x_revproc_exchange_rate IN NUMBER,
166 x_revproc_allocated_amount IN NUMBER,
167 X_funding_category IN VARCHAR2 /* For Bug 2244796 */
168 );
169
170 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
171
172 END PA_PROJECT_FUNDINGS_PKG;