[Home] [Help]
PACKAGE: APPS.PO_LINES_SV3
Source
1 PACKAGE PO_LINES_SV3 AUTHID CURRENT_USER as
2 /* $Header: POXPOL3S.pls 120.0 2005/06/01 20:57:13 appldev noship $ */
3
4
5 /*===========================================================================
6 PACKAGE NAME: PO_LINES_SV3
7
8 DESCRIPTION: This package contains the server side Line level
9 Application Program Interfaces (APIs).
10
11 CLIENT/SERVER: Server
12
13 OWNER: Sudha Iyer
14
15 FUNCTION/PROCEDURE: insert_line()
16
17 ===========================================================================*/
18 /*===========================================================================
19 PROCEDURE NAME: insert_line()
20
21 DESCRIPTION: This procedure will be inserting a po line.
22 After inserting this line, it checks to see if the
23 document's revision has to be incremented, the doc
24 has to be unapproved. If possible it autocreates
25 a shipment and a distribution.
26
27
28 PARAMETERS:
29
30 DESIGN REFERENCES:
31
32 ALGORITHM:
33
34 NOTES:
35
36 OPEN ISSUES:
37
38 CLOSED ISSUES:
39
40 CHANGE HISTORY: Created 26-Jul-95 SIYER
41
42 Added 5 fields 08-feb-00 PBAMB
43 Preetam Bamb (GML-OPM)
44 Added the following fields to replace PO_LINES flexfield
45 Bug# 1056597 X_Base_Uom,X_Base_qty,X_Secondary_Uom,
46 X_Secondary_Qty,X_Qc_Grade
47 Mahesh Chandak(GML)bug# 1548597 base_uom and base_qty
48 won't be used in the future.we are keeping secondary_
49 uom,secondary_qty and qc_grade for supporting Common
50 Purchasing. we will have 3 new fields secondary_unit_of
51 _measure ,secondary_quantity and preferred_grade column
52 in the table.
53
54 ===========================================================================*/
55
56 procedure insert_line(X_Rowid IN OUT NOCOPY VARCHAR2,
57 X_Po_Line_Id IN OUT NOCOPY NUMBER,
58 X_Last_Update_Date DATE,
59 X_Last_Updated_By NUMBER,
60 X_Po_Header_Id NUMBER,
61 X_Line_Type_Id NUMBER,
62 X_Line_Num NUMBER,
63 X_Last_Update_Login NUMBER,
64 X_Creation_Date DATE,
65 X_Created_By NUMBER,
66 X_Item_Id NUMBER,
67 X_Item_Revision VARCHAR2,
68 X_Category_Id NUMBER,
69 X_Item_Description VARCHAR2,
70 X_Unit_Meas_Lookup_Code VARCHAR2,
71 X_Quantity_Committed NUMBER,
72 X_Committed_Amount NUMBER,
73 X_Allow_Price_Override_Flag VARCHAR2,
74 X_Not_To_Exceed_Price NUMBER,
75 X_List_Price_Per_Unit NUMBER,
76 X_Unit_Price NUMBER,
77 X_Quantity NUMBER,
78 X_Un_Number_Id NUMBER,
79 X_Hazard_Class_Id NUMBER,
80 X_Note_To_Vendor VARCHAR2,
81 X_From_Header_Id NUMBER,
82 X_From_Line_Id NUMBER,
83 x_from_line_location_id NUMBER, -- <SERVICES FPJ>
84 X_Min_Order_Quantity NUMBER,
85 X_Max_Order_Quantity NUMBER,
86 X_Qty_Rcv_Tolerance NUMBER,
87 X_Over_Tolerance_Error_Flag VARCHAR2,
88 X_Market_Price NUMBER,
89 X_Unordered_Flag VARCHAR2,
90 X_Closed_Flag VARCHAR2,
91 X_User_Hold_Flag VARCHAR2,
92 X_Cancel_Flag VARCHAR2,
93 X_Cancelled_By NUMBER,
94 X_Cancel_Date DATE,
95 X_Cancel_Reason VARCHAR2,
96 X_Firm_Status_Lookup_Code VARCHAR2,
97 X_Firm_Date DATE,
98 X_Vendor_Product_Num VARCHAR2,
99 X_Contract_Num VARCHAR2,
100 X_Taxable_Flag VARCHAR2,
101 X_Tax_Code_Id NUMBER,
102 X_Type_1099 VARCHAR2,
103 X_Capital_Expense_Flag VARCHAR2,
104 X_Negotiated_By_Preparer_Flag VARCHAR2,
105 X_Attribute_Category VARCHAR2,
106 X_Attribute1 VARCHAR2,
107 X_Attribute2 VARCHAR2,
108 X_Attribute3 VARCHAR2,
109 X_Attribute4 VARCHAR2,
110 X_Attribute5 VARCHAR2,
111 X_Attribute6 VARCHAR2,
112 X_Attribute7 VARCHAR2,
113 X_Attribute8 VARCHAR2,
114 X_Attribute9 VARCHAR2,
115 X_Attribute10 VARCHAR2,
116 X_Reference_Num VARCHAR2,
117 X_Attribute11 VARCHAR2,
118 X_Attribute12 VARCHAR2,
119 X_Attribute13 VARCHAR2,
120 X_Attribute14 VARCHAR2,
121 X_Attribute15 VARCHAR2,
122 X_Min_Release_Amount NUMBER,
123 X_Price_Type_Lookup_Code VARCHAR2,
124 X_Closed_Code VARCHAR2,
125 X_Price_Break_Lookup_Code VARCHAR2,
126 X_Ussgl_Transaction_Code VARCHAR2,
127 X_Government_Context VARCHAR2,
128 X_Closed_Date DATE,
129 X_Closed_Reason VARCHAR2,
130 X_Closed_By NUMBER,
131 X_Transaction_Reason_Code VARCHAR2,
132 X_revise_header BOOLEAN,
133 X_revision_num NUMBER,
134 -- Bug 902976, zxzhang, 10/04/99
135 -- Change REVISED_DATE from VarChar(25) to Date.
136 -- X_revised_date VARCHAR2,
137 X_revised_date DATE,
138 X_approved_flag VARCHAR2,
139 X_header_row_id VARCHAR2,
140 X_type_lookup_code VARCHAR2,
141 X_ship_to_location_id NUMBER,
142 X_ship_org_id NUMBER,
143 X_need_by_date DATE,
144 X_promised_date DATE,
145 X_receipt_required_flag VARCHAR2,
146 X_invoice_close_tolerance NUMBER,
147 X_receive_close_tolerance NUMBER,
148 X_planned_item_flag VARCHAR2,
149 X_outside_operation_flag VARCHAR2,
150 X_destination_type_code VARCHAR2,
151 X_expense_accrual_code VARCHAR2,
152 X_dist_blk_status VARCHAR2,
153 X_accrue_on_receipt_flag IN OUT NOCOPY VARCHAR2,
154 X_ok_to_autocreate_ship VARCHAR2,
155 X_autocreated_ship IN OUT NOCOPY BOOLEAN,
156 X_line_location_id IN OUT NOCOPY NUMBER,
157 X_vendor_id NUMBER,
158 X_Global_Attribute_Category VARCHAR2,
159 X_Global_Attribute1 VARCHAR2,
160 X_Global_Attribute2 VARCHAR2,
161 X_Global_Attribute3 VARCHAR2,
162 X_Global_Attribute4 VARCHAR2,
163 X_Global_Attribute5 VARCHAR2,
164 X_Global_Attribute6 VARCHAR2,
165 X_Global_Attribute7 VARCHAR2,
166 X_Global_Attribute8 VARCHAR2,
167 X_Global_Attribute9 VARCHAR2,
168 X_Global_Attribute10 VARCHAR2,
169 X_Global_Attribute11 VARCHAR2,
170 X_Global_Attribute12 VARCHAR2,
171 X_Global_Attribute13 VARCHAR2,
172 X_Global_Attribute14 VARCHAR2,
173 X_Global_Attribute15 VARCHAR2,
174 X_Global_Attribute16 VARCHAR2,
175 X_Global_Attribute17 VARCHAR2,
176 X_Global_Attribute18 VARCHAR2,
177 X_Global_Attribute19 VARCHAR2,
178 X_Global_Attribute20 VARCHAR2,
179 X_Expiration_Date DATE,
180 -- Preetam Bamb (GML-OPM) Added the following fields to replace PO_LINES flexfield
181 -- Bug# 1056597
182 -- Mahesh Chandak(GML-OPM).Add secondary_unit_of_measure,secondary_quantity,preferred_grade.
183 X_Base_Uom VARCHAR2,
184 X_Base_Qty NUMBER,
185 X_Secondary_Uom VARCHAR2,
186 X_Secondary_Qty NUMBER,
187 X_Qc_Grade VARCHAR2,
188 --togeorge 10/03/2000
189 --added oke columns
190 X_oke_contract_header_id NUMBER default null,
191 X_oke_contract_version_id NUMBER default null,
192 -- mchandak 1548597
193 X_Secondary_Unit_Of_Measure VARCHAR2 default null,
194 X_Secondary_Quantity NUMBER default null,
195 X_Preferred_Grade VARCHAR2 default null,
196 p_contract_id IN NUMBER DEFAULT NULL, -- <GC FPJ>
197 X_job_id IN NUMBER default null, -- <SERVICES FPJ>
198 X_contractor_first_name IN VARCHAR2 default null, -- <SERVICES FPJ>
199 X_contractor_last_name IN VARCHAR2 default null, -- <SERVICES FPJ>
200 X_assignment_start_date IN DATE default null, -- <SERVICES FPJ>
201 X_amount_db IN NUMBER default null, -- <SERVICES FPJ>
202 X_order_type_lookup_code IN VARCHAR2 default null, -- <SERVICES FPJ>
203 X_purchase_basis IN VARCHAR2 default null, -- <SERVICES FPJ>
204 X_matching_basis IN VARCHAR2 default null, -- <SERVICES FPJ>
205 -- <FPJ Advanced Price START>
206 X_Base_Unit_Price NUMBER DEFAULT NULL,
207 -- <FPJ Advanced Price END>
208 p_manual_price_change_flag IN VARCHAR2 default null, -- <Manual Price Override FPJ>
209 p_consigned_from_supplier_flag IN VARCHAR2 default null, --bug 3523348
210 p_org_id IN NUMBER default null -- <R12 MOAC>
211 );
212
213
214 END PO_LINES_SV3;