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_VALIDATE_PAYMENTS_INT dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 80: 'PON_BID_PAYMENTS_SHIPMENTS',

76: pbp.document_disp_line_number,
77: 'PAYITEMNUM',
78: pbp.payment_display_number,
79: l_interface_type,
80: 'PON_BID_PAYMENTS_SHIPMENTS',
81: p_batch_id,
82: pbp.interface_line_id,
83: pbp.auction_header_id,
84: l_exp_date,

Line 588: pbp.payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

584: SELECT decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_txt_upload_mode, fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'), fnd_message.get_string('PON','PON_PAY_ITEM')),
585: NULL, 'PON_LINE_PYMT_INVALID', -- 1
586: 'NUM', pbp.payment_display_number, NULL, -- 2
587: 'LINENUM', pbp.document_disp_line_number, 'PAYITEMNUM', -- 3
588: pbp.payment_display_number, l_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
589: p_batch_id, pbp.interface_line_id, NULL, -- 5
590: pbp.auction_header_id, pai.line_number, NULL, -- 6
591: l_exp_date, l_userid, SYSDATE, -- 7
592: l_userid, SYSDATE, l_loginid, -- 8

Line 1340: FROM PON_BID_PAYMENTS_SHIPMENTS pbps

1336: fnd.pk2_value bid_line_number -- bid line number
1337: FROM FND_ATTACHED_DOCUMENTS fnd
1338: WHERE fnd.pk1_value = p_bid_number
1339: AND fnd.pk3_value NOT IN (SELECT bid_payment_id
1340: FROM PON_BID_PAYMENTS_SHIPMENTS pbps
1341: WHERE pbps.bid_number = p_bid_number)
1342: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS';
1343:
1344:

Line 1342: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS';

1338: WHERE fnd.pk1_value = p_bid_number
1339: AND fnd.pk3_value NOT IN (SELECT bid_payment_id
1340: FROM PON_BID_PAYMENTS_SHIPMENTS pbps
1341: WHERE pbps.bid_number = p_bid_number)
1342: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS';
1343:
1344:
1345: CURSOR l_attachment_cursor
1346: IS

Line 1355: pon_bid_payments_shipments pbps

1351: pbps.bid_line_number,
1352: pbpi.document_disp_line_number
1353: FROM pon_bid_payments_interface pbpi,
1354: pon_auction_item_prices_all pai,
1355: pon_bid_payments_shipments pbps
1356: WHERE pbpi.auction_header_id = pai.auction_header_id
1357: AND pbpi.document_disp_line_number = pai.document_disp_line_number
1358: AND pbps.auction_header_id = pai.auction_header_id
1359: AND pbps.bid_line_number = pai.line_number

Line 1380: MERGE INTO pon_bid_payments_shipments bl

1376: WHERE pbpi.bid_number = pbh.bid_number
1377: AND pbpi.batch_id = p_batch_id;
1378:
1379: -- Update lines table with values in the interface table
1380: MERGE INTO pon_bid_payments_shipments bl
1381: USING
1382: (SELECT
1383: pbpi.auction_header_id,
1384: pbpi.bid_number,

Line 1455: PON_BID_PAYMENTS_SHIPMENTS_S1.nextval ,

1451: LAST_UPDATED_BY ,
1452: LAST_UPDATE_LOGIN
1453: )
1454: VALUES (
1455: PON_BID_PAYMENTS_SHIPMENTS_S1.nextval ,
1456: bli.AUCTION_HEADER_ID ,
1457: bli.LINE_NUMBER ,
1458: bli.LINE_NUMBER ,
1459: bli.BID_NUMBER ,

Line 1476: l_progress := 'Merge into pon_bid_payments_shipments is successful for batch_id = '||p_batch_id;

1472: fnd_global.login_id
1473: ) ;
1474:
1475: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1476: l_progress := 'Merge into pon_bid_payments_shipments is successful for batch_id = '||p_batch_id;
1477: END if;
1478:
1479: IF (p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN
1480: --create URL Attachments

Line 1497: p_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

1493: p_category_name => 'FromSupplier',
1494: p_document_description => l_attachment_record.attachment_desc,
1495: p_datatype_id => 5,
1496: p_url => l_attachment_record.attachment_url,
1497: p_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
1498: p_pk1_value => l_attachment_record.bid_number,
1499: p_pk2_value => l_attachment_record.bid_line_number,
1500: p_pk3_value => l_attachment_record.bid_payment_id,
1501: p_pk4_value => NULL,

Line 1512: DELETE FROM PON_BID_PAYMENTS_SHIPMENTS pbp

1508: FROM PON_AUCTION_HEADERS_ALL
1509: WHERE auction_header_id = p_auction_header_id;
1510:
1511: IF l_supplier_enterable_pymt_flag = 'Y' THEN
1512: DELETE FROM PON_BID_PAYMENTS_SHIPMENTS pbp
1513: WHERE pbp.payment_display_number NOT IN (SELECT pbpi.payment_display_number
1514: FROM PON_BID_PAYMENTS_INTERFACE pbpi,
1515: PON_AUCTION_ITEM_PRICES_ALL pai
1516: WHERE pbpi.batch_id = p_batch_id

Line 1524: -- To delete attachments of pon_bid_payments_shipments

1520: AND pbp.bid_line_number = pai.line_number)
1521: AND pbp.bid_number = p_bid_number
1522: AND pbp.bid_line_number IN (SELECT pbi.line_number FROM PON_BID_ITEM_PRICES_INTERFACE pbi WHERE pbi.batch_id = p_batch_id);
1523:
1524: -- To delete attachments of pon_bid_payments_shipments
1525: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor
1526: LOOP
1527: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
1528: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

Line 1528: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

1524: -- To delete attachments of pon_bid_payments_shipments
1525: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor
1526: LOOP
1527: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
1528: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
1529: x_pk1_value => delete_pymt_attachments_record.bid_number,
1530: x_pk2_value => delete_pymt_attachments_record.bid_line_number,
1531: x_pk3_value => delete_pymt_attachments_record.bid_payment_id);
1532: END LOOP;

Line 1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE

1545: UPDATE pon_bid_item_prices pbip SET pbip.IS_CHANGED_LINE_FLAG = 'Y',
1546: LAST_UPDATE_DATE = sysdate,
1547: LAST_UPDATED_BY = FND_GLOBAL.user_id
1548: WHERE pbip.line_number IN (
1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE
1550: pbpi.batch_id = p_batch_id AND
1551: paip.auction_header_id = pbpi.auction_header_id AND
1552: pbpi.document_disp_line_number = paip.document_disp_line_number AND
1553: pbps.AUCTION_LINE_NUMBER = paip.line_number AND