APPS.PO_LINE_LOCATIONS_PKG_S0 dependencies on PO_LINE_LOCATIONS

Line 1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S0 as

1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S0 as
2: /* $Header: POXP1PSB.pls 120.6 2005/08/29 00:26:09 vsanjay noship $ */
3:
4: PROCEDURE Insert_Row
5: (

Line 139: CURSOR C IS SELECT rowid FROM PO_LINE_LOCATIONS

135: p_org_id IN NUMBER, --
136: p_outsourced_assembly IN NUMBER default 2 --
137: )
138: IS
139: CURSOR C IS SELECT rowid FROM PO_LINE_LOCATIONS
140: WHERE line_location_id = X_Line_Location_Id;
141:
142: CURSOR C2 IS SELECT po_line_locations_s.nextval FROM sys.dual;
143: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --

Line 142: CURSOR C2 IS SELECT po_line_locations_s.nextval FROM sys.dual;

138: IS
139: CURSOR C IS SELECT rowid FROM PO_LINE_LOCATIONS
140: WHERE line_location_id = X_Line_Location_Id;
141:
142: CURSOR C2 IS SELECT po_line_locations_s.nextval FROM sys.dual;
143: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --
144:
145: BEGIN
146: if (X_Line_Location_Id is NULL) then

Line 143: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --

139: CURSOR C IS SELECT rowid FROM PO_LINE_LOCATIONS
140: WHERE line_location_id = X_Line_Location_Id;
141:
142: CURSOR C2 IS SELECT po_line_locations_s.nextval FROM sys.dual;
143: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type; --
144:
145: BEGIN
146: if (X_Line_Location_Id is NULL) then
147: OPEN C2;

Line 156: INSERT INTO PO_LINE_LOCATIONS(

152: IF X_Shipment_Type in ('STANDARD', 'PLANNED', 'BLANKET', 'SCHEDULED') THEN
153: l_tax_attribute_update_code := 'CREATE';
154: END IF;
155:
156: INSERT INTO PO_LINE_LOCATIONS(
157: line_location_id,
158: last_update_date,
159: last_updated_by,
160: po_header_id,

Line 435: END PO_LINE_LOCATIONS_PKG_S0;

431: Raise NO_DATA_FOUND;
432: end if;
433: CLOSE C;
434: END Insert_Row;
435: END PO_LINE_LOCATIONS_PKG_S0;