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 4705: PON_AUC_PAYMENTS_SHIPMENTS paps,

4701: paps.auction_header_id dest_auc_id,
4702: paps.line_number dest_line_number,
4703: paps.payment_id dest_payment_id
4704: FROM
4705: PON_AUC_PAYMENTS_SHIPMENTS paps,
4706: FND_ATTACHED_DOCUMENTS fnd,
4707: PON_AUC_PAYMENTS_SHIPMENTS psps
4708: WHERE psps.auction_header_id = p_source_auction_header_id
4709: AND paps.auction_header_id = p_auction_header_id

Line 4707: PON_AUC_PAYMENTS_SHIPMENTS psps

4703: paps.payment_id dest_payment_id
4704: FROM
4705: PON_AUC_PAYMENTS_SHIPMENTS paps,
4706: FND_ATTACHED_DOCUMENTS fnd,
4707: PON_AUC_PAYMENTS_SHIPMENTS psps
4708: WHERE psps.auction_header_id = p_source_auction_header_id
4709: AND paps.auction_header_id = p_auction_header_id
4710: AND paps.line_number = psps.line_number
4711: AND paps.payment_display_number = psps.payment_display_number

Line 4715: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS'

4711: AND paps.payment_display_number = psps.payment_display_number
4712: AND fnd.pk1_value = to_char(psps.auction_header_id)
4713: AND fnd.pk2_value = to_char(psps.line_number)
4714: AND fnd.pk3_value = to_char(psps.payment_id)
4715: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS'
4716: AND psps.line_number >= p_from_line_number
4717: AND psps.line_number <= p_to_line_number;
4718:
4719: BEGIN

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

4733: ELSE
4734: LOG_MESSAGE('copy negotiation','When source document is an RFQ - Before executing payments cursor');
4735: --if there are any payments in the source doc copy them
4736: --Insert payments
4737: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';
4738: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');
4739:
4740: INSERT INTO
4741: PON_AUC_PAYMENTS_SHIPMENTS

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

4734: LOG_MESSAGE('copy negotiation','When source document is an RFQ - Before executing payments cursor');
4735: --if there are any payments in the source doc copy them
4736: --Insert payments
4737: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';
4738: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');
4739:
4740: INSERT INTO
4741: PON_AUC_PAYMENTS_SHIPMENTS
4742: ( AUCTION_HEADER_ID,

Line 4741: PON_AUC_PAYMENTS_SHIPMENTS

4737: g_err_loc := '1. Before inserting into pon_auc_payments_shipments';
4738: LOG_MESSAGE('copy_negotiation','Before Insert into pon_auc_payments_shipments');
4739:
4740: INSERT INTO
4741: PON_AUC_PAYMENTS_SHIPMENTS
4742: ( AUCTION_HEADER_ID,
4743: PAYMENT_ID,
4744: LINE_NUMBER,
4745: PAYMENT_DISPLAY_NUMBER,

Line 4769: PON_AUC_PAYMENTS_SHIPMENTS_S1.NEXTVAL,

4765: LAST_UPDATE_LOGIN
4766: )
4767: (SELECT
4768: p_auction_header_id,
4769: PON_AUC_PAYMENTS_SHIPMENTS_S1.NEXTVAL,
4770: LINE_NUMBER,
4771: PAYMENT_DISPLAY_NUMBER,
4772: PAYMENT_TYPE_CODE,
4773: PAYMENT_DESCRIPTION,

Line 4792: FROM pon_auc_payments_shipments

4788: p_user_id,
4789: SYSDATE,
4790: p_user_id,
4791: fnd_global.login_id
4792: FROM pon_auc_payments_shipments
4793: WHERE auction_header_id = p_source_auction_header_id
4794: AND line_number >= p_from_line_number
4795: AND line_number <= p_to_line_number
4796:

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

4794: AND line_number >= p_from_line_number
4795: AND line_number <= p_to_line_number
4796:
4797: );
4798: g_err_loc := '2. After inserting into pon_auc_payments_shipments';
4799: LOG_MESSAGE('copy_negotiation','After Insert into pon_auc_payments_shipments');
4800: --
4801: -- Copy Attachments for Payments if user wants to retain the attachments of the
4802: -- source document

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

4795: AND line_number <= p_to_line_number
4796:
4797: );
4798: g_err_loc := '2. After inserting into pon_auc_payments_shipments';
4799: LOG_MESSAGE('copy_negotiation','After Insert into pon_auc_payments_shipments');
4800: --
4801: -- Copy Attachments for Payments if user wants to retain the attachments of the
4802: -- source document
4803: --

Line 4811: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

4807: LOG_MESSAGE('copy_negotiation','Before copying attachments for payments. Source id =' ||payment_line_rec.source_payment_id);
4808: LOG_MESSAGE('copy_negotiation','Before copying attachments for payments. Destination id =' ||payment_line_rec.dest_payment_id);
4809:
4810: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4811: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
4812: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
4813: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
4814: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),
4815: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

Line 4815: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

4811: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
4812: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
4813: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
4814: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),
4815: X_to_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
4816: X_to_pk1_value => to_char(payment_line_rec.dest_auc_id),
4817: X_to_pk2_value => to_char(payment_line_rec.dest_line_number),
4818: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id),
4819: X_created_by => p_user_id,