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 1371: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')

1367: UPDATE bom_components_b bcb
1368: SET bcb.old_component_sequence_id = c_dest_comp_rec.component_sequence_id
1369: , bcb.common_component_sequence_id = p_src_comp_seq_id
1370: , bcb.last_update_date = sysdate
1371: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1372: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1373: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1374: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1375: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

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

1368: SET bcb.old_component_sequence_id = c_dest_comp_rec.component_sequence_id
1369: , bcb.common_component_sequence_id = p_src_comp_seq_id
1370: , bcb.last_update_date = sysdate
1371: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1372: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1373: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1374: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1375: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1376: , bcb.program_update_date = sysdate

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

1369: , bcb.common_component_sequence_id = p_src_comp_seq_id
1370: , bcb.last_update_date = sysdate
1371: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1372: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1373: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1374: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1375: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1376: , bcb.program_update_date = sysdate
1377: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id

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

1370: , bcb.last_update_date = sysdate
1371: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1372: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1373: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1374: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1375: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1376: , bcb.program_update_date = sysdate
1377: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1378: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id

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

1371: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1372: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1373: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1374: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1375: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1376: , bcb.program_update_date = sysdate
1377: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1378: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id
1379: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id

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

1404:
1405: UPDATE bom_components_b bcb
1406: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1407: , bcb.last_update_date = sysdate
1408: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1409: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1410: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1411: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1412: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

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

1405: UPDATE bom_components_b bcb
1406: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1407: , bcb.last_update_date = sysdate
1408: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1409: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1410: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1411: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1412: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1413: , bcb.program_update_date = sysdate

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

1406: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1407: , bcb.last_update_date = sysdate
1408: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1409: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1410: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1411: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1412: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1413: , bcb.program_update_date = sysdate
1414: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id

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

1407: , bcb.last_update_date = sysdate
1408: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1409: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1410: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1411: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1412: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1413: , bcb.program_update_date = sysdate
1414: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1415: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id

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

1408: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1409: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1410: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1411: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1412: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1413: , bcb.program_update_date = sysdate
1414: WHERE bcb.old_component_sequence_id = c_dest_comp_rec.old_component_sequence_id
1415: AND bcb.bill_sequence_id = c_dest_comp_rec.bill_sequence_id
1416: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id

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

1443: LOOP
1444: UPDATE bom_components_b bcb
1445: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1446: , bcb.last_update_date = sysdate
1447: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1448: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1449: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1450: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1451: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')

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

1444: UPDATE bom_components_b bcb
1445: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1446: , bcb.last_update_date = sysdate
1447: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1448: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1449: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1450: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1451: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1452: , bcb.program_update_date = sysdate

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

1445: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1446: , bcb.last_update_date = sysdate
1447: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1448: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1449: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1450: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1451: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1452: , bcb.program_update_date = sysdate
1453: WHERE bcb.old_component_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_old_comp_sequence_id

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

1446: , bcb.last_update_date = sysdate
1447: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1448: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1449: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1450: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1451: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1452: , bcb.program_update_date = sysdate
1453: WHERE bcb.old_component_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_old_comp_sequence_id
1454: AND bcb.bill_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_bill_sequence_id

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

1447: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1448: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')
1449: , bcb.request_id = FND_PROFILE.value('REQUEST_ID')
1450: , bcb.program_application_id = FND_PROFILE.value('RESP_APPL_ID')
1451: , bcb.program_id = FND_PROFILE.value('PROGRAM_ID')
1452: , bcb.program_update_date = sysdate
1453: WHERE bcb.old_component_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_old_comp_sequence_id
1454: AND bcb.bill_sequence_id = g_Common_Rev_Comp_Tbl(i).dest_bill_sequence_id
1455: AND bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).common_component_sequence_id

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

1683: l_bom_assembly_type NUMBER;
1684:
1685: l_old_disable_date date;
1686: -- Bug 5657390
1687: l_update_all_jobs NUMBER := nvl(fnd_profile.value('ENG:UPDATE_UNRELEASED_WIP_JOBS'),2);
1688:
1689: -- ERES change
1690: -- odab added columns change_id, organization_code
1691: -- , organization_name, concatenated_segments, description

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

3531:
3532: -- ERES change begins
3533: -- First Get the parent event details (ECO Implementation)
3534: -- If the call fails or returns and error, the exception is not catched.
3535: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');
3536: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3537: THEN
3538: QA_EDR_STANDARD.GET_ERECORD_ID
3539: ( p_api_version => 1.0

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

4034: --- 8 use_up =Exhaust WIP and Inventory
4035: if (inv_onhand(item.use_up_item_id, item.organization_id) <> 0) then
4036: /* Fix for bug 5962435 - Added nvl around the profile,
4037: otherwise eff_date becomes null when that profile value is left blank.*/
4038: eff_date := eff_date + nvl(FND_PROFILE.VALUE('ENG:ENG_RESCHEDULE_DAYS_BY'),0);
4039: end if;
4040: end if;
4041: /*** ***/
4042:

Line 4182: FROM fnd_profile_options opt,

4178:
4179: begin
4180: SELECT substrb(profile_option_value,1,1)
4181: INTO eco_rev_warning_flag
4182: FROM fnd_profile_options opt,
4183: fnd_application appl,
4184: fnd_profile_option_values val
4185: WHERE opt.application_id = val.application_id
4186: AND opt.profile_option_id = val.profile_option_id

Line 4184: fnd_profile_option_values val

4180: SELECT substrb(profile_option_value,1,1)
4181: INTO eco_rev_warning_flag
4182: FROM fnd_profile_options opt,
4183: fnd_application appl,
4184: fnd_profile_option_values val
4185: WHERE opt.application_id = val.application_id
4186: AND opt.profile_option_id = val.profile_option_id
4187: AND opt.application_id = appl.application_id
4188: AND appl.application_short_name = 'ENG'

Line 4884: FROM fnd_profile_options opt,

4880:
4881: begin
4882: SELECT substrb(profile_option_value,1,1)
4883: INTO eco_rev_warning_flag
4884: FROM fnd_profile_options opt,
4885: fnd_application appl,
4886: fnd_profile_option_values val
4887: WHERE opt.application_id = val.application_id
4888: AND opt.profile_option_id = val.profile_option_id

Line 4886: fnd_profile_option_values val

4882: SELECT substrb(profile_option_value,1,1)
4883: INTO eco_rev_warning_flag
4884: FROM fnd_profile_options opt,
4885: fnd_application appl,
4886: fnd_profile_option_values val
4887: WHERE opt.application_id = val.application_id
4888: AND opt.profile_option_id = val.profile_option_id
4889: AND opt.application_id = appl.application_id
4890: AND appl.application_short_name = 'ENG'

Line 6064: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1

6060:
6061: --BOM ER 9946990 begin
6062: if item.bom_item_type = 4 and item.pick_components_flag = 'Y'
6063: and component.bom_item_type = 4 and component.replenish_to_order_flag = 'Y'
6064: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
6065: then
6066: If msg_qty < max_messages then
6067: msg_qty := msg_qty + 1;
6068: message_names(msg_qty) := 'BOM_KIT_COMP_PRF_NOT_SET';

Line 6085: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1

6081:
6082: if item.bom_item_type = 1 and item.pick_components_flag = 'Y'
6083: and component.bom_item_type = 4 and component.replenish_to_order_flag = 'Y'
6084: and nvl(component.optional, 1) = 2
6085: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
6086: then
6087: If msg_qty < max_messages then
6088: msg_qty := msg_qty + 1;
6089: message_names(msg_qty) := 'BOM_MODEL_COMP_PRF_NOT_SET';

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

8269: FROM DUAL;
8270: group_id1 := l_wip_group_id1; --- set out type value
8271:
8272: --bug 2327582
8273: l_update_all_jobs := fnd_profile.value('ENG:UPDATE_UNRELEASED_WIP_JOBS');
8274:
8275: l_wip_jsi_insert_flag := 0;
8276: IF NVL(l_wip_from_cum_qty, 0) > 0
8277: THEN