DBA Data[Home] [Help]

APPS.IGP_VW_GEN_002_PKG dependencies on FND_USER

Line 30: -- Purpose : Get individual FND users holding Career Center Resp from the DB.

26: ) AS
27:
28: /*--------------------------------------------------------------------------
29: -- Created by : ssawhney
30: -- Purpose : Get individual FND users holding Career Center Resp from the DB.
31: -- Form an Adhoc Role and Add each fnd user as a Role User.
32: --
33: -- History
34: ---------------------------------------------------------------------------*/

Line 31: -- Form an Adhoc Role and Add each fnd user as a Role User.

27:
28: /*--------------------------------------------------------------------------
29: -- Created by : ssawhney
30: -- Purpose : Get individual FND users holding Career Center Resp from the DB.
31: -- Form an Adhoc Role and Add each fnd user as a Role User.
32: --
33: -- History
34: ---------------------------------------------------------------------------*/
35:

Line 39: SELECT fnd.user_name

35:
36: l_error_message VARCHAR2(500);
37:
38: CURSOR c_career_center(cp_app_id IN NUMBER,cp_resp_key IN VARCHAR) IS
39: SELECT fnd.user_name
40: FROM fnd_user fnd, fnd_responsibility_vl resp , fnd_user_resp_groups_direct rg
41: WHERE rg.user_id = fnd.user_id AND
42: rg.responsibility_id = resp.responsibility_id AND
43: rg.responsibility_application_id = cp_app_id AND

Line 40: FROM fnd_user fnd, fnd_responsibility_vl resp , fnd_user_resp_groups_direct rg

36: l_error_message VARCHAR2(500);
37:
38: CURSOR c_career_center(cp_app_id IN NUMBER,cp_resp_key IN VARCHAR) IS
39: SELECT fnd.user_name
40: FROM fnd_user fnd, fnd_responsibility_vl resp , fnd_user_resp_groups_direct rg
41: WHERE rg.user_id = fnd.user_id AND
42: rg.responsibility_id = resp.responsibility_id AND
43: rg.responsibility_application_id = cp_app_id AND
44: resp.responsibility_key = cp_resp_key ;

Line 41: WHERE rg.user_id = fnd.user_id AND

37:
38: CURSOR c_career_center(cp_app_id IN NUMBER,cp_resp_key IN VARCHAR) IS
39: SELECT fnd.user_name
40: FROM fnd_user fnd, fnd_responsibility_vl resp , fnd_user_resp_groups_direct rg
41: WHERE rg.user_id = fnd.user_id AND
42: rg.responsibility_id = resp.responsibility_id AND
43: rg.responsibility_application_id = cp_app_id AND
44: resp.responsibility_key = cp_resp_key ;
45:

Line 58: -- create adhoc role which will have all the fnd_users who have been assigned career center resp.

54: fnd_message.set_name('IGS','IGP_VW_CC_TITLE'); -- Fetch the display name 'Career Administrator' from this message.
55: l_role_display_name := fnd_message.get;
56: l_role_name := 'IGPVW1VW'||itemkey;
57:
58: -- create adhoc role which will have all the fnd_users who have been assigned career center resp.
59: -- so loop through the data and keep on adding them..
60:
61: Wf_Directory.CreateAdHocRole (
62: role_name => l_role_name,

Line 67: -- get fnd user name, the Adhoc Role will send mail to FND USER.

63: role_display_name => l_role_display_name );
64:
65: FOR rec_career_center IN c_career_center(8405,'IGP_CAREER_CENTRE')
66: LOOP
67: -- get fnd user name, the Adhoc Role will send mail to FND USER.
68: Wf_Directory.AddUsersToAdHocRole (
69: role_name => l_role_name,
70: role_users => rec_career_center.user_name );
71: END LOOP;

Line 324: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac

320: l_error_message VARCHAR2(500);
321:
322: CURSOR c_viewer_info(cp_viewer_id IN NUMBER) IS
323: SELECT (hz.person_last_name||','||hz.person_first_name) VIEWER , us.user_name
324: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac
325: WHERE ac.party_id = hz.party_id AND
326: us.user_id=ac.user_id AND
327: hz.party_id = cp_viewer_id;
328:

Line 333: FROM hz_parties hz,fnd_user fu

329: -- Get the details of CC name.
330: CURSOR c_get_CC_name(cp_CC_user_name VARCHAR2)
331: IS
332: SELECT (hz.person_last_name||','||hz.person_first_name) CC_NAME
333: FROM hz_parties hz,fnd_user fu
334: WHERE fu.person_party_id=hz.party_id
335: AND fu.user_name = cp_CC_user_name;
336:
337: rec_viewer_info c_viewer_info%ROWTYPE;

Line 439: SELECT port.portfolio_name, fnd.user_name

435:
436: nbsp VARCHAR2(10);
437:
438: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
439: SELECT port.portfolio_name, fnd.user_name
440: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
441: WHERE port.account_id = acc.account_id AND
442: fnd.user_id = acc.user_id AND
443: port.portfolio_id = cp_port_ids;

Line 440: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd

436: nbsp VARCHAR2(10);
437:
438: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
439: SELECT port.portfolio_name, fnd.user_name
440: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
441: WHERE port.account_id = acc.account_id AND
442: fnd.user_id = acc.user_id AND
443: port.portfolio_id = cp_port_ids;
444:

Line 442: fnd.user_id = acc.user_id AND

438: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
439: SELECT port.portfolio_name, fnd.user_name
440: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
441: WHERE port.account_id = acc.account_id AND
442: fnd.user_id = acc.user_id AND
443: port.portfolio_id = cp_port_ids;
444:
445: CURSOR c_viewer_info(cp_viewer_id IN NUMBER) IS
446: SELECT (hz.person_last_name||','||hz.person_first_name) VIEWER , us.user_name,us.email_address

Line 447: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac

443: port.portfolio_id = cp_port_ids;
444:
445: CURSOR c_viewer_info(cp_viewer_id IN NUMBER) IS
446: SELECT (hz.person_last_name||','||hz.person_first_name) VIEWER , us.user_name,us.email_address
447: FROM hz_parties hz, fnd_user us, igp_ac_accounts ac
448: WHERE ac.party_id = hz.party_id AND
449: us.user_id=ac.user_id AND
450: hz.party_id = cp_viewer_id;
451:

Line 456: FROM hz_parties hz,fnd_user fu

452: -- Get the details of CC name.
453: CURSOR c_get_CC_name(cp_CC_user_name VARCHAR2)
454: IS
455: SELECT (hz.person_last_name||','||hz.person_first_name) CC_NAME
456: FROM hz_parties hz,fnd_user fu
457: WHERE fu.person_party_id=hz.party_id
458: AND fu.user_name = cp_CC_user_name;
459:
460: