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

Line 698: PON_AUC_PAYMENTS_SHIPMENTS

694: PON_PRICE_ELEMENTS
695: PON_PRICE_DIFFERENTIALS
696: PON_AUCTION_SHIPMENTS_ALL
697: PON_PARTY_LINE_EXCLUSIONS
698: PON_AUC_PAYMENTS_SHIPMENTS
699: Attachments
700: Update backing requisitions for lines being deleted.
701: PON_AUCTION_ITEM_PRICES_ALL
702: ======================================================================*/

Line 733: pon_auc_payments_shipments paps,

729: paps.auction_header_id,
730: paps.line_number
731: FROM pon_item_prices_interface p1,
732: pon_auction_item_prices paip,
733: pon_auc_payments_shipments paps,
734: FND_ATTACHED_DOCUMENTS fnd
735: WHERE p1.batch_id = g_batch_id
736: AND p1.action = g_delete_action
737: AND paip.auction_header_id = p1.auction_header_id

Line 753: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS'

749: AND paps.auction_header_id = paip.auction_header_id
750: AND fnd.pk1_value = paps.auction_header_id
751: AND fnd.pk2_value = paps.line_number
752: AND fnd.pk3_value = paps.payment_id
753: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS'
754: AND paip.group_type <> 'LOT_LINE';
755:
756:
757: BEGIN

Line 926: -- To delete attachments of pon_auc_payments_shipments

922:
923:
924:
925:
926: -- To delete attachments of pon_auc_payments_shipments
927: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor LOOP
928: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
929: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
930: x_pk1_value => delete_pymt_attachments_record.auction_header_id,

Line 929: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

925:
926: -- To delete attachments of pon_auc_payments_shipments
927: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor LOOP
928: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
929: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
930: x_pk1_value => delete_pymt_attachments_record.auction_header_id,
931: x_pk2_value => delete_pymt_attachments_record.line_number,
932: x_pk3_value => delete_pymt_attachments_record.payment_id);
933: END LOOP;

Line 935: --delete from PON_AUC_PAYMENTS_SHIPMENTS

931: x_pk2_value => delete_pymt_attachments_record.line_number,
932: x_pk3_value => delete_pymt_attachments_record.payment_id);
933: END LOOP;
934:
935: --delete from PON_AUC_PAYMENTS_SHIPMENTS
936: delete from pon_auc_payments_shipments auc_payments
937: where
938: auction_header_id = g_auction_header_id
939: and line_number IN

Line 936: delete from pon_auc_payments_shipments auc_payments

932: x_pk3_value => delete_pymt_attachments_record.payment_id);
933: END LOOP;
934:
935: --delete from PON_AUC_PAYMENTS_SHIPMENTS
936: delete from pon_auc_payments_shipments auc_payments
937: where
938: auction_header_id = g_auction_header_id
939: and line_number IN
940: (select

Line 3286: pon_auc_payments_shipments paps

3282: paps.line_number,
3283: papi.document_disp_line_number
3284: FROM pon_auc_payments_interface papi,
3285: pon_auction_item_prices_all pai,
3286: pon_auc_payments_shipments paps
3287: WHERE papi.auction_header_id = pai.auction_header_id
3288: AND papi.document_disp_line_number = pai.document_disp_line_number
3289: AND paps.auction_header_id = pai.auction_header_id
3290: AND paps.line_number = pai.line_number

Line 3307: MERGE INTO PON_AUC_PAYMENTS_SHIPMENTS paps

3303:
3304: -- If the payment_display_number and line_number combination does not exist
3305: -- in the transaction table insert the record
3306:
3307: MERGE INTO PON_AUC_PAYMENTS_SHIPMENTS paps
3308: USING (SELECT ppi.BATCH_ID,
3309: ppi.INTERFACE_LINE_ID,
3310: ppi.AUCTION_HEADER_ID,
3311: pai.line_number,

Line 3403: PON_AUC_PAYMENTS_SHIPMENTS_S1.nextval ,

3399: LAST_UPDATED_BY ,
3400: LAST_UPDATE_LOGIN
3401: )
3402: VALUES (
3403: PON_AUC_PAYMENTS_SHIPMENTS_S1.nextval ,
3404: papi.AUCTION_HEADER_ID ,
3405: papi.LINE_NUMBER ,
3406: papi.PAYMENT_DISPLAY_NUMBER ,
3407: papi.PAYMENT_DESCRIPTION ,

Line 3431: l_progress := 'Merge into pon_auc_payments_shipments is successful for auction_header_id = '||p_auction_header_id;

3427: ) ;
3428:
3429:
3430: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3431: l_progress := 'Merge into pon_auc_payments_shipments is successful for auction_header_id = '||p_auction_header_id;
3432: END if;
3433:
3434: --create URL Attachments
3435: FOR l_attachment_record IN l_attachment_cursor LOOP

Line 3451: p_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

3447: p_category_name => 'Vendor',
3448: p_document_description => l_attachment_record.attachment_desc,
3449: p_datatype_id => 5,
3450: p_url => l_attachment_record.attachment_url,
3451: p_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
3452: p_pk1_value => l_attachment_record.auction_header_id,
3453: p_pk2_value => l_attachment_record.line_number,
3454: p_pk3_value => l_attachment_record.payment_id,
3455: p_pk4_value => NULL,

Line 3488: FROM pon_auc_payments_shipments pap1,

3484: , last_update_login = fnd_global.login_id
3485: WHERE al.auction_header_id = p_auction_header_id
3486: AND (EXISTS (
3487: SELECT 1
3488: FROM pon_auc_payments_shipments pap1,
3489: pon_auc_payments_shipments pap2
3490: WHERE pap1.auction_header_id = al.auction_header_id
3491: AND pap1.line_number = al.line_number
3492: AND pap1.payment_display_number = pap2.payment_display_number

Line 3489: pon_auc_payments_shipments pap2

3485: WHERE al.auction_header_id = p_auction_header_id
3486: AND (EXISTS (
3487: SELECT 1
3488: FROM pon_auc_payments_shipments pap1,
3489: pon_auc_payments_shipments pap2
3490: WHERE pap1.auction_header_id = al.auction_header_id
3491: AND pap1.line_number = al.line_number
3492: AND pap1.payment_display_number = pap2.payment_display_number
3493: AND pap2.auction_header_id = l_prev_amend_auc_id

Line 3523: FROM pon_auc_payments_shipments pap1

3519:
3520: OR
3521: EXISTS (
3522: SELECT 1
3523: FROM pon_auc_payments_shipments pap1
3524: WHERE pap1.auction_header_id = al.auction_header_id
3525: AND pap1.line_number = al.line_number
3526: AND NOT EXISTS (
3527: SELECT 1

Line 3528: FROM pon_auc_payments_shipments pap2

3524: WHERE pap1.auction_header_id = al.auction_header_id
3525: AND pap1.line_number = al.line_number
3526: AND NOT EXISTS (
3527: SELECT 1
3528: FROM pon_auc_payments_shipments pap2
3529: WHERE pap2.auction_header_id = l_prev_amend_auc_id
3530: AND pap2.line_number = pap1.line_number
3531: AND pap2.payment_display_number = pap1.payment_display_number
3532: )))