APPS.MSC_RELEASE_PK dependencies on FND_PROFILE

Line 187: v_comp_days_tol number := NVL(FND_PROFILE.VALUE('MSC_AUTO_REL_COMP_TOLERANCE'),0);

183:
184: -- for 3298070
185: lv_plan_name VARCHAR2(100):=NULL;
186:
187: v_comp_days_tol number := NVL(FND_PROFILE.VALUE('MSC_AUTO_REL_COMP_TOLERANCE'),0);
188:
189: v_wip_group_id NUMBER;
190: v_po_batch_number NUMBER;
191: v_rp_plan NUMBER :=0; -- Check if plan is an RP plan

Line 633: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)

629: lv_arg_instance_id_new
630: from msc_plans
631: where plan_id = arg_plan_id ;
632:
633: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
634: into lv_plan_release_profile
635: from dual;
636:
637: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

Line 637: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

633: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
634: into lv_plan_release_profile
635: from dual;
636:
637: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
638:
639: SELECT ALLOW_RELEASE_FLAG,
640: INSTANCE_CODE,
641: APPS_VER,

Line 766: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'

762:
763:
764: var_sql_stmt:=
765: 'SELECT FND_GLOBAL.USER_ID,'
766: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
767: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
768: ||' FROM DUAL';
769:
770: EXECUTE IMMEDIATE var_sql_stmt INTO var_user_id,

Line 767: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'

763:
764: var_sql_stmt:=
765: 'SELECT FND_GLOBAL.USER_ID,'
766: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
767: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
768: ||' FROM DUAL';
769:
770: EXECUTE IMMEDIATE var_sql_stmt INTO var_user_id,
771: var_default_job_prefix,