[Home] [Help]
PACKAGE: APPS.PO_DISTRIBUTIONS_PKG1
Source
1 PACKAGE PO_DISTRIBUTIONS_PKG1 as
2 /* $Header: POXP1PDS.pls 120.0 2005/06/02 15:11:38 appldev noship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Po_Distribution_Id IN OUT NOCOPY NUMBER,
7 X_Last_Update_Date DATE,
8 X_Last_Updated_By NUMBER,
9 X_Po_Header_Id NUMBER,
10 X_Po_Line_Id NUMBER,
11 X_Line_Location_Id NUMBER,
12 X_Set_Of_Books_Id NUMBER,
13 X_Code_Combination_Id NUMBER,
14 X_Quantity_Ordered NUMBER,
15 X_Last_Update_Login NUMBER,
16 X_Creation_Date DATE,
17 X_Created_By NUMBER,
18 X_Po_Release_Id NUMBER,
19 X_Quantity_Delivered NUMBER,
20 X_Quantity_Billed NUMBER,
21 X_Quantity_Cancelled NUMBER,
22 X_Req_Header_Reference_Num VARCHAR2,
23 X_Req_Line_Reference_Num VARCHAR2,
24 X_Req_Distribution_Id NUMBER,
25 X_Deliver_To_Location_Id NUMBER,
26 X_Deliver_To_Person_Id NUMBER,
27 X_Rate_Date DATE,
28 X_Rate NUMBER,
29 X_Amount_Billed NUMBER,
30 X_Accrued_Flag VARCHAR2,
31 X_Encumbered_Flag VARCHAR2,
32 X_Encumbered_Amount NUMBER,
33 X_Unencumbered_Quantity NUMBER,
34 X_Unencumbered_Amount NUMBER,
35 X_Failed_Funds_Lookup_Code VARCHAR2,
36 X_Gl_Encumbered_Date DATE,
37 X_Gl_Encumbered_Period_Name VARCHAR2,
38 X_Gl_Cancelled_Date DATE,
39 X_Destination_Type_Code VARCHAR2,
40 X_Destination_Organization_Id NUMBER,
41 X_Destination_Subinventory VARCHAR2,
42 X_Attribute_Category VARCHAR2,
43 X_Attribute1 VARCHAR2,
44 X_Attribute2 VARCHAR2,
45 X_Attribute3 VARCHAR2,
46 X_Attribute4 VARCHAR2,
47 X_Attribute5 VARCHAR2,
48 X_Attribute6 VARCHAR2,
49 X_Attribute7 VARCHAR2,
50 X_Attribute8 VARCHAR2,
51 X_Attribute9 VARCHAR2,
52 X_Attribute10 VARCHAR2,
53 X_Attribute11 VARCHAR2,
54 X_Attribute12 VARCHAR2,
55 X_Attribute13 VARCHAR2,
56 X_Attribute14 VARCHAR2,
57 X_Attribute15 VARCHAR2,
58 X_Wip_Entity_Id NUMBER,
59 X_Wip_Operation_Seq_Num NUMBER,
60 X_Wip_Resource_Seq_Num NUMBER,
61 X_Wip_Repetitive_Schedule_Id NUMBER,
62 X_Wip_Line_Id NUMBER,
63 X_Bom_Resource_Id NUMBER,
64 X_Budget_Account_Id NUMBER,
65 X_Accrual_Account_Id NUMBER,
66 X_Variance_Account_Id NUMBER,
67
68 --< Shared Proc FPJ Start >
69 p_dest_charge_account_id NUMBER,
70 p_dest_variance_account_id NUMBER,
71 --< Shared Proc FPJ End >
72
73 X_Prevent_Encumbrance_Flag VARCHAR2,
74 X_Ussgl_Transaction_Code VARCHAR2,
75 X_Government_Context VARCHAR2,
76 X_Destination_Context VARCHAR2,
77 X_Distribution_Num NUMBER,
78 X_Source_Distribution_Id NUMBER,
79 X_Project_Id NUMBER,
80 X_Task_Id NUMBER,
81 X_Expenditure_Type VARCHAR2,
82 X_Project_Accounting_Context VARCHAR2,
83 X_Expenditure_Organization_Id NUMBER,
84 X_Gl_Closed_Date DATE,
85 X_Accrue_On_Receipt_Flag VARCHAR2,
86 X_Expenditure_Item_Date DATE,
87 X_End_Item_Unit_Number VARCHAR2 DEFAULT NULL,
88 X_Recovery_Rate NUMBER,
89 X_Recoverable_Tax NUMBER,
90 X_Nonrecoverable_Tax NUMBER,
91 X_Tax_Recovery_Override_Flag VARCHAR2,
92 X_award_id NUMBER DEFAULT NULL, -- OGM_0.0 changes
93 --togeorge 09/28/2000
94 --added oke variables
95 X_oke_contract_line_id IN NUMBER default null,
96 X_oke_contract_deliverable_id IN NUMBER default null,
97 X_amount_ordered IN NUMBER default null, -- <SERVICES FPJ>
98 X_distribution_type IN VARCHAR2 default null, -- <ENCUMBRNACE FPJ>
99 X_amount_to_encumber IN NUMBER default null, -- <ENCUMBRNACE FPJ>
100 p_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
101 );
102
103 PROCEDURE Update_Row(X_Rowid VARCHAR2,
104 X_Po_Distribution_Id NUMBER,
105 X_Last_Update_Date DATE,
106 X_Last_Updated_By NUMBER,
107 X_Po_Header_Id NUMBER,
108 X_Po_Line_Id NUMBER,
109 X_Line_Location_Id NUMBER,
110 X_Set_Of_Books_Id NUMBER,
111 X_Code_Combination_Id NUMBER,
112 X_Quantity_Ordered NUMBER,
113 X_Last_Update_Login NUMBER,
114 X_Po_Release_Id NUMBER,
115 X_Quantity_Delivered NUMBER,
116 X_Quantity_Billed NUMBER,
117 X_Quantity_Cancelled NUMBER,
118 X_Req_Header_Reference_Num VARCHAR2,
119 X_Req_Line_Reference_Num VARCHAR2,
120 X_Req_Distribution_Id NUMBER,
121 X_Deliver_To_Location_Id NUMBER,
122 X_Deliver_To_Person_Id NUMBER,
123 X_Rate_Date DATE,
124 X_Rate NUMBER,
125 X_Amount_Billed NUMBER,
126 X_Accrued_Flag VARCHAR2,
127 X_Encumbered_Flag VARCHAR2,
128 X_Encumbered_Amount NUMBER,
129 X_Unencumbered_Quantity NUMBER,
130 X_Unencumbered_Amount NUMBER,
131 X_Failed_Funds_Lookup_Code VARCHAR2,
132 X_Gl_Encumbered_Date DATE,
133 X_Gl_Encumbered_Period_Name VARCHAR2,
134 X_Gl_Cancelled_Date DATE,
135 X_Destination_Type_Code VARCHAR2,
136 X_Destination_Organization_Id NUMBER,
137 X_Destination_Subinventory VARCHAR2,
138 X_Attribute_Category VARCHAR2,
139 X_Attribute1 VARCHAR2,
140 X_Attribute2 VARCHAR2,
141 X_Attribute3 VARCHAR2,
142 X_Attribute4 VARCHAR2,
143 X_Attribute5 VARCHAR2,
144 X_Attribute6 VARCHAR2,
145 X_Attribute7 VARCHAR2,
146 X_Attribute8 VARCHAR2,
147 X_Attribute9 VARCHAR2,
148 X_Attribute10 VARCHAR2,
149 X_Attribute11 VARCHAR2,
150 X_Attribute12 VARCHAR2,
151 X_Attribute13 VARCHAR2,
152 X_Attribute14 VARCHAR2,
153 X_Attribute15 VARCHAR2,
154 X_Wip_Entity_Id NUMBER,
155 X_Wip_Operation_Seq_Num NUMBER,
156 X_Wip_Resource_Seq_Num NUMBER,
157 X_Wip_Repetitive_Schedule_Id NUMBER,
158 X_Wip_Line_Id NUMBER,
159 X_Bom_Resource_Id NUMBER,
160 X_Budget_Account_Id NUMBER,
161 X_Accrual_Account_Id NUMBER,
162 X_Variance_Account_Id NUMBER,
163
164 --< Shared Proc FPJ Start >
165 p_dest_charge_account_id NUMBER,
166 p_dest_variance_account_id NUMBER,
167 --< Shared Proc FPJ End >
168
169 X_Prevent_Encumbrance_Flag VARCHAR2,
170 X_Ussgl_Transaction_Code VARCHAR2,
171 X_Government_Context VARCHAR2,
172 X_Destination_Context VARCHAR2,
173 X_Distribution_Num NUMBER,
174 X_Source_Distribution_Id NUMBER,
175 X_Project_Id NUMBER,
176 X_Task_Id NUMBER,
177 X_Expenditure_Type VARCHAR2,
178 X_Project_Accounting_Context VARCHAR2,
179 X_Expenditure_Organization_Id NUMBER,
180 X_Gl_Closed_Date DATE,
181 X_Accrue_On_Receipt_Flag VARCHAR2,
182 X_Expenditure_Item_Date DATE,
183 X_need_to_approve IN OUT NOCOPY NUMBER,
184 X_End_Item_Unit_Number VARCHAR2 DEFAULT NULL,
185 X_Recovery_Rate NUMBER,
186 X_Recoverable_Tax NUMBER,
187 X_Nonrecoverable_Tax NUMBER,
188 X_Tax_Recovery_Override_Flag VARCHAR2,
189 X_award_id NUMBER DEFAULT NULL, --OGM_0.0 changes..
190 --togeorge 09/28/2000
191 --added oke variables
192 X_oke_contract_line_id IN NUMBER default null,
193 X_oke_contract_deliverable_id IN NUMBER default null,
194 X_amount_ordered IN NUMBER default null, -- <SERVICES FPJ>
195 X_distribution_type IN VARCHAR2 default null, -- <ENCUMBRANCE FPJ>
196 X_amount_to_encumber IN NUMBER default null -- <ENCUMBRANCE FPJ>
197 );
198
199 END PO_DISTRIBUTIONS_PKG1;