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_PARTY_PUB dependencies on HZ_PARTIES

Line 102: -- Eg., HZ_PARTIES

98: -- Type of the subject
99: -- Eg., PERSON
100: -- p_subject_table_name IN VARCHAR2 (required)
101: -- Table in which the subject is available
102: -- Eg., HZ_PARTIES
103: -- p_object_id IN NUMBER (required)
104: -- Object on which the relationship needs to be created
105: -- Eg., A group
106: -- p_object_type IN VARCHAR2 (required)

Line 111: -- Eg., HZ_PARTIES

107: -- Type of the object
108: -- Eg., GROUP
109: -- p_object_table_name IN VARCHAR2 (required)
110: -- Table in which the object is available
111: -- Eg., HZ_PARTIES
112: -- p_relationship_code IN VARCHAR2 (required)
113: -- Current values are MEMBER_OF wrt subject
114: -- p_relationship_type IN VARCHAR2 := fnd_api.g_MISS_CHAR
115: -- Forward OR Backward. Default is Bi-directional

Line 577: -- Creates a record into HZ_PARTIES with party_type = 'GROUP'

573: -- API name : CREATE_GROUP
574: -- TYPE : Public
575: -- Pre-reqs : None
576: -- FUNCTION : Create a Group.
577: -- Creates a record into HZ_PARTIES with party_type = 'GROUP'
578: -- Creates the requestor as a member of the GROUP
579: -- (two way relationship -- MEMBER_OF and CONTAINS_MEMBER)
580: --
581: -- x_group_id OUT NUMBER

Line 700: UPDATE hz_parties

696: --
697: -- l_group_rec doesnt have mission_statement as its attribute.
698: -- Refer to BUG 2467872
699: --
700: UPDATE hz_parties
701: SET mission_statement = p_description
702: WHERE party_id = l_group_id;
703: END IF;
704: --

Line 709: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

705: -- inserting the email address for the group
706: --
707: IF p_email_address IS NOT NULL THEN
708: l_contact_point_rec.contact_point_type := 'EMAIL';
709: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
710: l_contact_point_rec.owner_table_id := l_group_id;
711: l_contact_point_rec.created_by_module := CREATED_BY_MODULE;
712: l_contact_point_rec.application_id := EGO_PARTY_PUB.get_application_id;
713: l_email_rec.email_address := p_email_address;

Line 754: -- p_subject_table_name => 'HZ_PARTIES',

750: -- p_init_msg_list => NVL(p_init_msg_list, 'F'),
751: -- p_commit => NVL(p_commit, 'F'),
752: -- p_subject_id => p_owner_person_id,
753: -- p_subject_type => 'PERSON',
754: -- p_subject_table_name => 'HZ_PARTIES',
755: -- p_object_id => l_group_id,
756: -- p_object_type => 'GROUP',
757: -- p_object_table_name => 'HZ_PARTIES',
758: -- p_relationship_code => G_OWNER_GROUP_REL_CODE,

Line 757: -- p_object_table_name => 'HZ_PARTIES',

753: -- p_subject_type => 'PERSON',
754: -- p_subject_table_name => 'HZ_PARTIES',
755: -- p_object_id => l_group_id,
756: -- p_object_type => 'GROUP',
757: -- p_object_table_name => 'HZ_PARTIES',
758: -- p_relationship_code => G_OWNER_GROUP_REL_CODE,
759: -- p_relationship_type => G_OWNER_GROUP_REL_TYPE,
760: -- p_program_name => G_PKG_NAME,
761: -- p_start_date => SYSDATE,

Line 974: AND owner_table_name = 'HZ_PARTIES'

970: CURSOR c_get_contact_details (cp_group_id IN NUMBER) IS
971: SELECT contact_point_id, object_version_number, email_address, status, email_format
972: FROM hz_contact_points
973: WHERE owner_table_id = cp_group_id
974: AND owner_table_name = 'HZ_PARTIES'
975: AND status = 'A';
976:
977: BEGIN
978: -- check if all required parameters are passed to the procedure

Line 1038: UPDATE hz_parties

1034: RETURN;
1035: ELSE
1036: -- in TCA the update description not done,
1037: -- Refer to BUG 2467872
1038: UPDATE hz_parties
1039: SET mission_statement = p_description
1040: WHERE party_id = p_group_id;
1041: END IF;
1042:

Line 1060: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

1056: mdebug('UPDATE_GROUP: No need to create Contact Point during update of Group');
1057: ELSE
1058: -- contact point required. Need to create one.
1059: l_contact_point_rec.contact_point_type := 'EMAIL';
1060: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1061: l_contact_point_rec.owner_table_id := p_group_id;
1062: l_contact_point_rec.created_by_module := CREATED_BY_MODULE;
1063: l_contact_point_rec.application_id := EGO_PARTY_PUB.get_application_id;
1064: l_email_rec.email_address := p_email_address;

Line 1194: -- p_subject_table_name => 'HZ_PARTIES',

1190: -- p_init_msg_list => NVL(p_init_msg_list, 'F'),
1191: -- p_commit => NVL(p_commit, 'F'),
1192: -- p_subject_id => p_owner_person_id,
1193: -- p_subject_type => 'PERSON',
1194: -- p_subject_table_name => 'HZ_PARTIES',
1195: -- p_object_id => p_group_id,
1196: -- p_object_type => 'GROUP',
1197: -- p_object_table_name => 'HZ_PARTIES',
1198: -- p_relationship_code => G_OWNER_GROUP_REL_CODE,

Line 1197: -- p_object_table_name => 'HZ_PARTIES',

1193: -- p_subject_type => 'PERSON',
1194: -- p_subject_table_name => 'HZ_PARTIES',
1195: -- p_object_id => p_group_id,
1196: -- p_object_type => 'GROUP',
1197: -- p_object_table_name => 'HZ_PARTIES',
1198: -- p_relationship_code => G_OWNER_GROUP_REL_CODE,
1199: -- p_relationship_type => G_OWNER_GROUP_REL_TYPE,
1200: -- p_program_name => G_PKG_NAME,
1201: -- p_start_date => SYSDATE,

Line 1385: AND owner_table_name = 'HZ_PARTIES'

1381: CURSOR c_get_contact_point (cp_group_id IN NUMBER) IS
1382: SELECT contact_point_id, object_version_number
1383: FROM hz_contact_points
1384: WHERE owner_table_id = cp_group_id
1385: AND owner_table_name = 'HZ_PARTIES'
1386: AND status = 'A';
1387:
1388: BEGIN
1389: -- check if all required parameters are passed to the procedure

Line 1702: p_subject_table_name => 'HZ_PARTIES',

1698: p_init_msg_list => NVL(p_init_msg_list, 'F'),
1699: p_commit => NVL(p_commit, 'F'),
1700: p_subject_id => p_member_id,
1701: p_subject_type => 'PERSON',
1702: p_subject_table_name => 'HZ_PARTIES',
1703: p_object_id => p_group_id,
1704: p_object_type => 'GROUP',
1705: p_object_table_name => 'HZ_PARTIES',
1706: p_relationship_code => G_MEMBER_GROUP_REL_CODE,

Line 1705: p_object_table_name => 'HZ_PARTIES',

1701: p_subject_type => 'PERSON',
1702: p_subject_table_name => 'HZ_PARTIES',
1703: p_object_id => p_group_id,
1704: p_object_type => 'GROUP',
1705: p_object_table_name => 'HZ_PARTIES',
1706: p_relationship_code => G_MEMBER_GROUP_REL_CODE,
1707: p_relationship_type => G_MEMBER_GROUP_REL_TYPE,
1708: p_program_name => CREATED_BY_MODULE,
1709: p_start_date => NVL(p_start_date, SYSDATE),

Line 1878: l_group_id HZ_PARTIES.PARTY_ID%TYPE;

1874:
1875: l_member_id NUMBER;
1876: L_GRANT_GUID VARCHAR2(100);
1877: x_ret_status VARCHAR2(1);
1878: l_group_id HZ_PARTIES.PARTY_ID%TYPE;
1879: x_errorcode NUMBER;
1880:
1881: CURSOR get_grant_guid_cur (cp_party_id NUMBER,
1882: cp_instance_id NUMBER)

Line 2105: x_party_number HZ_PARTIES.party_number%TYPE;

2101: --output variables for the HZ_PARTY_PUB.Create_Person call, which
2102: --need not be passed back to the Calling procedure.
2103: x_main_id NUMBER;
2104: x_profile_id NUMBER;
2105: x_party_number HZ_PARTIES.party_number%TYPE;
2106:
2107: CURSOR c_grp_member_emailaddr (cp_group_id IN NUMBER) IS
2108: SELECT member.email_address
2109: FROM hz_relationships grp_rel,

Line 2159: FROM hz_parties

2155:
2156: mdebug('GET_EMAIL_ADDRESSES: selecting party type ');
2157: SELECT party_type
2158: INTO l_party_type
2159: FROM hz_parties
2160: WHERE party_id = p_party_id;
2161:
2162: mdebug('GET_EMAIL_ADDRESSES: party type selected as ' || l_party_type );
2163: IF (l_party_type = 'PERSON') THEN

Line 2342: WHERE owner_table_name = 'HZ_PARTIES'

2338:
2339: SELECT COUNT(*)
2340: INTO l_class_count
2341: FROM hz_code_assignments
2342: WHERE owner_table_name = 'HZ_PARTIES'
2343: AND owner_table_id = p_party_id
2344: AND class_category = p_category;
2345:
2346: IF ( l_class_count > 0 ) THEN

Line 2462: WHERE owner_table_name = 'HZ_PARTIES'

2458:
2459: SELECT code_assignment_id, object_version_number
2460: INTO l_assignment_id, l_version_number
2461: FROM hz_code_assignments
2462: WHERE owner_table_name = 'HZ_PARTIES'
2463: AND owner_table_id = p_party_id
2464: AND class_category = p_category;
2465:
2466: l_code_assignment_rec.owner_table_name := OWNER_TABLE_NAME;

Line 2523: AND hca.owner_table_name = 'HZ_PARTIES'

2519: SELECT hca.owner_table_id
2520: INTO l_party_id
2521: FROM hz_code_assignments hca
2522: WHERE hca.owner_table_id = p_company_id
2523: AND hca.owner_table_name = 'HZ_PARTIES'
2524: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
2525: AND hca.class_code = 'ENTERPRISE';
2526:
2527: BEGIN

Line 2640: FROM hz_parties hp, hz_code_assignments hca

2636: BEGIN
2637:
2638: SELECT hp.party_id
2639: INTO l_org_id
2640: FROM hz_parties hp, hz_code_assignments hca
2641: WHERE hca.owner_table_id = hp.party_id
2642: AND hca.owner_table_name = 'HZ_PARTIES'
2643: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
2644: AND hca.class_code = 'ENTERPRISE';

Line 2642: AND hca.owner_table_name = 'HZ_PARTIES'

2638: SELECT hp.party_id
2639: INTO l_org_id
2640: FROM hz_parties hp, hz_code_assignments hca
2641: WHERE hca.owner_table_id = hp.party_id
2642: AND hca.owner_table_name = 'HZ_PARTIES'
2643: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
2644: AND hca.class_code = 'ENTERPRISE';
2645:
2646: FND_FILE.put_line(which => fnd_file.log

Line 2658: p_subject_table_name => 'HZ_PARTIES',

2654: p_init_msg_list => FND_API.G_FALSE,
2655: p_commit => FND_API.G_FALSE,
2656: p_subject_id => user_rec.PERSON_ID,
2657: p_subject_type => 'PERSON',
2658: p_subject_table_name => 'HZ_PARTIES',
2659: p_object_id => l_org_id,
2660: p_object_type => 'ORGANIZATION',
2661: p_object_table_name => 'HZ_PARTIES',
2662: p_relationship_code => 'EMPLOYEE_OF',

Line 2661: p_object_table_name => 'HZ_PARTIES',

2657: p_subject_type => 'PERSON',
2658: p_subject_table_name => 'HZ_PARTIES',
2659: p_object_id => l_org_id,
2660: p_object_type => 'ORGANIZATION',
2661: p_object_table_name => 'HZ_PARTIES',
2662: p_relationship_code => 'EMPLOYEE_OF',
2663: p_relationship_type => 'POS_EMPLOYMENT',
2664: p_program_name => CREATED_BY_MODULE,
2665: p_start_date => SYSDATE,