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 726: p_user_id number := FND_PROFILE.value('USER_ID');

722: , arg_po_res_id IN OUT NOCOPY NumTblTyp
723: , arg_po_res_count IN OUT NOCOPY NumTblTyp
724: , arg_po_pwb_count IN OUT NOCOPY NumTblTyp) IS
725:
726: p_user_id number := FND_PROFILE.value('USER_ID');
727: p_release_by_user varchar2(3) :=
728: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
729:
730: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

724: , arg_po_pwb_count IN OUT NOCOPY NumTblTyp) IS
725:
726: p_user_id number := FND_PROFILE.value('USER_ID');
727: p_release_by_user varchar2(3) :=
728: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
729:
730: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
731: TYPE DateTab IS TABLE OF Date INDEX BY BINARY_INTEGER;
732: TYPE CharTab IS TABLE OF varchar2(240) INDEX BY BINARY_INTEGER;

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

768: where plan_id = arg_plan_id
769: and mp.sr_instance_id = mai.instance_id
770: and mai.instance_type = 3; -- xml fix
771:
772: p_user_name varchar2(30) :=FND_GLOBAL.USER_NAME; --FND_PROFILE.VALUE('USERNAME');
773: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
774: p_dblink varchar2(128);
775: p_instance_id number;
776: p_instance_code varchar2(3);

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

1184: , arg_so_rel_id IN OUT NOCOPY NumTblTyp
1185: , arg_so_rel_count IN OUT NOCOPY NumTblTyp
1186: , arg_so_pwb_count IN OUT NOCOPY NumTblTyp) IS
1187:
1188: -- p_user_id number := FND_PROFILE.value('USER_ID');
1189: p_user_id number := FND_GLOBAL.USER_ID;
1190: p_resp_id number := FND_GLOBAL.RESP_ID;
1191: p_release_by_user varchar2(3) :=
1192: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');

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

1188: -- p_user_id number := FND_PROFILE.value('USER_ID');
1189: p_user_id number := FND_GLOBAL.USER_ID;
1190: p_resp_id number := FND_GLOBAL.RESP_ID;
1191: p_release_by_user varchar2(3) :=
1192: nvl(FND_PROFILE.value('MSC_RELEASED_BY_USER_ONLY'),'N');
1193:
1194: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1195: TYPE DateTab IS TABLE OF Date INDEX BY BINARY_INTEGER;
1196: TYPE CharTab IS TABLE OF varchar2(240) INDEX BY BINARY_INTEGER;

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

1231: and mp.sr_instance_id = mai.instance_id
1232: -- and mai.instance_type <> 3 -- xml fix
1233: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
1234:
1235: -- p_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1236: p_user_name varchar2(80) :=FND_GLOBAL.USER_NAME;
1237: p_resp_name varchar2(80) :=FND_GLOBAL.RESP_NAME;
1238: p_dblink varchar2(128);
1239: p_aps_dblink varchar2(128);

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

1609: p_error OUT NOCOPY VARCHAR2) IS
1610:
1611:
1612:
1613: --l_user_name varchar2(30) :=FND_PROFILE.VALUE('USERNAME');
1614: l_user_name varchar2(30) := FND_GLOBAL.USER_NAME;
1615:
1616:
1617: CURSOR db_cur IS