APPS.MSC_REL_PS_PLAN_PUB dependencies on FND_PROFILE

Line 91: user_id:=FND_PROFILE.VALUE('USER_ID');

87:
88:
89:
90: MSC_REL_WF.INIT_DB(p_user_id);
91: user_id:=FND_PROFILE.VALUE('USER_ID');
92: /*dbms_output.put_line('USER_ID '|| p_user_id);*/
93:
94:
95:

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

481: -- Get the profile MRP_PURCHASING_BY_REVISION is set
482:
483: lv_sql_stmt:=
484: 'BEGIN'
485: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink
486: ||'(''BOM:HOUR_UOM_CODE'');'
487: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink
488: ||'(''MRP_PURCHASING_BY_REVISION'');'
489: ||'END;';

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

483: lv_sql_stmt:=
484: 'BEGIN'
485: ||' :v_hour_uom := FND_PROFILE.VALUE'||arg_dblink
486: ||'(''BOM:HOUR_UOM_CODE'');'
487: ||' :v_purchasing_by_rev := FND_PROFILE.VALUE'||arg_dblink
488: ||'(''MRP_PURCHASING_BY_REVISION'');'
489: ||'END;';
490:
491: EXECUTE IMMEDIATE lv_sql_stmt

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

848: lv_inflate_wip NUMBER;
849:
850: BEGIN
851:
852: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
853: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
854: INTO lv_release_details,lv_inflate_wip
855: FROM dual;
856:

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

849:
850: BEGIN
851:
852: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
853: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
854: INTO lv_release_details,lv_inflate_wip
855: FROM dual;
856:
857:

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

2637: lv_round_primary_item NumTab;
2638:
2639: BEGIN
2640:
2641: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
2642: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
2643: INTO lv_release_details,lv_inflate_wip
2644: FROM dual;
2645:

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

2638:
2639: BEGIN
2640:
2641: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
2642: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
2643: INTO lv_release_details,lv_inflate_wip
2644: FROM dual;
2645:
2646: /* we release the discrete job, only if it doesn't use aggregate resources */