eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GROUP_WF_PKG dependencies on FND_USER

Line 110: FROM fnd_user_preferences user_prefs,

106: ----------------------------------------------------------------------
107:
108: CURSOR c_get_mail_pref (cp_party_id NUMBER) IS
109: SELECT preference_value
110: FROM fnd_user_preferences user_prefs,
111: fnd_user users,
112: hz_parties parties
113: WHERE user_prefs.preference_name = 'MAILTYPE'
114: AND user_prefs.user_name = users.user_name

Line 111: fnd_user users,

107:
108: CURSOR c_get_mail_pref (cp_party_id NUMBER) IS
109: SELECT preference_value
110: FROM fnd_user_preferences user_prefs,
111: fnd_user users,
112: hz_parties parties
113: WHERE user_prefs.preference_name = 'MAILTYPE'
114: AND user_prefs.user_name = users.user_name
115: AND users.customer_id = parties.party_id

Line 118: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

114: AND user_prefs.user_name = users.user_name
115: AND users.customer_id = parties.party_id
116: AND parties.party_id = cp_party_id;
117:
118: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
119:
120: BEGIN
121: --retrieve mail preference for the owner
122: OPEN c_get_mail_pref(cp_party_id => p_party_id);

Line 281: -- FROM fnd_user users, hz_parties parties

277:
278: CURSOR get_user_party_names_c (p_party_id NUMBER) IS
279: -- fix for 3102621 changing the query
280: -- SELECT users.user_name, parties.party_name
281: -- FROM fnd_user users, hz_parties parties
282: -- WHERE users.customer_id = parties.party_id
283: -- AND parties.party_id = p_party_id;
284: --PERF TUNINIG :4956096
285: SELECT user_name, party_name

Line 291: -- FROM fnd_user users, hz_parties parties, hz_relationships grp_owner

287: WHERE party_id = p_party_id;
288:
289: -- CURSOR get_owner_user_party_names_c (p_group_id NUMBER) IS
290: -- SELECT users.user_name, parties.party_name
291: -- FROM fnd_user users, hz_parties parties, hz_relationships grp_owner
292: -- WHERE grp_owner.object_id = p_group_id
293: -- AND grp_owner.relationship_type = G_OWNER_GROUP_REL_TYPE
294: -- AND grp_owner.status = 'A'
295: -- AND SYSDATE BETWEEN grp_owner.start_date

Line 535: l_owner_user_name FND_USER.USER_NAME%TYPE;

531: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
532:
533: l_owner_id NUMBER;
534: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;
535: l_owner_user_name FND_USER.USER_NAME%TYPE;
536: l_group_id NUMBER;
537: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
538: l_member_id NUMBER;
539: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 540: l_member_user_name FND_USER.USER_NAME%TYPE;

536: l_group_id NUMBER;
537: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
538: l_member_id NUMBER;
539: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;
540: l_member_user_name FND_USER.USER_NAME%TYPE;
541: l_group_member_rel_id NUMBER;
542: --used to generate plsql document
543: l_msg_document_plsql_proc VARCHAR2(9999);
544: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

Line 544: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

540: l_member_user_name FND_USER.USER_NAME%TYPE;
541: l_group_member_rel_id NUMBER;
542: --used to generate plsql document
543: l_msg_document_plsql_proc VARCHAR2(9999);
544: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
545:
546: l_member_note VARCHAR2(2000);
547: l_admin_note VARCHAR2(2000);
548: l_temp_message VARCHAR2(2000);

Line 951: -- FROM fnd_user users

947: -- Removed as the owner is now obtained from fnd_grants
948: --
949: -- CURSOR c_get_owner_name(cp_group_id NUMBER) IS
950: -- SELECT users.user_name
951: -- FROM fnd_user users
952: -- ,hz_parties parties
953: -- ,hz_relationships grp_owner
954: -- WHERE users.customer_id = parties.party_id
955: -- AND parties.party_id = grp_owner.subject_id

Line 966: -- FROM fnd_user users

962: -- AND grp_owner.object_id = cp_group_id;
963:
964: -- CURSOR c_get_user_name(cp_party_id NUMBER) IS
965: -- SELECT users.user_name
966: -- FROM fnd_user users
967: -- WHERE users.customer_id = cp_party_id;
968:
969: l_mail_pref wf_users.notification_preference%TYPE;
970: l_owner_name fnd_user.user_name%TYPE;

Line 970: l_owner_name fnd_user.user_name%TYPE;

966: -- FROM fnd_user users
967: -- WHERE users.customer_id = cp_party_id;
968:
969: l_mail_pref wf_users.notification_preference%TYPE;
970: l_owner_name fnd_user.user_name%TYPE;
971: l_user_name fnd_user.user_name%TYPE;
972:
973: BEGIN
974:

Line 971: l_user_name fnd_user.user_name%TYPE;

967: -- WHERE users.customer_id = cp_party_id;
968:
969: l_mail_pref wf_users.notification_preference%TYPE;
970: l_owner_name fnd_user.user_name%TYPE;
971: l_user_name fnd_user.user_name%TYPE;
972:
973: BEGIN
974:
975: mdebug (' START_SUBSCRIPTION_PROCESS (SSP) : ....1.... '|| p_process_type);

Line 1831: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

1827: -- AND SYSDATE BETWEEN grp_owner.start_date AND NVL(grp_owner.end_date, SYSDATE)
1828: -- AND grp_owner.relationship_type = G_OWNER_GROUP_REL_TYPE;
1829:
1830: -- l_owner_id NUMBER;
1831: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
1832: l_temp_message VARCHAR2(2000);
1833:
1834: BEGIN
1835:

Line 1948: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

1944:
1945: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
1946: l_item_type VARCHAR2(30);
1947: l_item_key VARCHAR2(30);
1948: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
1949: l_respondent HZ_PARTIES.PARTY_NAME%TYPE;
1950: l_user_name FND_USER.USER_NAME%TYPE;
1951: l_member_id NUMBER;
1952:

Line 1950: l_user_name FND_USER.USER_NAME%TYPE;

1946: l_item_type VARCHAR2(30);
1947: l_item_key VARCHAR2(30);
1948: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
1949: l_respondent HZ_PARTIES.PARTY_NAME%TYPE;
1950: l_user_name FND_USER.USER_NAME%TYPE;
1951: l_member_id NUMBER;
1952:
1953: BEGIN
1954: -- parse document_id for the ':' dividing item type name from item key value

Line 2031: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

2027:
2028: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
2029: l_item_type VARCHAR2(30);
2030: l_item_key VARCHAR2(30);
2031: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
2032: l_member_id NUMBER;
2033:
2034: BEGIN
2035: -- parse document_id for the ':' dividing item type name from item key value

Line 2113: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

2109: l_item_key VARCHAR2(30);
2110: l_member_id NUMBER;
2111:
2112: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;
2113: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
2114: l_member_note VARCHAR2(2000);
2115: l_temp_message VARCHAR2(2000);
2116:
2117: BEGIN

Line 2209: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

2205: l_member_id NUMBER;
2206: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
2207: l_item_type VARCHAR2(30);
2208: l_item_key VARCHAR2(30);
2209: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
2210:
2211: BEGIN
2212: -- parse document_id for the ':' dividing item type name from item key value
2213: -- document_id value will take the form : starting with

Line 2278: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

2274:
2275: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
2276: l_item_type VARCHAR2(30);
2277: l_item_key VARCHAR2(30);
2278: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
2279: l_deletion_note VARCHAR2(999);
2280: l_temp_message VARCHAR2(2000);
2281: l_member_id NUMBER;
2282:

Line 2363: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;

2359:
2360: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
2361: l_item_type VARCHAR2(30);
2362: l_item_key VARCHAR2(30);
2363: l_mail_pref FND_USER_PREFERENCES.PREFERENCE_VALUE%TYPE;
2364: l_deletion_note VARCHAR2(999);
2365: l_temp_message VARCHAR2(2000);
2366: l_member_id NUMBER;
2367:

Line 2550: l_user_name fnd_user.user_name%TYPE;

2546: l_api_name VARCHAR2(30) := 'SET_WF_ROLES';
2547: l_role_name VARCHAR2(360) ;
2548: l_role_display_name VARCHAR2(100);
2549: l_grantee_key fnd_grants.grantee_key%TYPE;
2550: l_user_name fnd_user.user_name%TYPE;
2551: l_party_id hz_parties.party_id%TYPE;
2552: l_group_id hz_parties.party_id%TYPE;
2553:
2554: l_create_role_name VARCHAR2(2000);