DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on FND_PROFILE

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

274: WHERE
275: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
276: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
277: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID
278: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
279: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')
280: AND msi.INVENTORY_ITEM_ID = common_item_from
281: AND orgs.ORGANIZATION_ID <> current_org_id
282: AND child_org.ORGANIZATION_ID = current_org_id

Line 279: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')

275: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
276: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
277: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID
278: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
279: AND oav.RESP_APPLICATION_ID = FND_PROFILE.value('RESP_APPL_ID')
280: AND msi.INVENTORY_ITEM_ID = common_item_from
281: AND orgs.ORGANIZATION_ID <> current_org_id
282: AND child_org.ORGANIZATION_ID = current_org_id
283: )

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

427: 1,
428: 2,
429: l_assembly_type,
430: SYSDATE,
431: to_number(FND_PROFILE.Value('USER_ID')),
432: SYSDATE,
433: to_number(FND_PROFILE.Value('USER_ID')));
434:
435:

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

429: l_assembly_type,
430: SYSDATE,
431: to_number(FND_PROFILE.Value('USER_ID')),
432: SYSDATE,
433: to_number(FND_PROFILE.Value('USER_ID')));
434:
435:
436: INSERT INTO bom_delete_entities
437: (DELETE_ENTITY_SEQUENCE_ID,

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

463: l_assembly_item_name,
464: 1,
465: 1,
466: SYSDATE,
467: to_number(FND_PROFILE.Value('USER_ID')),
468: SYSDATE,
469: to_number(FND_PROFILE.Value('USER_ID')));
470:
471: Bom_Delete_Groups_Api.Delete_Groups

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

465: 1,
466: SYSDATE,
467: to_number(FND_PROFILE.Value('USER_ID')),
468: SYSDATE,
469: to_number(FND_PROFILE.Value('USER_ID')));
470:
471: Bom_Delete_Groups_Api.Delete_Groups
472: (ERRBUF => ERROR_MSG,
473: RETCODE => RETCOD,

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

537: l_bom_header_rec.enable_attrs_update := enable_attrs_update;
538:
539: /** Initialize the System Information **/
540: FND_GLOBAL.apps_initialize
541: (user_id=>FND_PROFILE.Value('USER_ID'),
542: resp_id=>FND_PROFILE.Value('RESP_ID'),
543: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
544: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
545:

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

538:
539: /** Initialize the System Information **/
540: FND_GLOBAL.apps_initialize
541: (user_id=>FND_PROFILE.Value('USER_ID'),
542: resp_id=>FND_PROFILE.Value('RESP_ID'),
543: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
544: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
545:
546: /** Initialize the message list **/

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

539: /** Initialize the System Information **/
540: FND_GLOBAL.apps_initialize
541: (user_id=>FND_PROFILE.Value('USER_ID'),
542: resp_id=>FND_PROFILE.Value('RESP_ID'),
543: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
544: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
545:
546: /** Initialize the message list **/
547: ERROR_HANDLER.INITIALIZE ;

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

540: FND_GLOBAL.apps_initialize
541: (user_id=>FND_PROFILE.Value('USER_ID'),
542: resp_id=>FND_PROFILE.Value('RESP_ID'),
543: resp_appl_id=>FND_PROFILE.Value('RESP_APPL_ID'),
544: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
545:
546: /** Initialize the message list **/
547: ERROR_HANDLER.INITIALIZE ;
548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling BOM_BO_PUB.PROCESS_BOM');

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

854: l_pend_op_seq NUMBER;
855:
856: BEGIN
857:
858: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
859: --arudresh_debug('BOM:DEFAULT_WIP_VALUES'|| default_wip_params);
860: SELECT assembly_item_id, organization_id, alternate_bom_designator, effectivity_control
861: into l_assy_item_id, l_dest_org_id, l_alt_bom_desg, l_effectivity_ctrl
862: from BOM_STRUCTURES_B

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

1294:
1295: BEGIN
1296:
1297: l_Bo_Id := Bom_Globals.Get_Bo_Identifier;
1298: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1299:
1300: SELECT operation_seq_num
1301: INTO l_operation_seq_num
1302: FROM BOM_COMPONENTS_B

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

4283: l_component_rec.common_component_sequence_id := p_src_comp_seq_id;
4284: l_component_rec.revised_item_sequence_id := l_gen_rev_item_seq_id;
4285: -- who columns
4286: l_component_rec.creation_date := sysdate;
4287: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4288: l_component_rec.last_update_date := sysdate;
4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4291: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');

Line 4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');

4285: -- who columns
4286: l_component_rec.creation_date := sysdate;
4287: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4288: l_component_rec.last_update_date := sysdate;
4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4291: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4292: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4293: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');

Line 4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');

4286: l_component_rec.creation_date := sysdate;
4287: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4288: l_component_rec.last_update_date := sysdate;
4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4291: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4292: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4293: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4294: l_component_rec.program_update_date := sysdate;

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

4287: l_component_rec.created_by := FND_PROFILE.value('USER_ID');
4288: l_component_rec.last_update_date := sysdate;
4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4291: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4292: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4293: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4294: l_component_rec.program_update_date := sysdate;
4295:

Line 4292: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');

4288: l_component_rec.last_update_date := sysdate;
4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4291: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4292: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4293: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4294: l_component_rec.program_update_date := sysdate;
4295:
4296: INSERT INTO BOM_COMPONENTS_B

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

4289: l_component_rec.last_updated_by := FND_PROFILE.value('USER_ID');
4290: l_component_rec.last_update_login := FND_PROFILE.value('LOGIN_ID');
4291: l_component_rec.request_id := FND_PROFILE.value('REQUEST_ID');
4292: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4293: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4294: l_component_rec.program_update_date := sysdate;
4295:
4296: INSERT INTO BOM_COMPONENTS_B
4297: ( SUPPLY_SUBINVENTORY