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.41 2007/05/08 10:35:32 sdarbha ship $ */
3:
4: --------------------------------------------
5: -- This is Database Session Language. --

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

703: WHERE BATCH_ID = c_batch_id ;
704:
705: BEGIN
706:
707: Write_Debug(G_PKG_NAME || 'ENG_CHANGE_IMPORT_UTIL.GET_REVISION_IMPORT_POLICY. . . ');
708: Write_Debug('-----------------------------------------' );
709: Write_Debug('p_batch_id: ' || to_char(p_batch_id));
710: Write_Debug('-----------------------------------------' );
711:

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

745: WHERE BATCH_ID = c_batch_id ;
746:
747: BEGIN
748:
749: Write_Debug(G_PKG_NAME || 'ENG_CHANGE_IMPORT_UTIL.GET_CM_IMPORT_OPTION. . . ');
750: Write_Debug('-----------------------------------------' );
751: Write_Debug('p_batch_id: ' || to_char(p_batch_id));
752: Write_Debug('-----------------------------------------' );
753:

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

3257: l_dyn_sql := ' UPDATE ' || l_intf_table(i) || ' INTF ';
3258: l_dyn_sql := l_dyn_sql || ' SET INTF.' || l_intf_ri_seq_id_col(i) ;
3259: -- Bug 5193662 : Populate the rev item id to the child recs and change id to the parent record.
3260: if l_intf_table(i) = G_ITEM_INTF then
3261: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.FIND_REV_ITEM_REC( INTF.change_id ';
3262: else
3263: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.get_Rev_item_update_parent( INTF.change_id ';
3264: END IF;
3265:

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

3259: -- Bug 5193662 : Populate the rev item id to the child recs and change id to the parent record.
3260: if l_intf_table(i) = G_ITEM_INTF then
3261: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.FIND_REV_ITEM_REC( INTF.change_id ';
3262: else
3263: l_dyn_sql := l_dyn_sql || ' = ENG_CHANGE_IMPORT_UTIL.get_Rev_item_update_parent( INTF.change_id ';
3264: END IF;
3265:
3266: l_dyn_sql := l_dyn_sql || ', INTF.organization_id ';
3267: l_dyn_sql := l_dyn_sql || ', INTF.inventory_item_id';

Line 5563: END ENG_CHANGE_IMPORT_UTIL ;

5559:
5560: END Get_Nulled_out_Value;
5561:
5562:
5563: END ENG_CHANGE_IMPORT_UTIL ;