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.

[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_PAYMENTS_SHIPMENTS

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

1373: , round(al.max_retainage_amount * g_bid_rate, g_curr_prec)
1374: )
1375: , round(al.max_retainage_amount * g_bid_rate, g_curr_prec)
1376: ),--BID_CURR_MAX_RETAINAGE_AMT
1377: decode(p_rebid_flag, 'Y', (select count(1) from pon_bid_payments_shipments
1378: where bid_number=bl.bid_number and bid_line_number=bl.line_number)
1379: ,null
1380: ), --OLD_NO_OF_PAYMENTS
1381: decode(p_rebid_flag, 'Y', bl.price, null), -- OLD_PRICE

Line 2157: PON_BID_PAYMENTS_SHIPMENTS source_pay,

2153: dest_pay.bid_number dest_bid_number,
2154: dest_pay.bid_line_number dest_bid_line_number,
2155: dest_pay.bid_payment_id dest_bid_payment_id
2156: FROM
2157: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2158: FND_ATTACHED_DOCUMENTS fnd,
2159: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2160: PON_BID_ITEM_PRICES bl
2161: WHERE bl.auction_header_id = p_auc_header_id

Line 2159: PON_BID_PAYMENTS_SHIPMENTS dest_pay,

2155: dest_pay.bid_payment_id dest_bid_payment_id
2156: FROM
2157: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2158: FND_ATTACHED_DOCUMENTS fnd,
2159: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2160: PON_BID_ITEM_PRICES bl
2161: WHERE bl.auction_header_id = p_auc_header_id
2162: AND bl.bid_number = p_bid_number
2163: AND bl.has_bid_flag = 'Y'

Line 2172: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'

2168: AND dest_pay.payment_display_number = source_pay.payment_display_number
2169: AND fnd.pk1_value = source_pay.bid_number
2170: AND fnd.pk2_value = source_pay.bid_line_number
2171: AND fnd.pk3_value = source_pay.bid_payment_id
2172: AND fnd.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'
2173: AND bl.line_number BETWEEN p_batch_start AND p_batch_end;
2174:
2175: l_module CONSTANT VARCHAR2(35) := 'Insert_into_payments';
2176: BEGIN

Line 2193: INSERT INTO pon_bid_payments_shipments

2189: message => 'In if p_copy_only_from_auc is Y' );
2190: END IF;
2191: END IF;
2192: --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
2193: INSERT INTO pon_bid_payments_shipments
2194: (
2195: BID_NUMBER,
2196: BID_LINE_NUMBER,
2197: BID_PAYMENT_ID,

Line 2216: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,

2212: )
2213: (SELECT
2214: p_bid_number, --BID_NUMBER,
2215: bl.line_number, --BID_LINE_NUMBER,
2216: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,
2217: p_auc_header_id, --AUCTION_HEADER_ID,
2218: bl.line_number, --AUCTION_LINE_NUMBER,
2219: sysdate, --CREATION_DATE,
2220: p_userid, --CREATED_BY,

Line 2259: INSERT INTO pon_bid_payments_shipments

2255: message => 'Insert for lines not bid' );
2256: END IF;
2257: END IF;
2258: --copy all the payments for the lines from auction payments for lines that have not been bid
2259: INSERT INTO pon_bid_payments_shipments
2260: (
2261: BID_NUMBER,
2262: BID_LINE_NUMBER,
2263: BID_PAYMENT_ID,

Line 2282: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,

2278: )
2279: (SELECT
2280: p_bid_number, --BID_NUMBER,
2281: bl.line_number, --BID_LINE_NUMBER,
2282: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,
2283: p_auc_header_id, --AUCTION_HEADER_ID,
2284: bl.line_number, --AUCTION_LINE_NUMBER,
2285: sysdate, --CREATION_DATE,
2286: p_userid, --CREATED_BY,

Line 2314: INSERT INTO pon_bid_payments_shipments

2310: message => 'Insert for lines that were bid' );
2311: END IF;
2312: END IF;
2313: --copy all the payments for the lines from bid payments for lines that have been bid
2314: INSERT INTO pon_bid_payments_shipments
2315: (
2316: BID_NUMBER,
2317: BID_LINE_NUMBER,
2318: BID_PAYMENT_ID,

Line 2346: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,

2342: )
2343: (SELECT
2344: p_bid_number, --BID_NUMBER,
2345: bl.line_number, --BID_LINE_NUMBER,
2346: pon_bid_payments_shipments_s1.nextval, --BID_PAYMENT_ID,
2347: p_auc_header_id, --AUCTION_HEADER_ID,
2348: bl.line_number, --AUCTION_LINE_NUMBER,
2349: sysdate, --CREATION_DATE,
2350: p_userid, --CREATED_BY,

Line 2379: pon_bid_payments_shipments bpmt

2375: decode(p_rebid_flag, 'Y',bpmt.UOM_CODE, null), --OLD_UOM_CODE,
2376: decode(p_rebid_flag, 'Y',bpmt.BID_CURRENCY_PRICE, null), --OLD_BID_CURRENCY_PRICE,
2377: decode(p_rebid_flag, 'Y',bpmt.PROMISED_DATE, null) --OLD_PROMISED_DATE
2378: FROM pon_bid_item_prices bl,
2379: pon_bid_payments_shipments bpmt
2380: WHERE bl.auction_header_id = p_auc_header_id
2381: AND bl.bid_number = p_bid_number
2382: AND bpmt.bid_number = p_source_bid_num
2383: AND bpmt.bid_line_number = bl.line_number

Line 2397: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

2393: END IF;
2394: --copy the attachments for those payments which came from bid
2395: FOR payment_rec in c_bid_pymnts_attach LOOP
2396: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
2397: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2398: X_from_pk1_value => to_char(payment_rec.source_bid_number),
2399: X_from_pk2_value => to_char(payment_rec.source_bid_line_number),
2400: X_from_pk3_value => to_char(payment_rec.source_bid_payment_id),
2401: X_to_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

Line 2401: X_to_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',

2397: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2398: X_from_pk1_value => to_char(payment_rec.source_bid_number),
2399: X_from_pk2_value => to_char(payment_rec.source_bid_line_number),
2400: X_from_pk3_value => to_char(payment_rec.source_bid_payment_id),
2401: X_to_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2402: X_to_pk1_value => to_char(payment_rec.dest_bid_number),
2403: X_to_pk2_value => to_char(payment_rec.dest_bid_line_number),
2404: X_to_pk3_value => to_char(payment_rec.dest_bid_payment_id),
2405: X_created_by => p_userid,