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.

[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on FND_PROFILE

Line 736: where request_id = fnd_profile.value('CONC_REQUEST_ID')

732: select fcp.concurrent_program_name
733: INTO l_concurrent_program_name
734: from fnd_concurrent_requests fcr
735: ,fnd_concurrent_programs fcp
736: where request_id = fnd_profile.value('CONC_REQUEST_ID')
737: AND fcr.concurrent_program_id = fcp.concurrent_program_id;
738:
739: IF(l_concurrent_program_name = 'MSCAPO') THEN
740: -- arg_mode := NULL;

Line 753: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)

749:
750: END;
751:
752: SELECT
753: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
754: INTO v_msc_released_only_by_user
755: FROM DUAL;
756: v_batch_id_populated := 1;
757: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN

Line 1168: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)

1164: BEGIN
1165:
1166:
1167: SELECT
1168: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
1169: INTO v_msc_released_only_by_user
1170: FROM DUAL;
1171: v_batch_id_populated := 1;
1172: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN

Line 1596: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink

1592: end if;
1593:
1594: lv_sql_stmt:=
1595: 'BEGIN'
1596: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink
1597: ||'(''BOM:HOUR_UOM_CODE'');'
1598: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink
1599: ||'(''MRP_PURCHASING_BY_REVISION'');'
1600: ||'END;';

Line 1598: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink

1594: lv_sql_stmt:=
1595: 'BEGIN'
1596: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink
1597: ||'(''BOM:HOUR_UOM_CODE'');'
1598: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink
1599: ||'(''MRP_PURCHASING_BY_REVISION'');'
1600: ||'END;';
1601:
1602: EXECUTE IMMEDIATE lv_sql_stmt

Line 2027: SELECT DECODE(NVL(fnd_profile.value('MSC_PO_DEFAULT_TIME_STAMP') ,'1'), '1','N', 'Y')

2023: END IF;
2024: END IF;
2025: -- Timestamp for RP Release
2026: v_rp_time := 86399/86400;
2027: SELECT DECODE(NVL(fnd_profile.value('MSC_PO_DEFAULT_TIME_STAMP') ,'1'), '1','N', 'Y')
2028: INTO l_timestamp_profile_val
2029: FROM DUAL;
2030:
2031: select decode((mp.daily_material_constraints+ mp.daily_resource_constraints+

Line 2409: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN

2405: USING OUT arg_eam_req_id;
2406:
2407: END IF; */
2408:
2409: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2410: DELETE msc_wip_job_schedule_interface
2411: WHERE sr_instance_id= arg_org_instance;
2412:
2413: DELETE MSC_WIP_JOB_DTLS_INTERFACE

Line 2448: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN

2444:
2445: EXECUTE IMMEDIATE lv_sql_stmt
2446: USING IN po_group_by_name,
2447: OUT arg_req_load_id;
2448: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2449: DELETE MSC_PO_REQUISITIONS_INTERFACE
2450: WHERE sr_instance_id= arg_org_instance;
2451: END IF;
2452: END;

Line 2480: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN

2476:
2477: EXECUTE IMMEDIATE lv_sql_stmt
2478: USING OUT arg_req_resched_id;
2479:
2480: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2481: DELETE MSC_PO_RESCHEDULE_INTERFACE
2482: WHERE sr_instance_id= arg_org_instance;
2483: END IF;
2484: */

Line 2488: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN

2484: */
2485: END IF;
2486:
2487: ELSIF v_curr_instance_type in (G_INS_OTHER, G_INS_EXCHANGE) THEN
2488: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2489: lv_sql_stmt :=
2490: ' BEGIN'
2491: ||' MSC_A2A_XML_WF.LEGACY_RELEASE (:p_arg_org_instance);'
2492: ||' END;';

Line 2662: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN

2658: WHERE batch_id = g_batch_id
2659: and sr_instance_id = arg_org_instance;
2660: END IF; -- lv_wf
2661:
2662: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2663: DELETE msc_wip_job_schedule_interface
2664: WHERE sr_instance_id= arg_org_instance
2665: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2666:

Line 4308: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),

4304:
4305:
4306: BEGIN
4307:
4308: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
4309: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
4310: INTO lv_release_details,lv_inflate_wip
4311: FROM dual;
4312:

Line 4309: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)

4305:
4306: BEGIN
4307:
4308: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
4309: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
4310: INTO lv_release_details,lv_inflate_wip
4311: FROM dual;
4312:
4313:

Line 6317: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),

6313: l_plan_type number := 0;
6314:
6315: BEGIN
6316:
6317: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
6318: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
6319: INTO lv_release_details,lv_inflate_wip
6320: FROM dual;
6321:

Line 6318: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)

6314:
6315: BEGIN
6316:
6317: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
6318: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
6319: INTO lv_release_details,lv_inflate_wip
6320: FROM dual;
6321:
6322: /* we release the discrete job, only if it doesn't use aggregate resources */

Line 7977: DECODE(NVL(fnd_profile.value('MSC_EXPLODE_IN_WIP') ,'Y'), 'Y',1 ,2)

7973: BEGIN
7974:
7975: -- Bug 10399650
7976: SELECT
7977: DECODE(NVL(fnd_profile.value('MSC_EXPLODE_IN_WIP') ,'Y'), 'Y',1 ,2)
7978: INTO lv_explode_in_wip
7979: FROM DUAL;
7980: -- we release the discrete job, only if it doesn't use aggregate resources
7981: -- bug 1252659 fix, replace rowid by