[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
1422: -- Check if all components are of type add the l_create_bill_for_item = 1
1423: -- l_create_bill_for_item = 0 otherwise
1424: SELECT 1, 1
1425: INTO l_structure_exists_flag, l_create_bill_for_item
1426: FROM dual
1427: WHERE NOT EXISTS (SELECT 1
1428: FROM bom_inventory_components
1429: WHERE change_notice = sl.change_notice
1430: AND revised_item_sequence_id = sl.revised_item_sequence_id
4969: ri.revised_item_id, SYSDATE) revision ,
4970: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,
4971: ri.revised_item_id, SYSDATE) revision_id
4972: INTO l_current_local_revision, l_current_local_revision_id
4973: FROM dual;
4974: EXCEPTION
4975: WHEN NO_DATA_FOUND THEN
4976: l_current_local_revision := NULL;
4977: END;
6022: IF l_change_map_id IS NULL
6023: THEN
6024: SELECT eng_change_propagation_maps_s.nextval
6025: INTO l_change_map_id
6026: FROM DUAL;
6027:
6028: INSERT INTO eng_change_propagation_maps(
6029: change_propagation_map_id
6030: , change_id