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.HZ_BANK_PUB dependencies on HZ_PARTIES

Line 19: AND hca.owner_table_name = 'HZ_PARTIES'

15: CURSOR c_codeassign (p_party_id IN NUMBER) IS
16: SELECT hca.class_code
17: FROM hz_code_assignments hca
18: WHERE hca.owner_table_id = p_party_id
19: AND hca.owner_table_name = 'HZ_PARTIES'
20: AND hca.class_category = 'BANK_INSTITUTION_TYPE'
21: AND hca.primary_flag = 'Y'
22: AND hca.status = 'A';
23:

Line 100: | bank_code field on HZ_PARTIES, |

96: | |
97: | MODIFICATION HISTORY |
98: | 27-NOV-2001 J. del Callar Created. |
99: | 08-MAY-2002 J. del Callar Bank number is now stored in the |
100: | bank_code field on HZ_PARTIES, |
101: | while branch number is stored in |
102: | branch_code. |
103: | 29-MAY-2002 J. del Callar Modified uniqueness check to |
104: | ignore the current bank branch |

Line 121: hz_parties hp

117: SELECT hop.bank_or_branch_number,
118: hop.organization_name,
119: hop.home_country
120: FROM hz_organization_profiles hop,
121: hz_parties hp
122: WHERE hop.party_id = p_bank_id
123: AND SYSDATE BETWEEN TRUNC(hop.effective_start_date)
124: AND NVL(hop.effective_end_date, SYSDATE+1)
125: AND hp.party_id = hop.party_id

Line 134: hz_parties hp,

130: hop.bank_or_branch_number,
131: hop.organization_name,
132: hop.home_country
133: FROM hz_organization_profiles hop,
134: hz_parties hp,
135: hz_relationships hr
136: WHERE hr.object_id = p_bank_rec.organization_rec.party_rec.party_id
137: AND hr.relationship_type = 'BANK_AND_BRANCH'
138: AND hr.relationship_code = 'HAS_BRANCH'

Line 140: AND hr.object_table_name = 'HZ_PARTIES'

136: WHERE hr.object_id = p_bank_rec.organization_rec.party_rec.party_id
137: AND hr.relationship_type = 'BANK_AND_BRANCH'
138: AND hr.relationship_code = 'HAS_BRANCH'
139: AND hr.object_type = 'ORGANIZATION'
140: AND hr.object_table_name = 'HZ_PARTIES'
141: AND hr.subject_type = 'ORGANIZATION'
142: AND hr.subject_table_name = 'HZ_PARTIES'
143: AND SYSDATE BETWEEN hr.start_date AND NVL(hr.end_date, SYSDATE + 1)
144: AND hr.status = 'A'

Line 142: AND hr.subject_table_name = 'HZ_PARTIES'

138: AND hr.relationship_code = 'HAS_BRANCH'
139: AND hr.object_type = 'ORGANIZATION'
140: AND hr.object_table_name = 'HZ_PARTIES'
141: AND hr.subject_type = 'ORGANIZATION'
142: AND hr.subject_table_name = 'HZ_PARTIES'
143: AND SYSDATE BETWEEN hr.start_date AND NVL(hr.end_date, SYSDATE + 1)
144: AND hr.status = 'A'
145: AND hop.party_id = hr.subject_id
146: AND SYSDATE BETWEEN TRUNC(hop.effective_start_date)

Line 161: AND hr.subject_table_name = 'HZ_PARTIES'

157: WHERE hr.subject_id = p_parent_id
158: AND hr.relationship_type = 'BANK_AND_BRANCH'
159: AND hr.relationship_code = 'HAS_BRANCH'
160: AND hr.subject_type = 'ORGANIZATION'
161: AND hr.subject_table_name = 'HZ_PARTIES'
162: AND hr.object_type = 'ORGANIZATION'
163: AND hr.object_table_name = 'HZ_PARTIES'
164: AND hopbb.party_id = hr.object_id
165: AND hopbb.party_id <>

Line 163: AND hr.object_table_name = 'HZ_PARTIES'

159: AND hr.relationship_code = 'HAS_BRANCH'
160: AND hr.subject_type = 'ORGANIZATION'
161: AND hr.subject_table_name = 'HZ_PARTIES'
162: AND hr.object_type = 'ORGANIZATION'
163: AND hr.object_table_name = 'HZ_PARTIES'
164: AND hopbb.party_id = hr.object_id
165: AND hopbb.party_id <>
166: NVL(p_bank_rec.organization_rec.party_rec.party_id,
167: -1)

Line 178: hz_parties hpbb

174: p_parent_id NUMBER
175: ) IS
176: SELECT 1
177: FROM hz_relationships hr,
178: hz_parties hpbb
179: WHERE hr.subject_id = p_parent_id
180: AND hr.relationship_type = 'BANK_AND_BRANCH'
181: AND hr.relationship_code = 'HAS_BRANCH'
182: AND hr.subject_type = 'ORGANIZATION'

Line 183: AND hr.subject_table_name = 'HZ_PARTIES'

179: WHERE hr.subject_id = p_parent_id
180: AND hr.relationship_type = 'BANK_AND_BRANCH'
181: AND hr.relationship_code = 'HAS_BRANCH'
182: AND hr.subject_type = 'ORGANIZATION'
183: AND hr.subject_table_name = 'HZ_PARTIES'
184: AND hr.object_type = 'ORGANIZATION'
185: AND hr.object_table_name = 'HZ_PARTIES'
186: AND hpbb.party_id = hr.object_id
187: AND hpbb.party_id <>

Line 185: AND hr.object_table_name = 'HZ_PARTIES'

181: AND hr.relationship_code = 'HAS_BRANCH'
182: AND hr.subject_type = 'ORGANIZATION'
183: AND hr.subject_table_name = 'HZ_PARTIES'
184: AND hr.object_type = 'ORGANIZATION'
185: AND hr.object_table_name = 'HZ_PARTIES'
186: AND hpbb.party_id = hr.object_id
187: AND hpbb.party_id <>
188: NVL(p_bank_rec.organization_rec.party_rec.party_id,
189: -1)

Line 374: SELECT hz_parties_s.NEXTVAL -- Bug 3397488

370: p_mode IN VARCHAR2,
371: x_return_status IN OUT NOCOPY VARCHAR2
372: ) IS
373: CURSOR orgidcur IS
374: SELECT hz_parties_s.NEXTVAL -- Bug 3397488
375: FROM DUAL;
376:
377: l_validation_procedure VARCHAR2(60);
378: l_temp_id NUMBER(15);

Line 461: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488

457: -- selected from the sequence.
458: CLOSE orgidcur;
459:
460: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
461: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464: END IF;
465: CLOSE orgidcur;

Line 576: AND hcp.owner_table_name = 'HZ_PARTIES'

572: p_edi_rec.edi_ece_tp_location_code
573: AND hcp.contact_point_id <> p_contact_point_rec.contact_point_id
574: AND hcp.contact_point_type = 'EDI'
575: AND hcp.status = 'A'
576: AND hcp.owner_table_name = 'HZ_PARTIES'
577: AND hcp.owner_table_id = hca.owner_table_id
578: AND hca.owner_table_name = 'HZ_PARTIES'
579: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
580:

Line 578: AND hca.owner_table_name = 'HZ_PARTIES'

574: AND hcp.contact_point_type = 'EDI'
575: AND hcp.status = 'A'
576: AND hcp.owner_table_name = 'HZ_PARTIES'
577: AND hcp.owner_table_id = hca.owner_table_id
578: AND hca.owner_table_name = 'HZ_PARTIES'
579: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
580:
581: -- cursor used to determine uniqueness of the EDI contact point across
582: -- bank party sites.

Line 598: AND hca.owner_table_name = 'HZ_PARTIES'

594: AND hcp.status = 'A'
595: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
596: AND hcp.owner_table_id = hps.party_site_id
597: AND hps.party_id = hca.owner_table_id
598: AND hca.owner_table_name = 'HZ_PARTIES'
599: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
600:
601: l_dummy NUMBER;
602: l_debug_prefix VARCHAR2(30) := '';

Line 1069: FROM hz_parties hp

1065: x_return_status IN OUT NOCOPY VARCHAR2
1066: ) RETURN VARCHAR2 IS
1067: CURSOR c_group IS
1068: SELECT hp.group_type
1069: FROM hz_parties hp
1070: WHERE hp.party_id = p_party_id
1071: AND hp.status = 'A';
1072: l_group_type VARCHAR2(30);
1073: BEGIN

Line 1462: FROM hz_organization_profiles hop, hz_parties hp

1458: x_return_status IN OUT NOCOPY VARCHAR2
1459: ) IS
1460: CURSOR c_parentcountry (p_party_id IN NUMBER) IS
1461: SELECT hop.home_country
1462: FROM hz_organization_profiles hop, hz_parties hp
1463: WHERE hop.party_id = p_party_id
1464: AND hp.party_id = hop.party_id
1465: AND hp.status = 'A'
1466: AND sysdate between trunc(hop.effective_start_date)

Line 1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');

1550: IF c_parentcountry%NOTFOUND THEN
1551: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1552: fnd_message.set_token('FK', 'active party');
1553: fnd_message.set_token('COLUMN', 'PARTY_ID');
1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1555: fnd_msg_pub.add;
1556: x_return_status := fnd_api.g_ret_sts_error;
1557: END IF;
1558: CLOSE c_parentcountry;

Line 2171: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';

2167: END IF;
2168:
2169: -- set up the code assignment record.
2170: l_code_assignment_rec.code_assignment_id := NULL;
2171: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
2172: l_code_assignment_rec.owner_table_id := p_party_id;
2173: l_code_assignment_rec.class_category := p_class_category;
2174: l_code_assignment_rec.class_code := p_bank_organization_type;
2175: l_code_assignment_rec.primary_flag := 'Y';

Line 2241: AND hca.owner_table_name = 'HZ_PARTIES'

2237: SELECT hca.code_assignment_id,
2238: hca.object_version_number
2239: FROM hz_code_assignments hca
2240: WHERE hca.class_category = p_class_category
2241: AND hca.owner_table_name = 'HZ_PARTIES'
2242: AND hca.owner_table_id = p_party_id
2243: AND hca.primary_flag='Y'
2244: AND sysdate between start_date_active and nvl(end_date_active,sysdate+1)
2245: AND hca.status = 'A';

Line 2252: AND hca.owner_table_name = 'HZ_PARTIES'

2248: SELECT hca.code_assignment_id,
2249: hca.object_version_number
2250: FROM hz_code_assignments hca
2251: WHERE hca.class_category = p_class_category
2252: AND hca.owner_table_name = 'HZ_PARTIES'
2253: AND hca.owner_table_id = p_party_id
2254: AND hca.class_code = p_bank_organization_type;
2255:
2256: CURSOR c_assignid2 IS

Line 2261: AND hca.owner_table_name = 'HZ_PARTIES'

2257: SELECT hca.code_assignment_id,
2258: hca.object_version_number
2259: FROM hz_code_assignments hca
2260: WHERE hca.class_category = p_class_category
2261: AND hca.owner_table_name = 'HZ_PARTIES'
2262: AND hca.owner_table_id = p_party_id
2263: AND hca.primary_flag='Y'
2264: AND (p_bank_organization_type is null or
2265: p_bank_organization_type = hca.class_code);

Line 2332: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';

2328: l_code_assignment_id, p_object_version_number;
2329:
2330: IF c_assignid1%NOTFOUND THEN
2331: l_code_assignment_rec := null;
2332: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
2333: l_code_assignment_rec.owner_table_id := p_party_id;
2334: l_code_assignment_rec.class_category := p_class_category;
2335: l_code_assignment_rec.class_code := p_bank_organization_type;
2336: l_code_assignment_rec.primary_flag := 'Y';

Line 2452: AND hca.owner_table_name = 'HZ_PARTIES'

2448: CURSOR c_party_usage_code IS
2449: SELECT hca.class_code
2450: FROM hz_code_assignments hca
2451: WHERE hca.class_category = 'BANK_INSTITUTION_TYPE'
2452: AND hca.owner_table_name = 'HZ_PARTIES'
2453: AND hca.owner_table_id = p_party_id
2454: AND hca.status = 'A';
2455:
2456: CURSOR c_party_usage_date (

Line 3171: p_subject_table_name => 'HZ_PARTIES',

3167: -- create a relationship between the bank branch and its parent bank
3168: create_relationship(
3169: p_subject_id => p_bank_party_id,
3170: p_subject_type => 'ORGANIZATION',
3171: p_subject_table_name => 'HZ_PARTIES',
3172: p_object_id => x_party_id,
3173: p_object_type => 'ORGANIZATION',
3174: p_object_table_name => 'HZ_PARTIES',
3175: p_relationship_code => 'HAS_BRANCH',

Line 3174: p_object_table_name => 'HZ_PARTIES',

3170: p_subject_type => 'ORGANIZATION',
3171: p_subject_table_name => 'HZ_PARTIES',
3172: p_object_id => x_party_id,
3173: p_object_type => 'ORGANIZATION',
3174: p_object_table_name => 'HZ_PARTIES',
3175: p_relationship_code => 'HAS_BRANCH',
3176: p_relationship_type => 'BANK_AND_BRANCH',
3177: p_created_by_module => l_bank_rec.organization_rec.created_by_module,
3178: p_application_id => l_bank_rec.organization_rec.application_id,

Line 3500: p_subject_table_name => 'HZ_PARTIES',

3496: update_relationship(
3497: p_relationship_id => p_relationship_id,
3498: p_subject_id => p_bank_party_id,
3499: p_subject_type => 'ORGANIZATION',
3500: p_subject_table_name => 'HZ_PARTIES',
3501: p_object_id =>
3502: l_bank_rec.organization_rec.party_rec.party_id,
3503: p_object_type => 'ORGANIZATION',
3504: p_object_table_name => 'HZ_PARTIES',

Line 3504: p_object_table_name => 'HZ_PARTIES',

3500: p_subject_table_name => 'HZ_PARTIES',
3501: p_object_id =>
3502: l_bank_rec.organization_rec.party_rec.party_id,
3503: p_object_type => 'ORGANIZATION',
3504: p_object_table_name => 'HZ_PARTIES',
3505: p_relationship_code => 'HAS_BRANCH',
3506: p_relationship_type => 'BANK_AND_BRANCH',
3507: p_created_by_module =>
3508: l_bank_rec.organization_rec.created_by_module,