APPS.OE_INF_POPULATE_PUB dependencies on OE_PAYMENTS

Line 1316: Insert into oe_payments_interface

1312:
1313:
1314: /* Line Level Payments */
1315:
1316: Insert into oe_payments_interface
1317: (
1318: ORDER_SOURCE_ID,
1319: change_sequence,
1320: PAYMENT_TRX_ID,

Line 1415: FROM OE_PAYMENTS

1411: ,to_char(order_number_v)
1412: ,get_line_ref_from_line_id(line_id)
1413: ,''
1414: ,''
1415: FROM OE_PAYMENTS
1416: where header_id = old_header_id_v
1417: and line_id is not null;
1418:
1419: IF SQL%ROWCOUNT > 0 THEN

Line 1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

1417: and line_id is not null;
1418:
1419: IF SQL%ROWCOUNT > 0 THEN
1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1422: END IF;
1423: ELSE
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

Line 1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1422: END IF;
1423: ELSE
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1426: END IF;
1427: END IF;
1428:
1429: /* Header Payments */

Line 1431: Insert into oe_payments_interface

1427: END IF;
1428:
1429: /* Header Payments */
1430:
1431: Insert into oe_payments_interface
1432: (
1433: ORDER_SOURCE_ID,
1434: change_sequence,
1435: PAYMENT_TRX_ID,

Line 1530: FROM OE_PAYMENTS

1526: ,to_char(order_number_v)
1527: ,get_line_ref_from_line_id(line_id)
1528: ,''
1529: ,''
1530: FROM OE_PAYMENTS
1531: where header_id = old_header_id_v
1532: and line_id is null;
1533:
1534: IF SQL%ROWCOUNT > 0 THEN

Line 1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

1532: and line_id is null;
1533:
1534: IF SQL%ROWCOUNT > 0 THEN
1535: IF l_debug_level > 0 THEN
1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1537: END IF;
1538: ELSE
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

Line 1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1537: END IF;
1538: ELSE
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1541: END IF;
1542: END IF;
1543:
1544: /* Line Level Price Adjustment */