DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on ENG_NEW_ITEM_REQ_UTIL

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

2927: AND ROWNUM = 1
2928: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
2929: START WITH ICC.ITEM_CATALOG_GROUP_ID = interface.ITEM_CATALOG_GROUP_ID ) );
2930:
2931: ENG_NEW_ITEM_REQ_UTIL.create_new_item_requests( p_batch_id => p_set_process_id,
2932: p_nir_option => l_nir_import_option,
2933: x_return_status => l_ret_status,
2934: x_msg_data => l_msg_data,
2935: x_msg_count => l_msg_count );

Line 3039: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3036: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3037: EXECUTE IMMEDIATE
3038: ' BEGIN '
3039: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3040: ||' change_number => :i.ITEM_NUMBER '
3041: ||' ,change_name => :i.ITEM_NUMBER '
3042: ||' ,change_type_code => :l_type_name '
3043: ||' ,item_number => :i.ITEM_NUMBER '

Line 3619: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3616: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3617: EXECUTE IMMEDIATE
3618: ' BEGIN '
3619: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3620: ||' change_number => :p_item_number '
3621: ||' ,change_name => :p_item_number '
3622: ||' ,change_type_code => :l_type_code '
3623: ||' ,item_number => :p_item_number '

Line 3678: ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Requests( p_batch_id => p_xset_id

3674: UPDATE mtl_system_items_interface
3675: SET process_flag = 5
3676: WHERE rowid = p_row_id;
3677:
3678: ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Requests( p_batch_id => p_xset_id
3679: ,p_nir_option => 'I'
3680: ,x_return_status => l_return_status
3681: ,x_msg_data => l_err_text
3682: ,x_msg_count => l_msg_count);