APPS.GML_PO_HEADER_ARCHIVE dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 36: p_po_header_id IN PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_HEADER_ID%TYPE)

32: p_terms_id IN PO_HEADERS_ALL.TERMS_ID%TYPE,
33: p_freight_code IN PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE,
34: p_fob_code IN PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE,
35: p_carrier_code IN PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE,
36: p_po_header_id IN PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_HEADER_ID%TYPE)
37: AS
38: BEGIN
39: v_segment1 := p_segment1;
40: v_revision_num := p_revision_num;

Line 82: v_po_line_id PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID%TYPE;

78: v_from_date VARCHAR2(13) := SYSDATE;
79: v_to_date VARCHAR2(13) := SYSDATE;
80: errbuf VARCHAR2(80);
81: retcode number;
82: v_po_line_id PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID%TYPE;
83: v_ship_to_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_LOCATION_ID%TYPE;
84: v_line_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_LOCATION_ID%TYPE;
85:
86: /* Cursor to get old agent id and bill to location id */

Line 83: v_ship_to_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_LOCATION_ID%TYPE;

79: v_to_date VARCHAR2(13) := SYSDATE;
80: errbuf VARCHAR2(80);
81: retcode number;
82: v_po_line_id PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID%TYPE;
83: v_ship_to_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_LOCATION_ID%TYPE;
84: v_line_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_LOCATION_ID%TYPE;
85:
86: /* Cursor to get old agent id and bill to location id */
87: /* HW BUG#:1222249 */

Line 84: v_line_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_LOCATION_ID%TYPE;

80: errbuf VARCHAR2(80);
81: retcode number;
82: v_po_line_id PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID%TYPE;
83: v_ship_to_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_LOCATION_ID%TYPE;
84: v_line_location_id PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_LOCATION_ID%TYPE;
85:
86: /* Cursor to get old agent id and bill to location id */
87: /* HW BUG#:1222249 */
88: /* This cursor causes a mutation problem */

Line 108: FROM po_line_locations_archive_all

104: /* BUG#:1132943 retrieve the correct line */
105:
106: CURSOR line_loc_cur IS
107: SELECT po_line_id,ship_to_location_id,line_location_id
108: FROM po_line_locations_archive_all
109: WHERE po_header_id = v_po_header_id ;
110:
111:
112: BEGIN