APPS.AHL_OSP_PO_PVT dependencies on PO_LINES_INTERFACE

Line 108: -- Inserts records into the PO_LINES_INTERFACE table

104: p_po_header_rec IN PO_Header_Rec_Type,
105: x_intf_header_id OUT NOCOPY NUMBER,
106: x_batch_id OUT NOCOPY NUMBER);
107:
108: -- Inserts records into the PO_LINES_INTERFACE table
109: PROCEDURE Insert_PO_Lines(
110: p_po_line_tbl IN PO_Line_Tbl_Type,
111: p_intf_header_id IN NUMBER);
112:

Line 495: -- Insert rows into PO_LINES_INTERFACE

491: x_intf_header_id => l_intf_hdr_id,
492: x_batch_id => l_batch_id);
493: --dbms_output.put_line('Inserted row into po_headers_interface. x_intf_header_id = ' || l_intf_hdr_id);
494: --dbms_output.put_line('x_batch_id = ' || l_batch_id);
495: -- Insert rows into PO_LINES_INTERFACE
496: Insert_PO_Lines(p_po_line_tbl => l_po_line_tbl,
497: p_intf_header_id => l_intf_hdr_id);
498: --dbms_output.put_line('inserted rows into po_lines_interface ');
499: -- Purge Error records from prior submission (if any)

Line 498: --dbms_output.put_line('inserted rows into po_lines_interface ');

494: --dbms_output.put_line('x_batch_id = ' || l_batch_id);
495: -- Insert rows into PO_LINES_INTERFACE
496: Insert_PO_Lines(p_po_line_tbl => l_po_line_tbl,
497: p_intf_header_id => l_intf_hdr_id);
498: --dbms_output.put_line('inserted rows into po_lines_interface ');
499: -- Purge Error records from prior submission (if any)
500: -- Begin Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
501: IF (l_old_intf_header_id IS NOT NULL AND l_curr_status = G_OSP_SUB_FAILED_STATUS) THEN
502: -- PO Submission had failed earlier

Line 507: DELETE FROM PO_LINES_INTERFACE WHERE

503: DELETE FROM PO_INTERFACE_ERRORS WHERE
504: INTERFACE_HEADER_ID = l_old_intf_header_id;
505: DELETE FROM PO_HEADERS_INTERFACE WHERE
506: INTERFACE_HEADER_ID = l_old_intf_header_id;
507: DELETE FROM PO_LINES_INTERFACE WHERE
508: INTERFACE_HEADER_ID = l_old_intf_header_id;
509: DELETE FROM PO_DISTRIBUTIONS_INTERFACE WHERE
510: INTERFACE_HEADER_ID = l_old_intf_header_id;
511: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN

Line 1820: -- This Procedure inserts a record into the PO_LINES_INTERFACE table

1816:
1817: END Insert_PO_Header;
1818:
1819: ----------------------------------------
1820: -- This Procedure inserts a record into the PO_LINES_INTERFACE table
1821: ----------------------------------------
1822: PROCEDURE Insert_PO_Lines(
1823: p_po_line_tbl IN PO_Line_Tbl_Type,
1824: p_intf_header_id IN NUMBER) IS

Line 1894: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;

1890: END IF;
1891:
1892: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1893: -- Generate PO Line Interface Id
1894: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1895: -- Insert row into PO_LINES_INTERFACE
1896: INSERT INTO PO_LINES_INTERFACE (
1897: INTERFACE_LINE_ID,
1898: INTERFACE_HEADER_ID,

Line 1895: -- Insert row into PO_LINES_INTERFACE

1891:
1892: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1893: -- Generate PO Line Interface Id
1894: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1895: -- Insert row into PO_LINES_INTERFACE
1896: INSERT INTO PO_LINES_INTERFACE (
1897: INTERFACE_LINE_ID,
1898: INTERFACE_HEADER_ID,
1899: LINE_NUM,

Line 1896: INSERT INTO PO_LINES_INTERFACE (

1892: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1893: -- Generate PO Line Interface Id
1894: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1895: -- Insert row into PO_LINES_INTERFACE
1896: INSERT INTO PO_LINES_INTERFACE (
1897: INTERFACE_LINE_ID,
1898: INTERFACE_HEADER_ID,
1899: LINE_NUM,
1900: LINE_TYPE_ID,