APPS.OE_INF_POPULATE_PUB dependencies on OE_PRICE_ADJS_IFACE_ALL

Line 1165: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL' ) ;

1161: END IF;
1162: END IF;
1163:
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL' ) ;
1166: END IF;
1167:
1168: /* Header Level Price Adjustment */
1169: INSERT INTO OE_PRICE_ADJS_IFACE_ALL (

Line 1169: INSERT INTO OE_PRICE_ADJS_IFACE_ALL (

1165: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL' ) ;
1166: END IF;
1167:
1168: /* Header Level Price Adjustment */
1169: INSERT INTO OE_PRICE_ADJS_IFACE_ALL (
1170: PROGRAM_ID /*NUMBER(22)*/
1171: , PROGRAM_UPDATE_DATE /*DATE(7)*/
1172: , REQUEST_ID /*NUMBER(22)*/
1173: , OPERATION_CODE /*VARCHAR2(30)*/

Line 1301: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;

1297: and applied_Flag = 'Y';
1298:
1299: IF SQL%ROWCOUNT > 0 THEN
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;
1302: END IF;
1303: ELSE
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;

Line 1305: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;

1301: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;
1302: END IF;
1303: ELSE
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;
1306: END IF;
1307: END IF;
1308:
1309: IF l_debug_level > 0 THEN

Line 1310: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR LINE' ) ;

1306: END IF;
1307: END IF;
1308:
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR LINE' ) ;
1311: END IF;
1312:
1313:
1314: /* Line Level Payments */

Line 1545: INSERT INTO OE_PRICE_ADJS_IFACE_ALL (

1541: END IF;
1542: END IF;
1543:
1544: /* Line Level Price Adjustment */
1545: INSERT INTO OE_PRICE_ADJS_IFACE_ALL (
1546: PROGRAM_ID /*NUMBER(22)*/
1547: , PROGRAM_UPDATE_DATE /*DATE(7)*/
1548: , REQUEST_ID /*NUMBER(22)*/
1549: , OPERATION_CODE /*VARCHAR2(30)*/