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 693: PON_AUC_PAYMENTS_SHIPMENTS

689: PON_PRICE_ELEMENTS
690: PON_PRICE_DIFFERENTIALS
691: PON_AUCTION_SHIPMENTS_ALL
692: PON_PARTY_LINE_EXCLUSIONS
693: PON_AUC_PAYMENTS_SHIPMENTS
694: Attachments
695: Update backing requisitions for lines being deleted.
696: PON_AUCTION_ITEM_PRICES_ALL
697: ======================================================================*/

Line 725: pon_auc_payments_shipments paps,

721: paps.auction_header_id,
722: paps.line_number
723: FROM pon_item_prices_interface p1,
724: pon_auction_item_prices paip,
725: pon_auc_payments_shipments paps,
726: FND_ATTACHED_DOCUMENTS fnd
727: WHERE p1.batch_id = g_batch_id
728: AND p1.action = g_delete_action
729: AND paip.auction_header_id = p1.auction_header_id

Line 741: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS'

737: AND paps.auction_header_id = paip.auction_header_id
738: AND fnd.pk1_value = paps.auction_header_id
739: AND fnd.pk2_value = paps.line_number
740: AND fnd.pk3_value = paps.payment_id
741: AND fnd.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS'
742: AND paip.group_type <> 'LOT_LINE';
743:
744:
745: BEGIN

Line 898: -- To delete attachments of pon_auc_payments_shipments

894: and paip.group_type in ('LOT_LINE','GROUP_LINE')))
895: and supplier_line_exclusions.line_number = p1.auction_line_number);
896:
897:
898: -- To delete attachments of pon_auc_payments_shipments
899: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor LOOP
900: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
901: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
902: x_pk1_value => delete_pymt_attachments_record.auction_header_id,

Line 901: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

897:
898: -- To delete attachments of pon_auc_payments_shipments
899: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor LOOP
900: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
901: (x_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
902: x_pk1_value => delete_pymt_attachments_record.auction_header_id,
903: x_pk2_value => delete_pymt_attachments_record.line_number,
904: x_pk3_value => delete_pymt_attachments_record.payment_id);
905: END LOOP;

Line 907: --delete from PON_AUC_PAYMENTS_SHIPMENTS

903: x_pk2_value => delete_pymt_attachments_record.line_number,
904: x_pk3_value => delete_pymt_attachments_record.payment_id);
905: END LOOP;
906:
907: --delete from PON_AUC_PAYMENTS_SHIPMENTS
908: delete from pon_auc_payments_shipments auc_payments
909: where
910: auction_header_id = g_auction_header_id
911: and line_number IN

Line 908: delete from pon_auc_payments_shipments auc_payments

904: x_pk3_value => delete_pymt_attachments_record.payment_id);
905: END LOOP;
906:
907: --delete from PON_AUC_PAYMENTS_SHIPMENTS
908: delete from pon_auc_payments_shipments auc_payments
909: where
910: auction_header_id = g_auction_header_id
911: and line_number IN
912: (select

Line 2991: pon_auc_payments_shipments paps

2987: paps.line_number,
2988: papi.document_disp_line_number
2989: FROM pon_auc_payments_interface papi,
2990: pon_auction_item_prices_all pai,
2991: pon_auc_payments_shipments paps
2992: WHERE papi.auction_header_id = pai.auction_header_id
2993: AND papi.document_disp_line_number = pai.document_disp_line_number
2994: AND paps.auction_header_id = pai.auction_header_id
2995: AND paps.line_number = pai.line_number

Line 3012: MERGE INTO PON_AUC_PAYMENTS_SHIPMENTS paps

3008:
3009: -- If the payment_display_number and line_number combination does not exist
3010: -- in the transaction table insert the record
3011:
3012: MERGE INTO PON_AUC_PAYMENTS_SHIPMENTS paps
3013: USING (SELECT ppi.BATCH_ID,
3014: ppi.INTERFACE_LINE_ID,
3015: ppi.AUCTION_HEADER_ID,
3016: pai.line_number,

Line 3108: PON_AUC_PAYMENTS_SHIPMENTS_S1.nextval ,

3104: LAST_UPDATED_BY ,
3105: LAST_UPDATE_LOGIN
3106: )
3107: VALUES (
3108: PON_AUC_PAYMENTS_SHIPMENTS_S1.nextval ,
3109: papi.AUCTION_HEADER_ID ,
3110: papi.LINE_NUMBER ,
3111: papi.PAYMENT_DISPLAY_NUMBER ,
3112: papi.PAYMENT_DESCRIPTION ,

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

3132: ) ;
3133:
3134:
3135: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3136: l_progress := 'Merge into pon_auc_payments_shipments is successful for auction_header_id = '||p_auction_header_id;
3137: END if;
3138:
3139: --create URL Attachments
3140: FOR l_attachment_record IN l_attachment_cursor LOOP

Line 3156: p_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

3152: p_category_name => 'Vendor',
3153: p_document_description => l_attachment_record.attachment_desc,
3154: p_datatype_id => 5,
3155: p_url => l_attachment_record.attachment_url,
3156: p_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
3157: p_pk1_value => l_attachment_record.auction_header_id,
3158: p_pk2_value => l_attachment_record.line_number,
3159: p_pk3_value => l_attachment_record.payment_id,
3160: p_pk4_value => NULL,

Line 3193: FROM pon_auc_payments_shipments pap1,

3189: , last_update_login = fnd_global.login_id
3190: WHERE al.auction_header_id = p_auction_header_id
3191: AND (EXISTS (
3192: SELECT 1
3193: FROM pon_auc_payments_shipments pap1,
3194: pon_auc_payments_shipments pap2
3195: WHERE pap1.auction_header_id = al.auction_header_id
3196: AND pap1.line_number = al.line_number
3197: AND pap1.payment_display_number = pap2.payment_display_number

Line 3194: pon_auc_payments_shipments pap2

3190: WHERE al.auction_header_id = p_auction_header_id
3191: AND (EXISTS (
3192: SELECT 1
3193: FROM pon_auc_payments_shipments pap1,
3194: pon_auc_payments_shipments pap2
3195: WHERE pap1.auction_header_id = al.auction_header_id
3196: AND pap1.line_number = al.line_number
3197: AND pap1.payment_display_number = pap2.payment_display_number
3198: AND pap2.auction_header_id = l_prev_amend_auc_id

Line 3228: FROM pon_auc_payments_shipments pap1

3224:
3225: OR
3226: EXISTS (
3227: SELECT 1
3228: FROM pon_auc_payments_shipments pap1
3229: WHERE pap1.auction_header_id = al.auction_header_id
3230: AND pap1.line_number = al.line_number
3231: AND NOT EXISTS (
3232: SELECT 1

Line 3233: FROM pon_auc_payments_shipments pap2

3229: WHERE pap1.auction_header_id = al.auction_header_id
3230: AND pap1.line_number = al.line_number
3231: AND NOT EXISTS (
3232: SELECT 1
3233: FROM pon_auc_payments_shipments pap2
3234: WHERE pap2.auction_header_id = l_prev_amend_auc_id
3235: AND pap2.line_number = pap1.line_number
3236: AND pap2.payment_display_number = pap1.payment_display_number
3237: )))