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.PON_AUCTION_PKG dependencies on PON_BACKING_REQUISITIONS

Line 9619: -- first, remove records in pon_backing_requisitions

9615: x_error_code out NOCOPY varchar2) is
9616:
9617: BEGIN
9618:
9619: -- first, remove records in pon_backing_requisitions
9620: delete
9621: from pon_backing_requisitions
9622: where auction_header_id = x_negotiation_id
9623: and line_number = x_negotiation_line_num;

Line 9621: from pon_backing_requisitions

9617: BEGIN
9618:
9619: -- first, remove records in pon_backing_requisitions
9620: delete
9621: from pon_backing_requisitions
9622: where auction_header_id = x_negotiation_id
9623: and line_number = x_negotiation_line_num;
9624:
9625: -- remove negotiation references in po_requisition_lines

Line 9892: l_req_number pon_backing_requisitions.requisition_number%TYPE;

9888: l_line_number NUMBER;
9889: l_req_header_id NUMBER;
9890: l_req_line_id NUMBER;
9891: l_req_quantity NUMBER;
9892: l_req_number pon_backing_requisitions.requisition_number%TYPE;
9893:
9894: CURSOR backingReqs IS
9895: SELECT LINE_NUMBER,
9896: REQUISITION_HEADER_ID,

Line 9900: FROM PON_BACKING_REQUISITIONS

9896: REQUISITION_HEADER_ID,
9897: REQUISITION_LINE_ID,
9898: REQUISITION_QUANTITY,
9899: REQUISITION_NUMBER
9900: FROM PON_BACKING_REQUISITIONS
9901: WHERE auction_header_id = x_old_negotiation_id;
9902:
9903: BEGIN
9904: IF(x_new_negotiation_id IS NOT NULL) THEN

Line 9917: FROM PON_BACKING_REQUISITIONS

9913: EXIT WHEN backingReqs%NOTFOUND;
9914:
9915: SELECT count(*)
9916: INTO l_count
9917: FROM PON_BACKING_REQUISITIONS
9918: WHERE auction_header_id = x_new_negotiation_id and
9919: line_number = l_line_number and
9920: requisition_header_id = l_req_header_id and
9921: requisition_line_id = l_req_line_id;

Line 9931: INSERT INTO PON_BACKING_REQUISITIONS(

9927: WHERE auction_header_id = x_new_negotiation_id and
9928: line_number = l_line_number;
9929:
9930: IF ((l_count = 0) AND (neg_item_count) = 1) THEN
9931: INSERT INTO PON_BACKING_REQUISITIONS(
9932: AUCTION_HEADER_ID,
9933: LINE_NUMBER,
9934: REQUISITION_HEADER_ID,
9935: REQUISITION_LINE_ID,

Line 17380: from po_requisition_headers_all prha, PON_BACKING_REQUISITIONS pbr

17376:
17377:
17378: CURSOR preparer_list IS
17379: select prha.preparer_id
17380: from po_requisition_headers_all prha, PON_BACKING_REQUISITIONS pbr
17381: where pbr.auction_header_id = x_auction_header_id
17382: and prha.requisition_header_id = pbr.requisition_header_id;
17383:
17384:

Line 17449: from pon_backing_requisitions

17445: FUNCTION get_all_pr_number(p_auction_header_id IN NUMBER)
17446: RETURN VARCHAR2 IS
17447: CURSOR req_list IS
17448: select requisition_header_id
17449: from pon_backing_requisitions
17450: where auction_header_id = p_auction_header_id;
17451:
17452: l_req_all VARCHAR2(500);
17453:

Line 17767: --for populating requisition references in pon_backing_requisitions table

17763: p_UserTable(u1) := l_userList;
17764: end if;
17765: END String_To_UserTable;
17766:
17767: --for populating requisition references in pon_backing_requisitions table
17768: PROCEDURE POPULATE_PON_PR_REFS(p_auction_header_id IN NUMBER,
17769: p_auction_line_number IN PO_TBL_NUMBER,
17770: p_requisition_line_id IN PO_TBL_NUMBER,
17771: x_return_status OUT NOCOPY VARCHAR2,

Line 17794: --insert req reference in pon_backing_requisitions table

17790: x_return_status := FND_API.G_RET_STS_SUCCESS;
17791: x_no_of_rows_inserted := 0;
17792: l_no_of_rows_inserted := 0;
17793:
17794: --insert req reference in pon_backing_requisitions table
17795: l_progress := '0020';
17796: FOR i in 1..p_auction_line_number.COUNT LOOP
17797: FOR j in 1..p_requisition_line_id.COUNT LOOP
17798:

Line 17806: INSERT INTO pon_backing_requisitions(auction_header_id, line_number, requisition_header_id, requisition_line_id, requisition_number,

17802: WHERE requisition_line_id = p_requisition_line_id(j)
17803: and h.requisition_header_id = l.requisition_header_id;
17804:
17805: BEGIN
17806: INSERT INTO pon_backing_requisitions(auction_header_id, line_number, requisition_header_id, requisition_line_id, requisition_number,
17807: creation_date, created_by, last_update_date, last_updated_by, last_update_login)
17808: VALUES (p_auction_header_id, p_auction_line_number(i), l_req_header_id, p_requisition_line_id(j), l_req_number,
17809: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
17810:

Line 17831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' inserted pr references in pon_backing_requisitions table');

17827: x_no_of_rows_inserted := l_no_of_rows_inserted;
17828:
17829: l_progress := '0030';
17830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
17831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' inserted pr references in pon_backing_requisitions table');
17832: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' rows inserted in pon_backing_requisitions table: '|| l_no_of_rows_inserted);
17833: END IF;
17834:
17835: --to remove the selected requisitions from the requisition pool

Line 17832: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' rows inserted in pon_backing_requisitions table: '|| l_no_of_rows_inserted);

17828:
17829: l_progress := '0030';
17830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
17831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' inserted pr references in pon_backing_requisitions table');
17832: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' rows inserted in pon_backing_requisitions table: '|| l_no_of_rows_inserted);
17833: END IF;
17834:
17835: --to remove the selected requisitions from the requisition pool
17836: po_negotiations_sv1.REMOVE_FROM_REQ_POOL('SOLICITATION', p_auction_header_id, p_requisition_line_id, l_return_status, l_error_msg);