APPS.MSC_REL_PS_PLAN_PUB dependencies on FND_PROFILE

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

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

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

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

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

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

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

801: * the profile option MSC_RETAIN_RELEASED_DATA is
802: * set to YES
803: */
804:
805: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
806: DELETE msc_wip_job_schedule_interface
807: WHERE sr_instance_id= arg_org_instance
808: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
809:

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

874: lv_inflate_wip NUMBER;
875:
876: BEGIN
877:
878: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
879: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
880: INTO lv_release_details,lv_inflate_wip
881: FROM dual;
882:

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

875:
876: BEGIN
877:
878: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
879: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
880: INTO lv_release_details,lv_inflate_wip
881: FROM dual;
882:
883:

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

2664: lv_round_primary_item NumTab;
2665:
2666: BEGIN
2667:
2668: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
2669: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
2670: INTO lv_release_details,lv_inflate_wip
2671: FROM dual;
2672:

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

2665:
2666: BEGIN
2667:
2668: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
2669: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
2670: INTO lv_release_details,lv_inflate_wip
2671: FROM dual;
2672:
2673: /* we release the discrete job, only if it doesn't use aggregate resources */