eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_PO_PVT dependencies on PO_HEADERS_INTERFACE

Line 102: -- Insert a record into the PO_HEADERS_INTERFACE table

98: PROCEDURE Validate_PO_Lines(
99: p_po_line_tbl IN PO_Line_Tbl_Type,
100: p_osp_order_id IN NUMBER);
101:
102: -- Insert a record into the PO_HEADERS_INTERFACE table
103: PROCEDURE Insert_PO_Header(
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);

Line 250: -- Contains the interface header id generated for the po_headers_interface table.

246: -- Contains the batch id if the concurrent program was launched successfuly.
247: -- x_request_id OUT NUMBER Required
248: -- Contains the concurrent request id if the concurrent program was launched successfuly.
249: -- x_interface_header_id OUT NUMBER Required
250: -- Contains the interface header id generated for the po_headers_interface table.
251: --
252: --
253: -- Version :
254: -- Initial Version 1.0

Line 488: --dbms_output.put_line('no errors : going onto insert into po_headers_interface ');

484: x_msg_count := FND_MSG_PUB.count_msg;
485: IF x_msg_count > 0 THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: --dbms_output.put_line('no errors : going onto insert into po_headers_interface ');
489: -- Insert Row into PO_HEADERS_INTERFACE
490: Insert_PO_Header(p_po_header_rec => l_po_header,
491: x_intf_header_id => l_intf_hdr_id,
492: x_batch_id => l_batch_id);

Line 489: -- Insert Row into PO_HEADERS_INTERFACE

485: IF x_msg_count > 0 THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: --dbms_output.put_line('no errors : going onto insert into po_headers_interface ');
489: -- Insert Row into PO_HEADERS_INTERFACE
490: Insert_PO_Header(p_po_header_rec => l_po_header,
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);

Line 493: --dbms_output.put_line('Inserted row into po_headers_interface. x_intf_header_id = ' || l_intf_hdr_id);

489: -- Insert Row into PO_HEADERS_INTERFACE
490: Insert_PO_Header(p_po_header_rec => l_po_header,
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);

Line 505: DELETE FROM PO_HEADERS_INTERFACE WHERE

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
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

Line 1682: -- This Procedure inserts a record into the PO_HEADERS_INTERFACE table

1678: END IF;
1679: END Validate_PO_Lines;
1680:
1681: ----------------------------------------
1682: -- This Procedure inserts a record into the PO_HEADERS_INTERFACE table
1683: ----------------------------------------
1684: PROCEDURE Insert_PO_Header(
1685: p_po_header_rec IN PO_Header_Rec_Type,
1686: x_intf_header_id OUT NOCOPY NUMBER,

Line 1711: SELECT NVL(MAX(batch_id), 0) + 1 INTO l_batch_id FROM po_headers_interface;

1707: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1708: END IF;
1709: -- Get Batch Id
1710: /*
1711: SELECT NVL(MAX(batch_id), 0) + 1 INTO l_batch_id FROM po_headers_interface;
1712: */
1713: -- Changes made by jaramana on December 19, 2005
1714: -- to improve the performace of this SQL by removing the Full Index Scan
1715: -- Since batch_id is optional, no need to get it using the max value.

Line 1720: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;

1716: -- Instead, hard code it to the OSP Order Id
1717: l_batch_id := p_po_header_rec.OSP_ORDER_ID;
1718:
1719: -- Generate PO Header Id
1720: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1721:
1722: -- Description
1723: OPEN l_get_osp_order_dtls_csr(p_po_header_rec.OSP_ORDER_ID);
1724: FETCH l_get_osp_order_dtls_csr INTO l_temp_n, l_OSP_description;

Line 1772: -- Insert row into PO_HEADERS_INTERFACE

1768:
1769: -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1770: l_curr_org_id := MO_GLOBAL.get_current_org_id();
1771:
1772: -- Insert row into PO_HEADERS_INTERFACE
1773: INSERT INTO PO_HEADERS_INTERFACE (
1774: INTERFACE_HEADER_ID,
1775: BATCH_ID,
1776: INTERFACE_SOURCE_CODE,

Line 1773: INSERT INTO PO_HEADERS_INTERFACE (

1769: -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1770: l_curr_org_id := MO_GLOBAL.get_current_org_id();
1771:
1772: -- Insert row into PO_HEADERS_INTERFACE
1773: INSERT INTO PO_HEADERS_INTERFACE (
1774: INTERFACE_HEADER_ID,
1775: BATCH_ID,
1776: INTERFACE_SOURCE_CODE,
1777: PROCESS_CODE,

Line 2065: po_docs_interface_sv5.process_po_headers_interface(

2061: -- TO BE USED FOR DEBUGGING PURPOSE ONLY
2062: ----------------------------------------
2063: PROCEDURE Call_PDOI_API(p_batch_id IN NUMBER) IS
2064: BEGIN
2065: po_docs_interface_sv5.process_po_headers_interface(
2066: X_selected_batch_id => p_batch_id,
2067: X_buyer_id => NULL,
2068: X_document_type => G_DOC_TYPE_CODE,
2069: X_document_subtype => NULL,