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 HZ_PARTIES

Line 112: hz_parties parties

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
116: AND parties.party_id = cp_party_id;

Line 268: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;

264: l_group_member_rel_id_exists BOOLEAN :=FALSE;
265: l_note_exists BOOLEAN :=FALSE;
266:
267: l_owner_id NUMBER;
268: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;
269: l_owner_user_name VARCHAR2(50);
270: l_group_id NUMBER;
271: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
272: l_member_id NUMBER;

Line 271: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

267: l_owner_id NUMBER;
268: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;
269: l_owner_user_name VARCHAR2(50);
270: l_group_id NUMBER;
271: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
272: l_member_id NUMBER;
273: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;
274: l_member_user_name VARCHAR2(50);
275: l_group_member_rel_id NUMBER;

Line 273: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;

269: l_owner_user_name VARCHAR2(50);
270: l_group_id NUMBER;
271: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
272: l_member_id NUMBER;
273: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;
274: l_member_user_name VARCHAR2(50);
275: l_group_member_rel_id NUMBER;
276: l_note VARCHAR2(999);
277:

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 534: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;

530: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_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;

Line 537: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

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;
540: l_member_user_name FND_USER.USER_NAME%TYPE;
541: l_group_member_rel_id NUMBER;

Line 539: l_member_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;
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);

Line 952: -- ,hz_parties parties

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
956: -- WHERE users.customer_id = grp_owner.subject_id

Line 1580: FROM hz_parties

1576: l_object_version_number NUMBER;
1577:
1578: CURSOR c_get_object_ver_no (cp_group_id IN NUMBER) IS
1579: SELECT object_version_number
1580: FROM hz_parties
1581: WHERE party_id = cp_group_id
1582: AND party_type = 'GROUP'
1583: AND status = 'A';
1584:

Line 1664: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

1660: FROM ego_group_members_v
1661: WHERE group_id = cp_group_id;
1662:
1663: l_group_id NUMBER;
1664: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
1665: l_msg_document_plsql_proc VARCHAR2(9999);
1666: l_notification_id NUMBER;
1667: l_context VARCHAR2(500);
1668: l_item_type VARCHAR2(30) := G_ITEM_TYPE;

Line 1808: l_group_name hz_parties.party_name%TYPE;

1804: --
1805: -- END OF comments
1806: ----------------------------------------------------------------------
1807:
1808: l_group_name hz_parties.party_name%TYPE;
1809: -- l_owner_name VARCHAR2(100);
1810: l_member_name hz_parties.party_name%TYPE;
1811: l_member_note VARCHAR2(999);
1812:

Line 1810: l_member_name hz_parties.party_name%TYPE;

1806: ----------------------------------------------------------------------
1807:
1808: l_group_name hz_parties.party_name%TYPE;
1809: -- l_owner_name VARCHAR2(100);
1810: l_member_name hz_parties.party_name%TYPE;
1811: l_member_note VARCHAR2(999);
1812:
1813: l_item_type VARCHAR2(30);
1814: l_item_key VARCHAR2(30);

Line 1821: -- FROM hz_parties grp, hz_relationships grp_owner

1817: -- group name is not unique in APPS
1818: --
1819: -- CURSOR c_get_ownerid(cp_group_name VARCHAR2) IS
1820: -- SELECT grp_owner.subject_id
1821: -- FROM hz_parties grp, hz_relationships grp_owner
1822: -- WHERE grp.party_name = cp_group_name
1823: -- AND grp.application_id = EGO_PARTY_PUB.get_application_id
1824: -- AND grp.party_type = 'GROUP'
1825: -- AND grp_owner.object_id = grp.party_id

Line 1945: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

1941: SELECT party_name
1942: FROM ego_user_v
1943: WHERE user_name = cp_user_name;
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;

Line 1949: l_respondent HZ_PARTIES.PARTY_NAME%TYPE;

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:
1953: BEGIN

Line 2028: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

2024: --
2025: -- END OF comments
2026: ----------------------------------------------------------------------
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;

Line 2107: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

2103: --
2104: -- END OF comments
2105: ----------------------------------------------------------------------
2106:
2107: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
2108: l_item_type VARCHAR2(30);
2109: l_item_key VARCHAR2(30);
2110: l_member_id NUMBER;
2111:

Line 2112: l_member_name HZ_PARTIES.PARTY_NAME%TYPE;

2108: l_item_type VARCHAR2(30);
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:

Line 2206: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

2202: -- END OF comments
2203: ----------------------------------------------------------------------
2204:
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:

Line 2275: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

2271: --
2272: -- END OF comments
2273: ----------------------------------------------------------------------
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);

Line 2360: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;

2356: --
2357: -- END OF comments
2358: ----------------------------------------------------------------------
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);

Line 2551: l_party_id hz_parties.party_id%TYPE;

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);
2555: l_num NUMBER;

Line 2552: l_group_id hz_parties.party_id%TYPE;

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);
2555: l_num NUMBER;
2556: l_group_name hz_parties.party_name%TYPE;

Line 2556: l_group_name hz_parties.party_name%TYPE;

2552: l_group_id hz_parties.party_id%TYPE;
2553:
2554: l_create_role_name VARCHAR2(2000);
2555: l_num NUMBER;
2556: l_group_name hz_parties.party_name%TYPE;
2557:
2558: BEGIN
2559:
2560: mdebug( ' Create group admin wf role ');