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

Line 1498: decode(p_rebid_flag, 'Y', (select count(1) from pon_bid_payments_shipments

1494: , round(al.max_retainage_amount * g_bid_rate, g_curr_prec)
1495: )
1496: , round(al.max_retainage_amount * g_bid_rate, g_curr_prec)
1497: ),--BID_CURR_MAX_RETAINAGE_AMT
1498: decode(p_rebid_flag, 'Y', (select count(1) from pon_bid_payments_shipments
1499: where bid_number=bl.bid_number and bid_line_number=bl.line_number)
1500: ,null
1501: ), --OLD_NO_OF_PAYMENTS
1502: decode(p_rebid_flag, 'Y', bl.price, null), -- OLD_PRICE

Line 2393: PON_BID_PAYMENTS_SHIPMENTS source_pay,

2389: dest_pay.bid_number dest_bid_number,
2390: dest_pay.bid_line_number dest_bid_line_number,
2391: dest_pay.bid_payment_id dest_bid_payment_id
2392: FROM
2393: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2394: FND_ATTACHED_DOCUMENTS fnd,
2395: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2396: PON_BID_ITEM_PRICES bl
2397: WHERE bl.auction_header_id = p_auc_header_id

Line 2395: PON_BID_PAYMENTS_SHIPMENTS dest_pay,

2391: dest_pay.bid_payment_id dest_bid_payment_id
2392: FROM
2393: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2394: FND_ATTACHED_DOCUMENTS fnd,
2395: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2396: PON_BID_ITEM_PRICES bl
2397: WHERE bl.auction_header_id = p_auc_header_id
2398: AND bl.bid_number = p_bid_number
2399: AND bl.has_bid_flag = 'Y'

Line 2408: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'

2404: AND dest_pay.payment_display_number = source_pay.payment_display_number
2405: AND fnd.pk1_value = source_pay.bid_number
2406: AND fnd.pk2_value = source_pay.bid_line_number
2407: AND fnd.pk3_value = source_pay.bid_payment_id
2408: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'
2409: AND bl.line_number BETWEEN p_batch_start AND p_batch_end;
2410:
2411: l_module CONSTANT VARCHAR2(35) := 'Insert_into_payments';
2412: BEGIN

Line 2429: INSERT INTO pon_bid_payments_shipments

2425: message => 'In if p_copy_only_from_auc is Y' );
2426: END IF;
2427: END IF;
2428: --copy all the payments from auction payments only as supplier_enterable flag toggled from Y in prev version to N in new round or amend
2429: INSERT INTO pon_bid_payments_shipments
2430: (
2431: BID_NUMBER,
2432: BID_LINE_NUMBER,
2433: BID_PAYMENT_ID,

Line 2452: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,

2448: )
2449: (SELECT
2450: p_bid_number, --BID_NUMBER,
2451: bl.line_number, --BID_LINE_NUMBER,
2452: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,
2453: p_auc_header_id, --AUCTION_HEADER_ID,
2454: bl.line_number, --AUCTION_LINE_NUMBER,
2455: sysdate, --CREATION_DATE,
2456: p_userid, --CREATED_BY,

Line 2495: INSERT INTO pon_bid_payments_shipments

2491: message => 'Insert for lines not bid' );
2492: END IF;
2493: END IF;
2494: --copy all the payments for the lines from auction payments for lines that have not been bid
2495: INSERT INTO pon_bid_payments_shipments
2496: (
2497: BID_NUMBER,
2498: BID_LINE_NUMBER,
2499: BID_PAYMENT_ID,

Line 2518: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,

2514: )
2515: (SELECT
2516: p_bid_number, --BID_NUMBER,
2517: bl.line_number, --BID_LINE_NUMBER,
2518: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,
2519: p_auc_header_id, --AUCTION_HEADER_ID,
2520: bl.line_number, --AUCTION_LINE_NUMBER,
2521: sysdate, --CREATION_DATE,
2522: p_userid, --CREATED_BY,

Line 2550: INSERT INTO pon_bid_payments_shipments

2546: message => 'Insert for lines that were bid' );
2547: END IF;
2548: END IF;
2549: --copy all the payments for the lines from bid payments for lines that have been bid
2550: INSERT INTO pon_bid_payments_shipments
2551: (
2552: BID_NUMBER,
2553: BID_LINE_NUMBER,
2554: BID_PAYMENT_ID,

Line 2582: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,

2578: )
2579: (SELECT
2580: p_bid_number, --BID_NUMBER,
2581: bl.line_number, --BID_LINE_NUMBER,
2582: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,
2583: p_auc_header_id, --AUCTION_HEADER_ID,
2584: bl.line_number, --AUCTION_LINE_NUMBER,
2585: sysdate, --CREATION_DATE,
2586: p_userid, --CREATED_BY,

Line 2615: pon_bid_payments_shipments bpmt

2611: decode(p_rebid_flag, 'Y',bpmt.UOM_CODE, null), --OLD_UOM_CODE,
2612: decode(p_rebid_flag, 'Y',bpmt.BID_CURRENCY_PRICE, null), --OLD_BID_CURRENCY_PRICE,
2613: decode(p_rebid_flag, 'Y',bpmt.PROMISED_DATE, null) --OLD_PROMISED_DATE
2614: FROM pon_bid_item_prices bl,
2615: pon_bid_payments_shipments bpmt
2616: WHERE bl.auction_header_id = p_auc_header_id
2617: AND bl.bid_number = p_bid_number
2618: AND bpmt.bid_number = p_source_bid_num
2619: AND bpmt.bid_line_number = bl.line_number

Line 2633: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

2629: END IF;
2630: --copy the attachments for those payments which came from bid
2631: FOR payment_rec in c_bid_pymnts_attach LOOP
2632: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
2633: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2634: X_from_pk1_value => to_char(payment_rec.source_bid_number),
2635: X_from_pk2_value => to_char(payment_rec.source_bid_line_number),
2636: X_from_pk3_value => to_char(payment_rec.source_bid_payment_id),
2637: X_to_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

Line 2637: X_to_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

2633: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2634: X_from_pk1_value => to_char(payment_rec.source_bid_number),
2635: X_from_pk2_value => to_char(payment_rec.source_bid_line_number),
2636: X_from_pk3_value => to_char(payment_rec.source_bid_payment_id),
2637: X_to_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2638: X_to_pk1_value => to_char(payment_rec.dest_bid_number),
2639: X_to_pk2_value => to_char(payment_rec.dest_bid_line_number),
2640: X_to_pk3_value => to_char(payment_rec.dest_bid_payment_id),
2641: X_created_by => p_userid,