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_NEGOTIATION_COPY_GRP dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 5755: PON_AUC_PAYMENTS_SHIPMENTS paps,

5751: paps.auction_header_id dest_auc_id,
5752: paps.line_number dest_line_number,
5753: paps.payment_id dest_payment_id
5754: FROM
5755: PON_AUC_PAYMENTS_SHIPMENTS paps,
5756: FND_ATTACHED_DOCUMENTS fnd,
5757: PON_AUC_PAYMENTS_SHIPMENTS psps
5758: WHERE psps.auction_header_id = p_source_auction_header_id
5759: AND paps.auction_header_id = p_auction_header_id

Line 5757: PON_AUC_PAYMENTS_SHIPMENTS psps

5753: paps.payment_id dest_payment_id
5754: FROM
5755: PON_AUC_PAYMENTS_SHIPMENTS paps,
5756: FND_ATTACHED_DOCUMENTS fnd,
5757: PON_AUC_PAYMENTS_SHIPMENTS psps
5758: WHERE psps.auction_header_id = p_source_auction_header_id
5759: AND paps.auction_header_id = p_auction_header_id
5760: AND paps.line_number = psps.line_number
5761: AND paps.payment_display_number = psps.payment_display_number

Line 5765: AND fnd.entity_name like 'PON_AUC_PAYMENTS_SHIPMENTS%'

5761: AND paps.payment_display_number = psps.payment_display_number
5762: AND fnd.pk1_value = to_char(psps.auction_header_id)
5763: AND fnd.pk2_value = to_char(psps.line_number)
5764: AND fnd.pk3_value = to_char(psps.payment_id)
5765: AND fnd.entity_name like 'PON_AUC_PAYMENTS_SHIPMENTS%'
5766: AND psps.line_number >= p_from_line_number
5767: AND psps.line_number <= p_to_line_number;
5768:
5769: BEGIN

Line 5787: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';

5783: ELSE
5784: LOG_MESSAGE('copy negotiation','When source document is an RFQ - Before executing payments cursor');
5785: --if there are any payments in the source doc copy them
5786: --Insert payments
5787: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';
5788: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');
5789:
5790: INSERT INTO
5791: PON_AUC_PAYMENTS_SHIPMENTS

Line 5788: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');

5784: LOG_MESSAGE('copy negotiation','When source document is an RFQ - Before executing payments cursor');
5785: --if there are any payments in the source doc copy them
5786: --Insert payments
5787: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';
5788: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');
5789:
5790: INSERT INTO
5791: PON_AUC_PAYMENTS_SHIPMENTS
5792: ( AUCTION_HEADER_ID,

Line 5791: PON_AUC_PAYMENTS_SHIPMENTS

5787: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';
5788: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');
5789:
5790: INSERT INTO
5791: PON_AUC_PAYMENTS_SHIPMENTS
5792: ( AUCTION_HEADER_ID,
5793: PAYMENT_ID,
5794: LINE_NUMBER,
5795: PAYMENT_DISPLAY_NUMBER,

Line 5819: PON_AUC_PAYMENTS_SHIPMENTS_S1.NEXTVAL,

5815: LAST_UPDATE_LOGIN
5816: )
5817: (SELECT
5818: p_auction_header_id,
5819: PON_AUC_PAYMENTS_SHIPMENTS_S1.NEXTVAL,
5820: LINE_NUMBER,
5821: PAYMENT_DISPLAY_NUMBER,
5822: PAYMENT_TYPE_CODE,
5823: PAYMENT_DESCRIPTION,

Line 5842: FROM pon_auc_payments_shipments

5838: p_user_id,
5839: SYSDATE,
5840: p_user_id,
5841: fnd_global.login_id
5842: FROM pon_auc_payments_shipments
5843: WHERE auction_header_id = p_source_auction_header_id
5844: AND line_number >= p_from_line_number
5845: AND line_number <= p_to_line_number
5846:

Line 5848: g_err_loc := '2. After inserting into pon_auc_payments_shipments';

5844: AND line_number >= p_from_line_number
5845: AND line_number <= p_to_line_number
5846:
5847: );
5848: g_err_loc := '2. After inserting into pon_auc_payments_shipments';
5849: LOG_MESSAGE('copy_negotiation','After Insert into pon_auc_payments_shipments');
5850: --
5851: -- Copy Attachments for Payments if user wants to retain the attachments of the
5852: -- source document

Line 5849: LOG_MESSAGE('copy_negotiation','After Insert into pon_auc_payments_shipments');

5845: AND line_number <= p_to_line_number
5846:
5847: );
5848: g_err_loc := '2. After inserting into pon_auc_payments_shipments';
5849: LOG_MESSAGE('copy_negotiation','After Insert into pon_auc_payments_shipments');
5850: --
5851: -- Copy Attachments for Payments if user wants to retain the attachments of the
5852: -- source document
5853: --

Line 5878: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'

5874: FROM FND_ATTACHED_DOCUMENTS
5875: WHERE pk1_value = to_char(p_source_auction_header_id)
5876: AND pk2_value = to_char(payment_line_rec.source_line_number)
5877: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5878: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'
5879: UNION
5880: SELECT ENTITY_NAME,ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE,PK3_VALUE
5881: FROM FND_ATTACHED_DOCUMENTS fad
5882: WHERE pk1_value = To_Char(p_source_auction_header_id)

Line 5885: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'

5881: FROM FND_ATTACHED_DOCUMENTS fad
5882: WHERE pk1_value = To_Char(p_source_auction_header_id)
5883: AND pk2_value = to_char(payment_line_rec.source_line_number)
5884: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5885: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'
5886: AND NOT EXISTS
5887: (SELECT 1 FROM FND_ATTACHED_DOCUMENTS
5888: WHERE pk1_value = to_char(p_source_auction_header_id)
5889: AND ENTITY_NAME

Line 5890: in ('PON_AUC_PAYMENTS_SHIPMENTS',

5886: AND NOT EXISTS
5887: (SELECT 1 FROM FND_ATTACHED_DOCUMENTS
5888: WHERE pk1_value = to_char(p_source_auction_header_id)
5889: AND ENTITY_NAME
5890: in ('PON_AUC_PAYMENTS_SHIPMENTS',
5891: 'PON_AUC_PAYMENTS_SHIPMENTS_DEL')
5892: AND ORIG_ATTACH_DOC_ID =fad.ORIG_ATTACH_DOC_ID)) LOOP
5893:
5894: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

Line 5891: 'PON_AUC_PAYMENTS_SHIPMENTS_DEL')

5887: (SELECT 1 FROM FND_ATTACHED_DOCUMENTS
5888: WHERE pk1_value = to_char(p_source_auction_header_id)
5889: AND ENTITY_NAME
5890: in ('PON_AUC_PAYMENTS_SHIPMENTS',
5891: 'PON_AUC_PAYMENTS_SHIPMENTS_DEL')
5892: AND ORIG_ATTACH_DOC_ID =fad.ORIG_ATTACH_DOC_ID)) LOOP
5893:
5894: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5895: X_from_entity_name => base_attach_rec.ENTITY_NAME,

Line 5899: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

5895: X_from_entity_name => base_attach_rec.ENTITY_NAME,
5896: X_from_pk1_value => base_attach_rec.pk1_value,
5897: X_from_pk2_value => base_attach_rec.pk2_value,
5898: X_from_pk3_value => base_attach_rec.pk3_value,
5899: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5900: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
5901: X_to_pk2_value => to_char(payment_line_rec.dest_line_number), -- PK1_VALUE
5902: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id), -- PK1_VALUE
5903: X_created_by => p_user_id, -- CREATED_BY

Line 5919: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'

5915: FROM FND_ATTACHED_DOCUMENTS
5916: WHERE pk1_value = to_char(payment_line_rec.source_auc_id)
5917: AND pk2_value = to_char(payment_line_rec.source_line_number)
5918: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5919: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'
5920: ) LOOP
5921:
5922: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5923: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

Line 5923: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

5919: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'
5920: ) LOOP
5921:
5922: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5923: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5924: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5925: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5926: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),
5927: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND',

Line 5927: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND',

5923: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5924: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5925: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5926: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),
5927: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND',
5928: X_to_pk1_value => to_char(payment_line_rec.dest_auc_id), -- PK1_VALUE
5929: X_to_pk2_value => to_char(payment_line_rec.dest_line_number), -- PK1_VALUE
5930: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id), -- PK1_VALUE
5931: X_created_by => p_user_id, -- CREATED_BY

Line 5940: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

5936:
5937: ELSE
5938:
5939: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5940: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5941: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5942: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5943: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),
5944: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

Line 5944: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

5940: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5941: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5942: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5943: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),
5944: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5945: X_to_pk1_value => to_char(payment_line_rec.dest_auc_id),
5946: X_to_pk2_value => to_char(payment_line_rec.dest_line_number),
5947: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id),
5948: X_created_by => p_user_id,

Line 13499: IF p_from_entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND' THEN

13495: l_pk3_value fnd_attached_documents.pk1_value%TYPE;
13496:
13497: BEGIN
13498:
13499: IF p_from_entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND' THEN
13500: SELECT orig_attach_doc_id INTO payments_orig_doc_id
13501: FROM fnd_attached_documents
13502: WHERE entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'
13503: AND pk1_value = p_from_pk1_value

Line 13502: WHERE entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'

13498:
13499: IF p_from_entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND' THEN
13500: SELECT orig_attach_doc_id INTO payments_orig_doc_id
13501: FROM fnd_attached_documents
13502: WHERE entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'
13503: AND pk1_value = p_from_pk1_value
13504: AND pk2_value = p_from_pk2_value
13505: AND pk3_value = p_from_pk3_value
13506: AND attached_document_id = p_orig_attach_doc_id;

Line 13514: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

13510: FROM fnd_attached_documents
13511: WHERE attached_document_id = payments_orig_doc_id;
13512:
13513: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
13514: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
13515: X_from_pk1_value => l_pk1_value,
13516: X_from_pk2_value => l_pk2_value,
13517: X_from_pk3_value => l_pk3_value,
13518: X_to_entity_name => p_to_entity_name,