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 503: -- Insert rows into PO_LINES_INTERFACE

499: x_intf_header_id => l_intf_hdr_id,
500: x_batch_id => l_batch_id);
501: --dbms_output.put_line('Inserted row into po_headers_interface. x_intf_header_id = ' || l_intf_hdr_id);
502: --dbms_output.put_line('x_batch_id = ' || l_batch_id);
503: -- Insert rows into PO_LINES_INTERFACE
504: Insert_PO_Lines(p_po_line_tbl => l_po_line_tbl,
505: p_intf_header_id => l_intf_hdr_id);
506: --dbms_output.put_line('inserted rows into po_lines_interface ');
507: -- Purge Error records from prior submission (if any)

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

502: --dbms_output.put_line('x_batch_id = ' || l_batch_id);
503: -- Insert rows into PO_LINES_INTERFACE
504: Insert_PO_Lines(p_po_line_tbl => l_po_line_tbl,
505: p_intf_header_id => l_intf_hdr_id);
506: --dbms_output.put_line('inserted rows into po_lines_interface ');
507: -- Purge Error records from prior submission (if any)
508: -- Begin Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
509: IF (l_old_intf_header_id IS NOT NULL AND l_curr_status = G_OSP_SUB_FAILED_STATUS) THEN
510: -- PO Submission had failed earlier

Line 515: DELETE FROM PO_LINES_INTERFACE WHERE

511: DELETE FROM PO_INTERFACE_ERRORS WHERE
512: INTERFACE_HEADER_ID = l_old_intf_header_id;
513: DELETE FROM PO_HEADERS_INTERFACE WHERE
514: INTERFACE_HEADER_ID = l_old_intf_header_id;
515: DELETE FROM PO_LINES_INTERFACE WHERE
516: INTERFACE_HEADER_ID = l_old_intf_header_id;
517: DELETE FROM PO_DISTRIBUTIONS_INTERFACE WHERE
518: INTERFACE_HEADER_ID = l_old_intf_header_id;
519: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN

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

1830:
1831: END Insert_PO_Header;
1832:
1833: ----------------------------------------
1834: -- This Procedure inserts a record into the PO_LINES_INTERFACE table
1835: ----------------------------------------
1836: PROCEDURE Insert_PO_Lines(
1837: p_po_line_tbl IN PO_Line_Tbl_Type,
1838: p_intf_header_id IN NUMBER) IS

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

1904: END IF;
1905:
1906: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1907: -- Generate PO Line Interface Id
1908: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1909: -- Insert row into PO_LINES_INTERFACE
1910: INSERT INTO PO_LINES_INTERFACE (
1911: INTERFACE_LINE_ID,
1912: INTERFACE_HEADER_ID,

Line 1909: -- Insert row into PO_LINES_INTERFACE

1905:
1906: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1907: -- Generate PO Line Interface Id
1908: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1909: -- Insert row into PO_LINES_INTERFACE
1910: INSERT INTO PO_LINES_INTERFACE (
1911: INTERFACE_LINE_ID,
1912: INTERFACE_HEADER_ID,
1913: LINE_NUM,

Line 1910: INSERT INTO PO_LINES_INTERFACE (

1906: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1907: -- Generate PO Line Interface Id
1908: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1909: -- Insert row into PO_LINES_INTERFACE
1910: INSERT INTO PO_LINES_INTERFACE (
1911: INTERFACE_LINE_ID,
1912: INTERFACE_HEADER_ID,
1913: LINE_NUM,
1914: LINE_TYPE_ID,