DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on FND_PROFILE

Line 376: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')

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

Line 377: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_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: )

Line 529: to_number(FND_PROFILE.Value('USER_ID')),

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:

Line 531: to_number(FND_PROFILE.Value('USER_ID')));

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,

Line 565: to_number(FND_PROFILE.Value('USER_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

Line 567: to_number(FND_PROFILE.Value('USER_ID')));

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,

Line 639: (user_id=>FND_PROFILE.Value('USER_ID'),

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:

Line 640: resp_id=>FND_PROFILE.Value('RESP_ID'),

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 **/

Line 641: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),

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 ;

Line 642: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;

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');

Line 1062: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);

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

Line 1503: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);

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

Line 4635: l_component_rec.created_by := FND_PROFILE.value('USER_ID');

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');

Line 4637: l_component_rec.last_updated_by := FND_PROFILE.value('USER_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');

Line 4638: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_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;

Line 4639: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');

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:

Line 4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_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:
4644: INSERT INTO BOM_COMPONENTS_B

Line 4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');

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