[Home] [Help]
PACKAGE: APPS.PO_REQ_DISTRIBUTIONS_PKG1
Source
1 PACKAGE PO_REQ_DISTRIBUTIONS_PKG1 AUTHID CURRENT_USER as
2 /* $Header: POXRID1S.pls 120.1 2010/02/28 14:03:01 ssreekum ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Distribution_Id IN OUT NOCOPY NUMBER,
7 X_Last_Update_Date DATE,
8 X_Last_Updated_By NUMBER,
9 X_Requisition_Line_Id NUMBER,
10 X_Set_Of_Books_Id NUMBER,
11 X_Code_Combination_Id NUMBER,
12 X_Req_Line_Quantity NUMBER,
13 X_Req_Line_Amount NUMBER, -- <SERVICES FPJ>
14 X_Req_Line_Currency_Amount NUMBER, -- <SERVICES FPJ>
15 X_Last_Update_Login NUMBER,
16 X_Creation_Date DATE,
17 X_Created_By NUMBER,
18 X_Encumbered_Flag VARCHAR2,
19 X_Gl_Encumbered_Date DATE,
20 X_Gl_Encumbered_Period_Name VARCHAR2,
21 X_Gl_Cancelled_Date DATE,
22 X_Failed_Funds_Lookup_Code VARCHAR2,
23 X_Encumbered_Amount NUMBER,
24 X_Budget_Account_Id NUMBER,
25 X_Accrual_Account_Id NUMBER,
26 X_Variance_Account_Id NUMBER,
27 X_Prevent_Encumbrance_Flag VARCHAR2,
28 X_Attribute_Category VARCHAR2,
29 X_Attribute1 VARCHAR2,
30 X_Attribute2 VARCHAR2,
31 X_Attribute3 VARCHAR2,
32 X_Attribute4 VARCHAR2,
33 X_Attribute5 VARCHAR2,
34 X_Attribute6 VARCHAR2,
35 X_Attribute7 VARCHAR2,
36 X_Attribute8 VARCHAR2,
37 X_Attribute9 VARCHAR2,
38 X_Attribute10 VARCHAR2,
39 X_Attribute11 VARCHAR2,
40 X_Attribute12 VARCHAR2,
41 X_Attribute13 VARCHAR2,
42 X_Attribute14 VARCHAR2,
43 X_Attribute15 VARCHAR2,
44 X_Ussgl_Transaction_Code VARCHAR2,
45 X_Government_Context VARCHAR2,
46 X_Project_Id NUMBER,
47 X_Task_Id NUMBER,
48 X_Expenditure_Type VARCHAR2,
49 X_Project_Accounting_Context VARCHAR2,
50 X_Expenditure_Organization_Id NUMBER,
51 X_Gl_Closed_Date DATE,
52 X_Source_Req_Distribution_Id NUMBER,
53 X_Distribution_Num NUMBER,
54 X_Project_Related_Flag VARCHAR2,
55 X_Expenditure_Item_Date DATE,
56 X_End_Item_Unit_Number VARCHAR2 DEFAULT NULL,
57 X_Recovery_Rate NUMBER,
58 X_Recoverable_Tax NUMBER,
59 X_Nonrecoverable_Tax NUMBER,
60 X_Tax_Recovery_Override_Flag VARCHAR2,
61 -- OGM_0.0 changes
62 X_Award_id NUMBER DEFAULT NULL ,
63 --togeorge 10/03/2000
64 -- added oke columns
65 x_oke_contract_line_id NUMBER default null,
66 x_oke_contract_deliverable_id NUMBER default null,
67 p_org_id IN NUMBER default null, -- <R12 MOAC>
68 p_partial_funded_flag IN VARCHAR2 DEFAULT NULL /* <<CLM Partial Funding Code Changes>> */
69 );
70
71
72 PROCEDURE Update_Row(X_Rowid VARCHAR2,
73 X_Distribution_Id NUMBER,
74 X_Last_Update_Date DATE,
75 X_Last_Updated_By NUMBER,
76 X_Requisition_Line_Id NUMBER,
77 X_Set_Of_Books_Id NUMBER,
78 X_Code_Combination_Id NUMBER,
79 X_Req_Line_Quantity NUMBER,
80 X_Req_Line_Amount NUMBER, -- <SERVICES FPJ>
81 X_Req_Line_Currency_Amount NUMBER, -- <SERVICES FPJ>
82 X_Last_Update_Login NUMBER,
83 X_Encumbered_Flag VARCHAR2,
84 X_Gl_Encumbered_Date DATE,
85 X_Gl_Encumbered_Period_Name VARCHAR2,
86 X_Gl_Cancelled_Date DATE,
87 X_Failed_Funds_Lookup_Code VARCHAR2,
88 X_Encumbered_Amount NUMBER,
89 X_Budget_Account_Id NUMBER,
90 X_Accrual_Account_Id NUMBER,
91 X_Variance_Account_Id NUMBER,
92 X_Prevent_Encumbrance_Flag VARCHAR2,
93 X_Attribute_Category VARCHAR2,
94 X_Attribute1 VARCHAR2,
95 X_Attribute2 VARCHAR2,
96 X_Attribute3 VARCHAR2,
97 X_Attribute4 VARCHAR2,
98 X_Attribute5 VARCHAR2,
99 X_Attribute6 VARCHAR2,
100 X_Attribute7 VARCHAR2,
101 X_Attribute8 VARCHAR2,
102 X_Attribute9 VARCHAR2,
103 X_Attribute10 VARCHAR2,
104 X_Attribute11 VARCHAR2,
105 X_Attribute12 VARCHAR2,
106 X_Attribute13 VARCHAR2,
107 X_Attribute14 VARCHAR2,
108 X_Attribute15 VARCHAR2,
109 X_Ussgl_Transaction_Code VARCHAR2,
110 X_Government_Context VARCHAR2,
111 X_Project_Id NUMBER,
112 X_Task_Id NUMBER,
113 X_Expenditure_Type VARCHAR2,
114 X_Project_Accounting_Context VARCHAR2,
115 X_Expenditure_Organization_Id NUMBER,
116 X_Gl_Closed_Date DATE,
117 X_Source_Req_Distribution_Id NUMBER,
118 X_Distribution_Num NUMBER,
119 X_Project_Related_Flag VARCHAR2,
120 X_Expenditure_Item_Date DATE,
121 X_End_Item_Unit_Number VARCHAR2 DEFAULT NULL,
122 X_Recovery_Rate NUMBER,
123 X_Recoverable_Tax NUMBER,
124 X_Nonrecoverable_Tax NUMBER,
125 X_Tax_Recovery_Override_Flag VARCHAR2,
126 -- OGM_0.0 changes
127 X_Award_id NUMBER DEFAULT NULL ,
128 --togeorge 10/03/2000
129 -- added oke columns
130 x_oke_contract_line_id NUMBER default null,
131 x_oke_contract_deliverable_id NUMBER default null
132 );
133
134 END PO_REQ_DISTRIBUTIONS_PKG1;