eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENGPKIMP dependencies on FND_PROFILE

Line 1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')

1295: UPDATE bom_components_b bcb
1296: SET bcb.old_component_sequence_id = c_dest_comp_rec.component_sequence_id
1297: , bcb.common_component_sequence_id = p_src_comp_seq_id
1298: , bcb.last_update_date = sysdate
1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1300: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1301: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1302: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1303: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

Line 1300: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')

1296: SET bcb.old_component_sequence_id = c_dest_comp_rec.component_sequence_id
1297: , bcb.common_component_sequence_id = p_src_comp_seq_id
1298: , bcb.last_update_date = sysdate
1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1300: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1301: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1302: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1303: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1304: , bcb.program_update_date = sysdate

Line 1301: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')

1297: , bcb.common_component_sequence_id = p_src_comp_seq_id
1298: , bcb.last_update_date = sysdate
1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1300: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1301: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1302: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1303: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1304: , bcb.program_update_date = sysdate
1305: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id

Line 1302: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')

1298: , bcb.last_update_date = sysdate
1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1300: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1301: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1302: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1303: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1304: , bcb.program_update_date = sysdate
1305: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1306: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id

Line 1303: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1300: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1301: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1302: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1303: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1304: , bcb.program_update_date = sysdate
1305: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1306: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id
1307: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id

Line 1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')

1332:
1333: UPDATE bom_components_b bcb
1334: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1335: , bcb.last_update_date = sysdate
1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1338: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1339: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1340: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

Line 1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')

1333: UPDATE bom_components_b bcb
1334: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1335: , bcb.last_update_date = sysdate
1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1338: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1339: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1340: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1341: , bcb.program_update_date = sysdate

Line 1338: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')

1334: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1335: , bcb.last_update_date = sysdate
1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1338: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1339: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1340: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1341: , bcb.program_update_date = sysdate
1342: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id

Line 1339: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')

1335: , bcb.last_update_date = sysdate
1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1338: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1339: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1340: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1341: , bcb.program_update_date = sysdate
1342: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1343: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id

Line 1340: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1338: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1339: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1340: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1341: , bcb.program_update_date = sysdate
1342: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1343: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id
1344: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id

Line 1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')

1371: LOOP
1372: UPDATE bom_components_b bcb
1373: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1374: , bcb.last_update_date = sysdate
1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1377: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1378: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1379: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

Line 1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')

1372: UPDATE bom_components_b bcb
1373: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1374: , bcb.last_update_date = sysdate
1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1377: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1378: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1379: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1380: , bcb.program_update_date = sysdate

Line 1377: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')

1373: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1374: , bcb.last_update_date = sysdate
1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1377: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1378: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1379: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1380: , bcb.program_update_date = sysdate
1381: WHERE bcb.old_component_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_old_comp_sequence_id

Line 1378: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')

1374: , bcb.last_update_date = sysdate
1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1377: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1378: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1379: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1380: , bcb.program_update_date = sysdate
1381: WHERE bcb.old_component_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_old_comp_sequence_id
1382: AND bcb.bill_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_bill_sequence_id

Line 1379: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1377: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1378: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1379: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1380: , bcb.program_update_date = sysdate
1381: WHERE bcb.old_component_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_old_comp_sequence_id
1382: AND bcb.bill_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_bill_sequence_id
1383: AND bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).common_component_sequence_id

Line 1610: l_update_all_jobs NUMBER := nvl(fnd_profile.value('ENG:UPDATE_UNRELEASED_WIP_JOBS'),2);

1606: l_bom_assembly_type NUMBER;
1607:
1608: l_old_disable_date date;
1609: -- Bug 5657390
1610: l_update_all_jobs NUMBER := nvl(fnd_profile.value('ENG:UPDATE_UNRELEASED_WIP_JOBS'),2);
1611:
1612: -- ERES change
1613: -- odab added columns change_id, organization_code
1614: -- , organization_name, concatenated_segments, description

Line 3291: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');

3287:
3288: -- ERES change begins
3289: -- First Get the parent event details (ECO Implementation)
3290: -- If the call fails or returns and error, the exception is not catched.
3291: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');
3292: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3293: THEN
3294: QA_EDR_STANDARD.GET_ERECORD_ID
3295: ( p_api_version => 1.0

Line 3794: eff_date := eff_date + nvl(FND_PROFILE.VALUE('ENG:ENG_RESCHEDULE_DAYS_BY'),0);

3790: --- 8 use_up =Exhaust WIP and Inventory
3791: if (inv_onhand(item.use_up_item_id, item.organization_id) <> 0) then
3792: /* Fix for bug 5962435 - Added nvl around the profile,
3793: otherwise eff_date becomes null when that profile value is left blank.*/
3794: eff_date := eff_date + nvl(FND_PROFILE.VALUE('ENG:ENG_RESCHEDULE_DAYS_BY'),0);
3795: end if;
3796: end if;
3797: /*** ***/
3798:

Line 3938: FROM fnd_profile_options opt,

3934:
3935: begin
3936: SELECT substrb(profile_option_value,1,1)
3937: INTO eco_rev_warning_flag
3938: FROM fnd_profile_options opt,
3939: fnd_application appl,
3940: fnd_profile_option_values val
3941: WHERE opt.application_id = val.application_id
3942: AND opt.profile_option_id = val.profile_option_id

Line 3940: fnd_profile_option_values val

3936: SELECT substrb(profile_option_value,1,1)
3937: INTO eco_rev_warning_flag
3938: FROM fnd_profile_options opt,
3939: fnd_application appl,
3940: fnd_profile_option_values val
3941: WHERE opt.application_id = val.application_id
3942: AND opt.profile_option_id = val.profile_option_id
3943: AND opt.application_id = appl.application_id
3944: AND appl.application_short_name = 'ENG'

Line 4626: FROM fnd_profile_options opt,

4622:
4623: begin
4624: SELECT substrb(profile_option_value,1,1)
4625: INTO eco_rev_warning_flag
4626: FROM fnd_profile_options opt,
4627: fnd_application appl,
4628: fnd_profile_option_values val
4629: WHERE opt.application_id = val.application_id
4630: AND opt.profile_option_id = val.profile_option_id

Line 4628: fnd_profile_option_values val

4624: SELECT substrb(profile_option_value,1,1)
4625: INTO eco_rev_warning_flag
4626: FROM fnd_profile_options opt,
4627: fnd_application appl,
4628: fnd_profile_option_values val
4629: WHERE opt.application_id = val.application_id
4630: AND opt.profile_option_id = val.profile_option_id
4631: AND opt.application_id = appl.application_id
4632: AND appl.application_short_name = 'ENG'

Line 7932: l_update_all_jobs := fnd_profile.value('ENG:UPDATE_UNRELEASED_WIP_JOBS');

7928: FROM DUAL;
7929: group_id1 := l_wip_group_id1; --- set out type value
7930:
7931: --bug 2327582
7932: l_update_all_jobs := fnd_profile.value('ENG:UPDATE_UNRELEASED_WIP_JOBS');
7933:
7934: l_wip_jsi_insert_flag := 0;
7935: IF NVL(l_wip_from_cum_qty, 0) > 0
7936: THEN