APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 345: from mtl_system_items_interface msii

341: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
342: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) change_type_id,
343: 1 status_code,
344: 1 APPROVAL_STATUS_TYPE
345: from mtl_system_items_interface msii
346: where msii.set_process_id = p_batch_id
347: and msii.process_flag = l_process_flag
348: -- and msii.transaction_type=L_TRANSACTION_TYPE
349: ;

Line 362: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

358: msii.organization_id
359: bulk collect INTO l_icc_array ,
360: l_change_type_array,
361: l_org_array
362: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
363: MTL_ITEM_CATALOG_GROUPS_VL micg,
364: ENG_CHANGE_ORDER_TYPES_VL eng_types,
365: MTL_PARAMETERS mp
366: WHERE msii.set_process_id=P_BATCH_ID

Line 400: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

396: msii.organization_id
397: BULK COLLECT INTO l_icc_array ,
398: l_change_type_array,
399: l_org_array
400: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
401: ENG_CHANGE_ORDER_TYPES_VL eng_types,
402: MTL_PARAMETERS mp,
403: ego_item_cat_denorm_hier heir,
404: mtl_item_catalog_groups_b micgb

Line 431: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

427: msii.organization_id
428: bulk collect INTO l_icc_array ,
429: l_change_type_array,
430: l_org_array
431: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
432: -- ENG_CHANGE_ORDER_TYPES eng_types,
433: MTL_PARAMETERS mp
434: WHERE msii.set_process_id=P_BATCH_ID
435: AND PROCESS_FLAG = l_process_flag

Line 476: update mtl_system_items_interface msii

472: batch_id => p_batch_id) ;
473:
474: if l_return_status = 'G'
475: then
476: update mtl_system_items_interface msii
477: set process_flag= 3
478: where msii.set_process_id = P_BATCH_ID
479: AND PROCESS_FLAG = l_process_flag
480: AND msii.ITEM_CATALOG_GROUP_ID = l_icc_array(i)

Line 486: from mtl_system_items_interface msii

482: ;
483:
484: select transaction_id
485: bulk collect into l_transaction_array
486: from mtl_system_items_interface msii
487: where msii.set_process_id = P_BATCH_ID
488: AND PROCESS_FLAG = 3
489: AND msii.ITEM_CATALOG_GROUP_ID = l_icc_array(i)
490: -- AND msii.TRANSACTION_TYPE = L_TRANSACTION_TYPE

Line 504: ,'MTL_SYSTEM_ITEMS_INTERFACE'

500: FND_GLOBAL.CONC_REQUEST_ID
501: ,l_transaction_array(i) -- Row specific
502: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
503: ,'ITEM_NUMBER' -- Column Name on which error occured
504: ,'MTL_SYSTEM_ITEMS_INTERFACE'
505: ,'INV_IOI_NO_AUTO_NIR' -- Message Name, If u want to specify the text directly, pass this as 'INV_IOI_ERR'
506: ,l_error_text);
507: END LOOP;
508: -- x_return_status := 'S';

Line 517: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

513:
514: END IF;
515: END LOOP;
516: forall count IN l_change_ids_array.FIRST .. l_change_ids_array.LAST
517: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
518: set change_id = l_change_ids_array(count)
519: WHERE ITEM_CATALOG_GROUP_ID = l_icc_array(count)
520: AND ORGANIZATION_ID = l_org_array(count)
521: AND set_process_id = p_batch_id

Line 543: FROM MTL_SYSTEM_ITEMS_INTERFACE

539: end if;
540: l_change_ids_array := NIR_CHANGE_TABLE();
541: select inventory_item_id ,transaction_id
542: bulk collect into l_item_ids_array,l_transaction_array
543: FROM MTL_SYSTEM_ITEMS_INTERFACE
544: where ITEM_CATALOG_GROUP_ID = l_icc_array(i)
545: AND ORGANIZATION_ID = l_org_array(i)
546: AND set_process_id = p_batch_id
547: AND PROCESS_FLAG = l_process_flag

Line 579: ,'MTL_SYSTEM_ITEMS_INTERFACE'

575: FND_GLOBAL.CONC_REQUEST_ID
576: ,l_transaction_array(i) -- Row specific
577: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
578: ,'ITEM_NUMBER' -- Column Name on which error occured
579: ,'MTL_SYSTEM_ITEMS_INTERFACE'
580: ,'INV_IOI_NO_AUTO_NIR' -- Message Name, If u want to specify the text directly, pass this as 'INV_IOI_ERR'
581: ,l_error_text);
582:
583: else

Line 593: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

589: end if;
590: END LOOP;
591:
592: forall count in l_change_ids_array.FIRST .. l_change_ids_array.LAST
593: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
594: set change_id = l_change_ids_array(count)
595: WHERE ITEM_CATALOG_GROUP_ID = l_icc_array(i)
596: AND ORGANIZATION_ID = l_org_array(i)
597: AND set_process_id = p_batch_id

Line 605: update mtl_system_items_interface msii

601: END LOOP;
602:
603: END IF;
604:
605: update mtl_system_items_interface msii
606: set change_line_id = ENG_CHANGE_LINES_S.nextval
607: where msii.set_process_id = p_batch_id
608: and msii.process_flag= l_process_flag
609: -- and msii.transaction_type=L_TRANSACTION_TYPE

Line 640: from mtl_system_items_interface msii

636: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
637: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) TYPE_ID,
638: 1 ,
639: 1
640: from mtl_system_items_interface msii
641: where msii.set_process_id = p_batch_id
642: and msii.process_flag = l_process_flag
643: -- and msii.transaction_type=L_TRANSACTION_TYPE
644: );

Line 701: from mtl_system_items_interface msii,

697: FND_GLOBAL.USER_ID,
698: LANGS.LANGUAGE_CODE,
699: USERENV('LANG'),
700: msii.change_line_id
701: from mtl_system_items_interface msii,
702: FND_LANGUAGES LANGS
703: where msii.set_process_id = p_batch_id
704: and msii.process_flag = l_process_flag
705: -- and msii.transaction_type=L_TRANSACTION_TYPE

Line 748: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';

744: l_dynamic_sql := l_dynamic_sql ||
745: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
746: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
747: ' , FND_GLOBAL.USER_ID, SYSDATE'||
748: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
749:
750: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'
751: then
752: l_dynamic_sql := l_dynamic_sql ||' ,MTL_ITEM_REVISIONS_INTERFACE MIRI '||