1: PACKAGE BODY PO_REQUISITION_LINES_PKG2 as
2: /* $Header: POXRIL3B.pls 120.3.12010000.2 2008/09/22 18:13:38 rohbansa ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Requisition_Line_Id IN OUT NOCOPY NUMBER,
123: -- Bug #3161499
124: p_negotiated_by_preparer_flag in VARCHAR2 DEFAULT NULL, --
125: p_org_id IN NUMBER DEFAULT NULL --
126: ) IS
127: CURSOR C IS SELECT rowid FROM PO_REQUISITION_LINES
128: WHERE requisition_line_id = X_Requisition_Line_Id;
129:
130: CURSOR C2 IS SELECT po_requisition_lines_s.nextval FROM sys.dual;
131:
126: ) IS
127: CURSOR C IS SELECT rowid FROM PO_REQUISITION_LINES
128: WHERE requisition_line_id = X_Requisition_Line_Id;
129:
130: CURSOR C2 IS SELECT po_requisition_lines_s.nextval FROM sys.dual;
131:
132: --
133: x_reqs_in_pool_flag PO_REQUISITION_LINES_ALL.REQS_IN_POOL_FLAG%TYPE;
134: x_auth_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
129:
130: CURSOR C2 IS SELECT po_requisition_lines_s.nextval FROM sys.dual;
131:
132: --
133: x_reqs_in_pool_flag PO_REQUISITION_LINES_ALL.REQS_IN_POOL_FLAG%TYPE;
134: x_auth_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
135: x_contractor_status PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;
136: x_progress VARCHAR2(3) := NULL;
137: x_return_status VARCHAR2(1);
135: x_contractor_status PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;
136: x_progress VARCHAR2(3) := NULL;
137: x_return_status VARCHAR2(1);
138:
139: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
140: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
141: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
142: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
143:
192: l_lead_time,l_manufacturer_id) ;
193:
194: END IF ;
195:
196: INSERT INTO PO_REQUISITION_LINES(
197: requisition_line_id,
198: requisition_header_id,
199: line_num,
200: line_type_id,
464:
465: END Insert_Row;
466:
467:
468: END PO_REQUISITION_LINES_PKG2;