1: PACKAGE BODY PO_LINE_LOCATIONS_SV6 AS
2: /* $Header: POXPIISB.pls 120.2.12000000.1 2007/01/16 23:03:58 appldev ship $ */
3:
4: /*================================================================
5:
2: /* $Header: POXPIISB.pls 120.2.12000000.1 2007/01/16 23:03:58 appldev ship $ */
3:
4: /*================================================================
5:
6: PROCEDURE NAME: insert_po_line_locations()
7:
8: ==================================================================*/
9: PROCEDURE insert_po_line_locations(
10: x_line_location_id IN NUMBER,
5:
6: PROCEDURE NAME: insert_po_line_locations()
7:
8: ==================================================================*/
9: PROCEDURE insert_po_line_locations(
10: x_line_location_id IN NUMBER,
11: x_last_update_date IN DATE,
12: x_last_updated_by IN NUMBER,
13: x_po_header_id IN NUMBER,
154: end if;
155: /*
156:
157: if (l_price_override is not null) then
158: INSERT INTO po_line_locations
159: (
160: line_location_id,
161: last_update_date,
162: last_updated_by,
356: );
357:
358: /*
359: else
360: INSERT INTO po_line_locations
361: (
362: line_location_id,
363: last_update_date,
364: last_updated_by,
561: /*
562:
563: EXCEPTION
564: WHEN others THEN
565: po_message_s.sql_error('insert_po_line_locations',
566: x_progress, sqlcode);
567: raise;
568: END insert_po_line_locations;
569:
564: WHEN others THEN
565: po_message_s.sql_error('insert_po_line_locations',
566: x_progress, sqlcode);
567: raise;
568: END insert_po_line_locations;
569:
570: END PO_LINE_LOCATIONS_SV6;
566: x_progress, sqlcode);
567: raise;
568: END insert_po_line_locations;
569:
570: END PO_LINE_LOCATIONS_SV6;