[Home] [Help]
399: LOOP
400: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Inserting into eng_attachment_changes..');
401: SELECT ENG_ATTACHMENT_CHANGES_S.nextval
402: INTO l_change_document_id
403: FROM dual;
404:
405: INSERT INTO eng_attachment_changes (
406: CHANGE_ID
407: , REVISED_ITEM_SEQUENCE_ID
589: THEN
590: l_item_sourced := 2;
591: -- Scoped out
592: /*BEGIN
593: select 1 into l_item_sourced from dual
594: where exists (select 1 from mrp_sources_v
595: where assignment_set_id = FND_PROFILE.VALUE( 'MRP_DEFAULT_ASSIGNMENT_SET' )
596: and organization_id = g_global_org_id
597: and inventory_item_id = p_revised_item_id
1425: -- Check if all components are of type add the l_create_bill_for_item = 1
1426: -- l_create_bill_for_item = 0 otherwise
1427: SELECT 1, 1
1428: INTO l_structure_exists_flag, l_create_bill_for_item
1429: FROM dual
1430: WHERE NOT EXISTS (SELECT 1
1431: FROM bom_inventory_components
1432: WHERE change_notice = sl.change_notice
1433: AND revised_item_sequence_id = sl.revised_item_sequence_id
5096: ri.revised_item_id, SYSDATE) revision ,
5097: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,
5098: ri.revised_item_id, SYSDATE) revision_id
5099: INTO l_current_local_revision, l_current_local_revision_id
5100: FROM dual;
5101: EXCEPTION
5102: WHEN NO_DATA_FOUND THEN
5103: l_current_local_revision := NULL;
5104: END;
5849: LOOP
5850:
5851: SELECT EGO_EXTFWK_S.NEXTVAL
5852: INTO l_ext_id_nextval
5853: FROM DUAL;
5854:
5855: INSERT INTO ENG_CHANGES_EXT_B (
5856: EXTENSION_ID ,
5857: CHANGE_ID ,
6495: IF l_change_map_id IS NULL
6496: THEN
6497: SELECT eng_change_propagation_maps_s.nextval
6498: INTO l_change_map_id
6499: FROM DUAL;
6500:
6501: INSERT INTO eng_change_propagation_maps(
6502: change_propagation_map_id
6503: , change_id