DBA Data[Home] [Help]

APPS.MSC_RESOURCE_AVAILABILITY dependencies on FND_PROFILE

Line 1927: lv_mrp_cutoff_date_offset:= TO_NUMBER(FND_PROFILE.VAlUE('MRP_CUTOFF_DATE_OFFSET'));

1923: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1924: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CALC_RESOURCE_AVAILABILITY');
1925: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1926:
1927: lv_mrp_cutoff_date_offset:= TO_NUMBER(FND_PROFILE.VAlUE('MRP_CUTOFF_DATE_OFFSET'));
1928: lv_res_avail_before_sysdate := nvl(TO_NUMBER(FND_PROFILE.VAlUE('MSC_RES_AVAIL_BEFORE_SYSDAT')),1);
1929:
1930: IF pSTANDALONE THEN
1931: lv_task_end_time := ADD_MONTHS(lv_task_start_time,lv_mrp_cutoff_date_offset);

Line 1928: lv_res_avail_before_sysdate := nvl(TO_NUMBER(FND_PROFILE.VAlUE('MSC_RES_AVAIL_BEFORE_SYSDAT')),1);

1924: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CALC_RESOURCE_AVAILABILITY');
1925: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1926:
1927: lv_mrp_cutoff_date_offset:= TO_NUMBER(FND_PROFILE.VAlUE('MRP_CUTOFF_DATE_OFFSET'));
1928: lv_res_avail_before_sysdate := nvl(TO_NUMBER(FND_PROFILE.VAlUE('MSC_RES_AVAIL_BEFORE_SYSDAT')),1);
1929:
1930: IF pSTANDALONE THEN
1931: lv_task_end_time := ADD_MONTHS(lv_task_start_time,lv_mrp_cutoff_date_offset);
1932: ELSE

Line 2734: lv_plan_name := fnd_profile.VALUE ('AHL_MSC_RES_CPCTY_PLAN');

2730:
2731: v_current_date := SYSDATE;
2732: v_current_user := FND_GLOBAL.USER_ID;
2733: v_current_login := FND_GLOBAL.LOGIN_ID;
2734: lv_plan_name := fnd_profile.VALUE ('AHL_MSC_RES_CPCTY_PLAN');
2735: LV_SOURCE_APPLICATION := 'MSC';
2736: lv_ahl_schema := MSC_UTIL.GET_SCHEMA_NAME(867);
2737:
2738: SAVEPOINT AHL;