APPS.MSC_REL_PLAN_PUB dependencies on FND_PROFILE

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

595: BEGIN
596:
597:
598: SELECT
599: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
600: INTO v_msc_released_only_by_user
601: FROM DUAL;
602: v_batch_id_populated := 1;
603: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN

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

967: BEGIN
968:
969:
970: SELECT
971: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
972: INTO v_msc_released_only_by_user
973: FROM DUAL;
974: v_batch_id_populated := 1;
975: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN

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

1306: -- Get the profile MRP_PURCHASING_BY_REVISION is set
1307:
1308: lv_sql_stmt:=
1309: 'BEGIN'
1310: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink
1311: ||'(''BOM:HOUR_UOM_CODE'');'
1312: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink
1313: ||'(''MRP_PURCHASING_BY_REVISION'');'
1314: ||'END;';

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

1308: lv_sql_stmt:=
1309: 'BEGIN'
1310: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink
1311: ||'(''BOM:HOUR_UOM_CODE'');'
1312: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink
1313: ||'(''MRP_PURCHASING_BY_REVISION'');'
1314: ||'END;';
1315:
1316: EXECUTE IMMEDIATE lv_sql_stmt

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

3762:
3763:
3764: BEGIN
3765:
3766: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
3767: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
3768: INTO lv_release_details,lv_inflate_wip
3769: FROM dual;
3770:

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

3763:
3764: BEGIN
3765:
3766: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
3767: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
3768: INTO lv_release_details,lv_inflate_wip
3769: FROM dual;
3770:
3771:

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

5744: l_plan_type number := 0;
5745:
5746: BEGIN
5747:
5748: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
5749: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
5750: INTO lv_release_details,lv_inflate_wip
5751: FROM dual;
5752:

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

5745:
5746: BEGIN
5747:
5748: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
5749: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
5750: INTO lv_release_details,lv_inflate_wip
5751: FROM dual;
5752:
5753: /* we release the discrete job, only if it doesn't use aggregate resources */