APPS.MSC_REL_WF dependencies on FND_PROFILE

Line 386: l_planner varchar2(40) := FND_PROFILE.VALUE('USERNAME');

382: l_order_type varchar2(80);
383: l_old_date date;
384: l_new_date date;
385: l_qty number;
386: l_planner varchar2(40) := FND_PROFILE.VALUE('USERNAME');
387: l_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
388: TYPE PoCurTyp IS REF CURSOR;
389: poCur PoCurTyp;
390:

Line 745: p_user_id number := FND_PROFILE.value('USER_ID');

741: , arg_po_res_id IN OUT NOCOPY NumTblTyp
742: , arg_po_res_count IN OUT NOCOPY NumTblTyp
743: , arg_po_pwb_count IN OUT NOCOPY NumTblTyp) IS
744:
745: p_user_id number := FND_PROFILE.value('USER_ID');
746: p_release_by_user varchar2(3) :=
747: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
748:
749: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

743: , arg_po_pwb_count IN OUT NOCOPY NumTblTyp) IS
744:
745: p_user_id number := FND_PROFILE.value('USER_ID');
746: p_release_by_user varchar2(3) :=
747: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
748:
749: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
750: TYPE DateTab IS TABLE OF Date INDEX BY BINARY_INTEGER;
751: TYPE CharTab IS TABLE OF varchar2(240) INDEX BY BINARY_INTEGER;

Line 792: p_user_name varchar2(100); -- :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');

788: where plan_id = arg_plan_id
789: and mp.sr_instance_id = mai.instance_id
790: and mai.instance_type = 3; -- xml fix
791:
792: p_user_name varchar2(100); -- :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');
793: p_resp_name varchar2(80); -- :=FND_GLOBAL.RESP_NAME;
794: p_dblink varchar2(128);
795: p_instance_id number;
796: p_instance_code varchar2(3);

Line 1340: -- p_user_id number := FND_PROFILE.value('USER_ID');

1336: , arg_so_rel_id IN OUT NOCOPY NumTblTyp
1337: , arg_so_rel_count IN OUT NOCOPY NumTblTyp
1338: , arg_so_pwb_count IN OUT NOCOPY NumTblTyp) IS
1339:
1340: -- p_user_id number := FND_PROFILE.value('USER_ID');
1341: p_user_id number := FND_GLOBAL.USER_ID;
1342: p_resp_id number := FND_GLOBAL.RESP_ID;
1343: p_release_by_user varchar2(3) :=
1344: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');

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

1340: -- p_user_id number := FND_PROFILE.value('USER_ID');
1341: p_user_id number := FND_GLOBAL.USER_ID;
1342: p_resp_id number := FND_GLOBAL.RESP_ID;
1343: p_release_by_user varchar2(3) :=
1344: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
1345:
1346: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1347: TYPE DateTab IS TABLE OF Date INDEX BY BINARY_INTEGER;
1348: TYPE CharTab IS TABLE OF varchar2(240) INDEX BY BINARY_INTEGER;

Line 1387: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');

1383: and mp.sr_instance_id = mai.instance_id
1384: -- and mai.instance_type <> 3 -- xml fix
1385: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
1386:
1387: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1388: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;
1389: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
1390: p_dblink varchar2(128);
1391: p_aps_dblink varchar2(128);

Line 1848: --l_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');

1844: p_error OUT NOCOPY VARCHAR2) IS
1845:
1846:
1847:
1848: --l_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1849: l_user_name varchar2(30) := FND_GLOBAL.USER_NAME;
1850:
1851:
1852: CURSOR db_cur IS