APPS.ENG_CHANGE_IMPORT_UTIL dependencies on ENG_CHANGE_IMPORT_UTIL

Line 1: package body ENG_CHANGE_IMPORT_UTIL as

1: package body ENG_CHANGE_IMPORT_UTIL as
2: /*$Header: ENGUCMIB.pls 120.51 2012/03/09 03:12:20 lanhuang ship $ */
3:
4: --------------------------------------------
5: -- This is Database Session Language. --

Line 711: Write_Debug(G_PKG_NAME || 'ENG_CHANGE_IMPORT_UTIL.GET_REVISION_IMPORT_POLICY. . . ');

707: WHERE BATCH_ID = c_batch_id ;
708:
709: BEGIN
710:
711: Write_Debug(G_PKG_NAME || 'ENG_CHANGE_IMPORT_UTIL.GET_REVISION_IMPORT_POLICY. . . ');
712: Write_Debug('-----------------------------------------' );
713: Write_Debug('p_batch_id: ' || to_char(p_batch_id));
714: Write_Debug('-----------------------------------------' );
715:

Line 753: Write_Debug(G_PKG_NAME || 'ENG_CHANGE_IMPORT_UTIL.GET_CM_IMPORT_OPTION. . . ');

749: WHERE BATCH_ID = c_batch_id ;
750:
751: BEGIN
752:
753: Write_Debug(G_PKG_NAME || 'ENG_CHANGE_IMPORT_UTIL.GET_CM_IMPORT_OPTION. . . ');
754: Write_Debug('-----------------------------------------' );
755: Write_Debug('p_batch_id: ' || to_char(p_batch_id));
756: Write_Debug('-----------------------------------------' );
757:

Line 3367: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.FIND_REV_ITEM_REC( INTF.change_id ';

3363: l_dyn_sql := ' UPDATE ' || l_intf_table(i) || ' INTF ';
3364: l_dyn_sql := l_dyn_sql || ' SET INTF.' || l_intf_ri_seq_id_col(i) ;
3365: -- Bug 5193662 : Populate the rev item id to the child recs and change id to the parent record.
3366: if l_intf_table(i) = G_ITEM_INTF then
3367: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.FIND_REV_ITEM_REC( INTF.change_id ';
3368: else
3369: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.get_Rev_item_update_parent( INTF.change_id ';
3370: END IF;
3371:

Line 3369: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.get_Rev_item_update_parent( INTF.change_id ';

3365: -- Bug 5193662 : Populate the rev item id to the child recs and change id to the parent record.
3366: if l_intf_table(i) = G_ITEM_INTF then
3367: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.FIND_REV_ITEM_REC( INTF.change_id ';
3368: else
3369: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.get_Rev_item_update_parent( INTF.change_id ';
3370: END IF;
3371:
3372: l_dyn_sql := l_dyn_sql || ', INTF.organization_id ';
3373: l_dyn_sql := l_dyn_sql || ', INTF.inventory_item_id';

Line 5703: ,buff => '[ENG_CHANGE_IMPORT_UTIL] '||msg);

5699: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
5700: IF NVL(FND_GLOBAL.conc_request_id, -1) <> -1 THEN
5701:
5702: FND_FILE.put_line(which => FND_FILE.LOG
5703: ,buff => '[ENG_CHANGE_IMPORT_UTIL] '||msg);
5704: END IF;
5705: END IF;
5706: EXCEPTION
5707: WHEN OTHERS THEN

Line 6142: END ENG_CHANGE_IMPORT_UTIL ;

6138:
6139:
6140:
6141:
6142: END ENG_CHANGE_IMPORT_UTIL ;