APPS.MSC_RELEASE_PK dependencies on FND_PROFILE

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

168:
169: -- for 3298070
170: lv_plan_name VARCHAR2(100):=NULL;
171:
172: v_comp_days_tol number := NVL(FND_PROFILE.VALUE('MSC_AUTO_REL_COMP_TOLERANCE'),0);
173:
174: v_wip_group_id NUMBER;
175: v_po_batch_number NUMBER;
176:

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

509: BEGIN
510: retcode := 0;
511: errbuf := NULL;
512:
513: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
514: into lv_plan_release_profile
515: from dual;
516:
517: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

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

513: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
514: into lv_plan_release_profile
515: from dual;
516:
517: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
518:
519: SELECT ALLOW_RELEASE_FLAG,
520: INSTANCE_CODE,
521: APPS_VER,

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

615:
616:
617: var_sql_stmt:=
618: 'SELECT FND_GLOBAL.USER_ID,'
619: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
620: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
621: ||' FROM DUAL';
622:
623: EXECUTE IMMEDIATE var_sql_stmt INTO var_user_id,

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

616:
617: var_sql_stmt:=
618: 'SELECT FND_GLOBAL.USER_ID,'
619: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
620: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
621: ||' FROM DUAL';
622:
623: EXECUTE IMMEDIATE var_sql_stmt INTO var_user_id,
624: var_default_job_prefix,