APPS.INV_EGO_REVISION_VALIDATE dependencies on ENG_NEW_ITEM_REQ_UTIL

Line 3141: ENG_NEW_ITEM_REQ_UTIL.create_new_item_requests( p_batch_id => p_set_process_id,

3137: AND ROWNUM = 1
3138: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
3139: START WITH ICC.ITEM_CATALOG_GROUP_ID = interface.ITEM_CATALOG_GROUP_ID ) );
3140:
3141: ENG_NEW_ITEM_REQ_UTIL.create_new_item_requests( p_batch_id => p_set_process_id,
3142: p_nir_option => l_nir_import_option,
3143: x_return_status => l_ret_status,
3144: x_msg_data => l_msg_data,
3145: x_msg_count => l_msg_count );

Line 3249: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

3245: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3246: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3247: EXECUTE IMMEDIATE
3248: ' BEGIN '
3249: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3250: ||' change_number => :i.ITEM_NUMBER '
3251: ||' ,change_name => :i.ITEM_NUMBER '
3252: ||' ,change_type_code => :l_type_name '
3253: ||' ,item_number => :i.ITEM_NUMBER '

Line 3840: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

3836: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3837: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3838: EXECUTE IMMEDIATE
3839: ' BEGIN '
3840: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3841: ||' change_number => :p_item_number '
3842: ||' ,change_name => :p_item_number '
3843: ||' ,change_type_code => :l_type_code '
3844: ||' ,item_number => :p_item_number '

Line 3899: ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Requests( p_batch_id => p_xset_id

3895: UPDATE mtl_system_items_interface
3896: SET process_flag = 5
3897: WHERE rowid = p_row_id;
3898:
3899: ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Requests( p_batch_id => p_xset_id
3900: ,p_nir_option => 'I'
3901: ,x_return_status => l_return_status
3902: ,x_msg_data => l_err_text
3903: ,x_msg_count => l_msg_count);