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.OE_PREPAYMENT_UTIL dependencies on OE_PAYMENTS

Line 62: FROM oe_payments

58: IF p_validation_entity_short_name = 'HEADER' THEN
59: BEGIN
60: SELECT 1
61: INTO l_prepaid
62: FROM oe_payments
63: WHERE header_id = l_header_id
64: AND payment_type_code = 'CREDIT_CARD';
65: EXCEPTION
66: WHEN NO_DATA_FOUND THEN

Line 83: FROM oe_payments

79: IF Is_Prepaid_order(l_header_id) = 'Y' THEN
80: BEGIN
81: SELECT 1
82: INTO l_prepaid
83: FROM oe_payments
84: WHERE header_id = l_header_id
85: AND payment_type_code = 'CREDIT_CARD';
86: EXCEPTION
87: WHEN NO_DATA_FOUND THEN

Line 134: FROM oe_payments

130: /**
131: BEGIN
132: SELECT 1
133: INTO p_result
134: FROM oe_payments
135: WHERE header_id = l_header_id
136: AND payment_set_id is not null
137: AND rownum=1;
138: EXCEPTION

Line 193: FROM oe_payments

189: SELECT max(payment_set_id)
190: , sum(nvl(prepaid_amount, 0))
191: INTO x_payment_set_id
192: ,x_prepaid_amount
193: FROM oe_payments
194: WHERE header_id = p_header_id
195: AND payment_set_id IS NOT NULL;
196: EXCEPTION
197: WHEN NO_DATA_FOUND THEN

Line 218: FROM oe_payments

214: SELECT payment_set_id
215: ,prepaid_amount
216: INTO x_payment_set_id
217: ,x_prepaid_amount
218: FROM oe_payments
219: WHERE header_id = p_header_id
220: AND payment_type_code = 'CREDIT_CARD';
221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add( 'PREPAID ORDER. X_PAYMENT_SET_ID: '||X_PAYMENT_SET_ID||' , X_PREPAID_AMOUNT: '||X_PREPAID_AMOUNT ) ;

Line 253: ,'OE_PAYMENTS_UTIL.Get_PrePayment_Info'

249: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg
252: ( G_PKG_NAME
253: ,'OE_PAYMENTS_UTIL.Get_PrePayment_Info'
254: );
255: END IF;
256:
257: END Get_PrePayment_Info;

Line 340: ,oe_payments op

336: FROM oe_order_headers oh
337: ,oe_order_holds_all hd --moac
338: ,oe_hold_sources_all hs --moac
339: ,iby_trxn_extensions_v ite -- ccencryption
340: ,oe_payments op
341: WHERE oh.header_id= hd.header_id
342: AND hd.hold_source_id = hs.hold_source_id
343: AND hs.hold_id in (l_hold1, l_hold2, l_hold3, l_hold4)
344: * (SELECT hold_id -- replace the sql with hardcoded hold_id once it is seeded: Also based on what holds should be processed

Line 385: ,oe_payments op

381: ,oh.org_id --bug4689411
382: FROM oe_order_headers oh
383: ,oe_order_holds_all hd --moac
384: ,oe_hold_sources_all hs --moac
385: ,oe_payments op
386: -- iby_trxn_extensions_v ite -- ccencryption
387: ,IBY_FNDCPT_TX_EXTENSIONS x
388: ,IBY_PMT_INSTR_USES_ALL u
389: ,IBY_CREDITCARD c

Line 433: ,oe_payments op

429: ,oh.org_id --bug4689411
430: FROM oe_order_headers oh
431: ,oe_order_holds_all hd --moac
432: ,oe_hold_sources_all hs --moac
433: ,oe_payments op
434: WHERE oh.header_id= hd.header_id
435: AND hd.hold_source_id = hs.hold_source_id
436: AND hs.hold_id in (l_hold1, l_hold2, l_hold3)
437: /* (SELECT hold_id -- replace the sql with hardcoded hold_id once it is seeded: Also based on what holds should be processed

Line 473: ,oe_payments op

469: FROM oe_order_lines_all ol --moac
470: ,oe_order_headers oh
471: ,oe_order_holds_all hd --moac
472: ,oe_hold_sources_all hs --moac
473: ,oe_payments op
474: -- ,iby_trxn_extensions_v ite -- ccencryption
475: ,IBY_FNDCPT_TX_EXTENSIONS x
476: ,IBY_PMT_INSTR_USES_ALL u
477: ,IBY_CREDITCARD c

Line 542: oe_debug_pub.add( 'ENTERING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;

538: --
539: BEGIN
540:
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add( 'ENTERING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;
543: oe_debug_pub.add('Operating unit passed -->'||p_operating_unit);
544: END IF;
545: --R12 MOAC Changes
546: --MOAC set policy context for single Org

Line 902: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;

898: END LOOP;
899:
900: retcode := 0;
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;
903: END IF;
904: --rollback;
905: EXCEPTION
906:

Line 975: FROM oe_payments

971: l_header_id := p_header_rec.header_id;
972: BEGIN
973: SELECT count(*)
974: INTO l_count
975: FROM oe_payments
976: WHERE header_id = l_header_id
977: AND payment_type_code <> 'COMMITMENT'
978: AND nvl(payment_collection_event, 'PREPAY') = 'PREPAY';
979: IF l_count > 0 THEN

Line 1079: FROM oe_payments

1075: IF IS_MULTIPLE_PAYMENTS_ENABLED THEN
1076: BEGIN
1077: SELECT count(*)
1078: INTO l_count
1079: FROM oe_payments
1080: WHERE header_id = p_header_id
1081: AND payment_type_code <> 'COMMITMENT'
1082: AND nvl(payment_collection_event, 'PREPAY') = 'PREPAY';
1083: IF l_count > 0 THEN

Line 1269: FROM oe_payments

1265: -- if exists any full prepaid orders.
1266: BEGIN
1267: SELECT count(*)
1268: INTO l_payment_count
1269: FROM oe_payments
1270: WHERE payment_collection_event IS NULL
1271: AND header_id = p_header_id;
1272: EXCEPTION WHEN NO_DATA_FOUND THEN
1273: l_payment_count := 0;

Line 1288: FROM oe_payments

1284: ELSIF l_payment_count = 0 THEN
1285: BEGIN
1286: SELECT count(*)
1287: INTO l_multipay_count
1288: FROM oe_payments
1289: WHERE header_id = p_header_id;
1290: EXCEPTION WHEN NO_DATA_FOUND THEN
1291: l_multipay_count := 0;
1292: END;