APPS.MSC_PLAN_RELEASE dependencies on FND_PROFILE

Line 182: -- nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');

178: x_return_status varchar2(1) := 'E';
179: tmpindex NUMBER := 0;
180: p_ret_msg varchar2(200) := null;
181: p_release_by_user varchar2(3):=null ;
182: -- nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
183:
184:
185: p_plan_id number := pid;
186: p_plan_org_id number;

Line 876: l_user_id number := nvl(FND_PROFILE.VALUE('USER_ID'),1);

872: l_pref_release_vmi varchar2(10);
873: l_include_so varchar2(10);
874: l_temp Number;
875:
876: l_user_id number := nvl(FND_PROFILE.VALUE('USER_ID'),1);
877: l_plan_type number :=1 ; -- temp set as ASCP plan
878:
879: CURSOR empl_C IS
880: SELECT mp.employee_id

Line 1002: p_rel_schd_OK := nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');

998:
999:
1000:
1001: if p_in_source_plan = 1 then
1002: p_rel_schd_OK := nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');
1003:
1004: if (p_rel_schd_OK = 'N') then
1005:
1006: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MSC_IN_SOURCE_PLAN');

Line 1020: if (nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y'

1016: -- child supply are on hand or make planned order
1017: */
1018:
1019: p_valid := null;
1020: if (nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y'
1021: and p_order_type = 5 and p_org_id = p_source_org_id) then
1022: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
1023: p_plan_id, p_transaction_id);
1024: if p_valid > 0 then

Line 1314: if fnd_profile.save_user(name,value) then

1310:
1311: Function save_user_profile(name in varchar2, value in varchar2) return number
1312: is
1313: begin
1314: if fnd_profile.save_user(name,value) then
1315: return 1;
1316: else
1317: return 2 ;
1318: end if;

Line 1327: l_prof_value := to_number(fnd_profile.value('MSC_PLANNER_PLATFORM'));

1323:
1324: procedure get_exec_name(MSO_INSTALLED in varchar2, BATCH_REPLAN in varchar2, p_exec_name out nocopy varchar2) IS
1325: l_prof_value number;
1326: begin
1327: l_prof_value := to_number(fnd_profile.value('MSC_PLANNER_PLATFORM'));
1328: if l_prof_value is null then
1329: -- profile value not defined -> use old executables
1330: if MSO_INSTALLED ='Y' and BATCH_REPLAN = 'Y' then
1331: p_exec_name := 'MSONCP';