APPS.CSM_MULTI_MOBQRY_PKG dependencies on ASG_USER

Line 146: from asg_user where user_name=p_user_name;

142: END IF;
143:
144: select user_id,responsibility_id,app_id
145: into l_user_id ,l_resp_id ,l_app_id
146: from asg_user where user_name=p_user_name;
147:
148: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE='''||fnd_profile.value_specific('ICX_LANGUAGE',l_user_id ,l_resp_id ,l_app_id)||'''';
149:
150: l_result:=l_result||'';

Line 228: from asg_user where user_name=p_user_name;

224: END IF;
225:
226: select user_id,responsibility_id,app_id
227: into l_user_id ,l_resp_id ,l_app_id
228: from asg_user where user_name=p_user_name;
229:
230: SELECT max(hrl.location_id) INTO l_hr_loc_id
231: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas
232: WHERE hrl.org_id=cas.org_id and hrl.address_id=cas.cust_acct_site_id

Line 300: asg_user au

296: csp_receiving_lines_v line,
297: jtf_tasks_b task,
298: MTL_UNITS_OF_MEASURE_TL mt,
299: fnd_lookup_values fl,
300: asg_user au
301: where line.header_id = hdr.header_id
302: and hdr.task_number=task.task_number
303: and au.user_name=p_user_name
304: and hdr.resource_id=au.resource_id

Line 518: FROM asg_user WHERE user_name=p_user_name;

514:
515:
516: SELECT user_id,responsibility_id, app_id
517: INTO l_user_id,l_resp_id,l_app_id
518: FROM asg_user WHERE user_name=p_user_name;
519:
520: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
521:
522: FOR I IN 1..l_rld_tab.COUNT

Line 783: FROM asg_user WHERE user_name=p_user_name;

779:
780:
781: SELECT user_id,responsibility_id, app_id
782: INTO l_user_id,l_resp_id,l_app_id
783: FROM asg_user WHERE user_name=p_user_name;
784:
785: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
786:
787: FOR I IN 1..l_rld_tab.COUNT

Line 1024: FROM asg_user WHERE user_name=p_user_name;

1020:
1021:
1022: SELECT user_id,responsibility_id, app_id ,org_id
1023: INTO l_user_id,l_resp_id,l_app_id,l_org_id
1024: FROM asg_user WHERE user_name=p_user_name;
1025:
1026: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1027: MO_GLOBAL.INIT ('CSM');
1028:

Line 1084: FROM asg_user WHERE user_name=p_user_name;

1080:
1081:
1082: SELECT user_id,responsibility_id, app_id ,org_id
1083: INTO l_user_id,l_resp_id,l_app_id,l_org_id
1084: FROM asg_user WHERE user_name=p_user_name;
1085:
1086: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1087: MO_GLOBAL.INIT ('CSM');
1088:

Line 1137: FROM asg_user WHERE user_name=p_user_name;

1133:
1134: begin
1135: SELECT user_id,responsibility_id, app_id
1136: INTO l_user_id,l_resp_id,l_app_id
1137: FROM asg_user WHERE user_name=p_user_name;
1138:
1139: OPEN c_get_hr_loc_id(l_user_id,p_party_site_id);
1140: FETCH c_get_hr_loc_id INTO x_loc_id;
1141: CLOSE c_get_hr_loc_id;

Line 1221: FROM asg_user WHERE user_name=p_user_name;

1217: BEGIN
1218:
1219: SELECT user_id,responsibility_id, app_id ,org_id,resource_id
1220: INTO l_user_id,l_resp_id,l_app_id,l_org_id,l_rs_id
1221: FROM asg_user WHERE user_name=p_user_name;
1222:
1223: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1224: --mo_global.set_policy_context('S',l_org_id); also done by CSP api ..so leave it to them
1225: MO_GLOBAL.INIT ('CSM');

Line 1918: FROM asg_user

1914: CLOSE c_get_ovn;
1915:
1916: SELECT user_id,responsibility_id, app_id
1917: INTO l_user_id,l_resp_id,l_app_id
1918: FROM asg_user
1919: WHERE user_name=p_user_name ;
1920:
1921: OPEN c_audit;
1922: FETCH c_audit INTO l_old_taa;