372: WHERE
373: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
374: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
375: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID
376: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
377: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')
378: AND msi.INVENTORY_ITEM_ID = common_item_from
379: AND orgs.ORGANIZATION_ID <> current_org_id
380: AND child_org.ORGANIZATION_ID = current_org_id
373: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
374: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
375: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID
376: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
377: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')
378: AND msi.INVENTORY_ITEM_ID = common_item_from
379: AND orgs.ORGANIZATION_ID <> current_org_id
380: AND child_org.ORGANIZATION_ID = current_org_id
381: )
525: 1,
526: 2,
527: l_assembly_type,
528: SYSDATE,
529: to_number(FND_PROFILE.Value('USER_ID')),
530: SYSDATE,
531: to_number(FND_PROFILE.Value('USER_ID')));
532:
533:
527: l_assembly_type,
528: SYSDATE,
529: to_number(FND_PROFILE.Value('USER_ID')),
530: SYSDATE,
531: to_number(FND_PROFILE.Value('USER_ID')));
532:
533:
534: INSERT INTO bom_delete_entities
535: (DELETE_ENTITY_SEQUENCE_ID,
561: l_assembly_item_name,
562: 1,
563: 1,
564: SYSDATE,
565: to_number(FND_PROFILE.Value('USER_ID')),
566: SYSDATE,
567: to_number(FND_PROFILE.Value('USER_ID')));
568:
569: Bom_Delete_Groups_Api.Delete_Groups
563: 1,
564: SYSDATE,
565: to_number(FND_PROFILE.Value('USER_ID')),
566: SYSDATE,
567: to_number(FND_PROFILE.Value('USER_ID')));
568:
569: Bom_Delete_Groups_Api.Delete_Groups
570: (ERRBUF => ERROR_MSG,
571: RETCODE => RETCOD,
635: l_bom_header_rec.enable_attrs_update := enable_attrs_update;
636:
637: /** Initialize the System Information **/
638: FND_GLOBAL.apps_initialize
639: (user_id=>FND_PROFILE.Value('USER_ID'),
640: resp_id=>FND_PROFILE.Value('RESP_ID'),
641: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
642: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
643:
636:
637: /** Initialize the System Information **/
638: FND_GLOBAL.apps_initialize
639: (user_id=>FND_PROFILE.Value('USER_ID'),
640: resp_id=>FND_PROFILE.Value('RESP_ID'),
641: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
642: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
643:
644: /** Initialize the message list **/
637: /** Initialize the System Information **/
638: FND_GLOBAL.apps_initialize
639: (user_id=>FND_PROFILE.Value('USER_ID'),
640: resp_id=>FND_PROFILE.Value('RESP_ID'),
641: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
642: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
643:
644: /** Initialize the message list **/
645: ERROR_HANDLER.INITIALIZE ;
638: FND_GLOBAL.apps_initialize
639: (user_id=>FND_PROFILE.Value('USER_ID'),
640: resp_id=>FND_PROFILE.Value('RESP_ID'),
641: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
642: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
643:
644: /** Initialize the message list **/
645: ERROR_HANDLER.INITIALIZE ;
646: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling BOM_BO_PUB.PROCESS_BOM');
1058: l_pend_op_seq NUMBER;
1059:
1060: BEGIN
1061:
1062: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1063: --arudresh_debug('BOM:DEFAULT_WIP_VALUES'|| default_wip_params);
1064: SELECT assembly_item_id, organization_id, alternate_bom_designator, effectivity_control
1065: into l_assy_item_id, l_dest_org_id, l_alt_bom_desg, l_effectivity_ctrl
1066: from BOM_STRUCTURES_B
1499:
1500: BEGIN
1501:
1502: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;
1503: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1504:
1505: SELECT operation_seq_num
1506: INTO l_operation_seq_num
1507: FROM BOM_COMPONENTS_B
4631: l_component_rec.common_component_sequence_id := p_src_comp_seq_id;
4632: l_component_rec.revised_item_sequence_id := l_gen_rev_item_seq_id;
4633: -- who columns
4634: l_component_rec.creation_date := sysdate;
4635: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4636: l_component_rec.last_update_date := sysdate;
4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4633: -- who columns
4634: l_component_rec.creation_date := sysdate;
4635: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4636: l_component_rec.last_update_date := sysdate;
4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4634: l_component_rec.creation_date := sysdate;
4635: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4636: l_component_rec.last_update_date := sysdate;
4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4642: l_component_rec.program_update_date := sysdate;
4635: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4636: l_component_rec.last_update_date := sysdate;
4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4642: l_component_rec.program_update_date := sysdate;
4643:
4636: l_component_rec.last_update_date := sysdate;
4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4642: l_component_rec.program_update_date := sysdate;
4643:
4644: INSERT INTO BOM_COMPONENTS_B
4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4642: l_component_rec.program_update_date := sysdate;
4643:
4644: INSERT INTO BOM_COMPONENTS_B
4645: ( SUPPLY_SUBINVENTORY