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 162: AND hr.subject_table_name = 'HZ_PARTIES'

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

Line 164: AND hr.object_table_name = 'HZ_PARTIES'

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

Line 179: hz_parties hpbb

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

Line 184: AND hr.subject_table_name = 'HZ_PARTIES'

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

Line 186: AND hr.object_table_name = 'HZ_PARTIES'

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

Line 386: SELECT hz_parties_s.NEXTVAL -- Bug 3397488

382: p_mode IN VARCHAR2,
383: x_return_status IN OUT NOCOPY VARCHAR2
384: ) IS
385: CURSOR orgidcur IS
386: SELECT hz_parties_s.NEXTVAL -- Bug 3397488
387: FROM DUAL;
388:
389: l_validation_procedure VARCHAR2(60);
390: l_temp_id NUMBER(15);

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

469: -- selected from the sequence.
470: CLOSE orgidcur;
471:
472: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
473: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
474: fnd_msg_pub.add;
475: RAISE fnd_api.g_exc_error;
476: END IF;
477: CLOSE orgidcur;

Line 588: AND hcp.owner_table_name = 'HZ_PARTIES'

584: p_edi_rec.edi_ece_tp_location_code
585: AND hcp.contact_point_id <> p_contact_point_rec.contact_point_id
586: AND hcp.contact_point_type = 'EDI'
587: AND hcp.status = 'A'
588: AND hcp.owner_table_name = 'HZ_PARTIES'
589: AND hcp.owner_table_id = hca.owner_table_id
590: AND hca.owner_table_name = 'HZ_PARTIES'
591: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
592:

Line 590: AND hca.owner_table_name = 'HZ_PARTIES'

586: AND hcp.contact_point_type = 'EDI'
587: AND hcp.status = 'A'
588: AND hcp.owner_table_name = 'HZ_PARTIES'
589: AND hcp.owner_table_id = hca.owner_table_id
590: AND hca.owner_table_name = 'HZ_PARTIES'
591: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
592:
593: -- cursor used to determine uniqueness of the EDI contact point across
594: -- bank party sites.

Line 610: AND hca.owner_table_name = 'HZ_PARTIES'

606: AND hcp.status = 'A'
607: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
608: AND hcp.owner_table_id = hps.party_site_id
609: AND hps.party_id = hca.owner_table_id
610: AND hca.owner_table_name = 'HZ_PARTIES'
611: AND hca.class_category = 'BANK_INSTITUTION_TYPE';
612:
613: l_dummy NUMBER;
614: l_debug_prefix VARCHAR2(30) := '';

Line 1081: FROM hz_parties hp

1077: x_return_status IN OUT NOCOPY VARCHAR2
1078: ) RETURN VARCHAR2 IS
1079: CURSOR c_group IS
1080: SELECT hp.group_type
1081: FROM hz_parties hp
1082: WHERE hp.party_id = p_party_id
1083: AND hp.status = 'A';
1084: l_group_type VARCHAR2(30);
1085: BEGIN

Line 1474: FROM hz_organization_profiles hop, hz_parties hp

1470: x_return_status IN OUT NOCOPY VARCHAR2
1471: ) IS
1472: CURSOR c_parentcountry (p_party_id IN NUMBER) IS
1473: SELECT hop.home_country
1474: FROM hz_organization_profiles hop, hz_parties hp
1475: WHERE hop.party_id = p_party_id
1476: AND hp.party_id = hop.party_id
1477: AND hp.status = 'A'
1478: AND sysdate between trunc(hop.effective_start_date)

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

1562: IF c_parentcountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active party');
1565: fnd_message.set_token('COLUMN', 'PARTY_ID');
1566: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;
1569: END IF;
1570: CLOSE c_parentcountry;

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

2179: END IF;
2180:
2181: -- set up the code assignment record.
2182: l_code_assignment_rec.code_assignment_id := NULL;
2183: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
2184: l_code_assignment_rec.owner_table_id := p_party_id;
2185: l_code_assignment_rec.class_category := p_class_category;
2186: l_code_assignment_rec.class_code := p_bank_organization_type;
2187: l_code_assignment_rec.primary_flag := 'Y';

Line 2256: AND hca.owner_table_name = 'HZ_PARTIES'

2252: SELECT hca.code_assignment_id,
2253: hca.object_version_number
2254: FROM hz_code_assignments hca
2255: WHERE hca.class_category = p_class_category
2256: AND hca.owner_table_name = 'HZ_PARTIES'
2257: AND hca.owner_table_id = p_party_id
2258: AND hca.primary_flag='Y'
2259: AND sysdate between start_date_active and nvl(end_date_active,sysdate+1)
2260: AND hca.status = 'A';

Line 2267: AND hca.owner_table_name = 'HZ_PARTIES'

2263: SELECT hca.code_assignment_id,
2264: hca.object_version_number
2265: FROM hz_code_assignments hca
2266: WHERE hca.class_category = p_class_category
2267: AND hca.owner_table_name = 'HZ_PARTIES'
2268: AND hca.owner_table_id = p_party_id
2269: AND hca.class_code = p_bank_organization_type;
2270:
2271: CURSOR c_assignid2 IS

Line 2276: AND hca.owner_table_name = 'HZ_PARTIES'

2272: SELECT hca.code_assignment_id,
2273: hca.object_version_number
2274: FROM hz_code_assignments hca
2275: WHERE hca.class_category = p_class_category
2276: AND hca.owner_table_name = 'HZ_PARTIES'
2277: AND hca.owner_table_id = p_party_id
2278: AND hca.primary_flag='Y'
2279: AND (p_bank_organization_type is null or
2280: p_bank_organization_type = hca.class_code);

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

2343: l_code_assignment_id, p_object_version_number;
2344:
2345: IF c_assignid1%NOTFOUND THEN
2346: l_code_assignment_rec := null;
2347: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
2348: l_code_assignment_rec.owner_table_id := p_party_id;
2349: l_code_assignment_rec.class_category := p_class_category;
2350: l_code_assignment_rec.class_code := p_bank_organization_type;
2351: l_code_assignment_rec.primary_flag := 'Y';

Line 2467: AND hca.owner_table_name = 'HZ_PARTIES'

2463: CURSOR c_party_usage_code IS
2464: SELECT hca.class_code
2465: FROM hz_code_assignments hca
2466: WHERE hca.class_category = 'BANK_INSTITUTION_TYPE'
2467: AND hca.owner_table_name = 'HZ_PARTIES'
2468: AND hca.owner_table_id = p_party_id
2469: AND hca.status = 'A';
2470:
2471: CURSOR c_party_usage_date (

Line 3190: p_subject_table_name => 'HZ_PARTIES',

3186: -- create a relationship between the bank branch and its parent bank
3187: create_relationship(
3188: p_subject_id => p_bank_party_id,
3189: p_subject_type => 'ORGANIZATION',
3190: p_subject_table_name => 'HZ_PARTIES',
3191: p_object_id => x_party_id,
3192: p_object_type => 'ORGANIZATION',
3193: p_object_table_name => 'HZ_PARTIES',
3194: p_relationship_code => 'HAS_BRANCH',

Line 3193: p_object_table_name => 'HZ_PARTIES',

3189: p_subject_type => 'ORGANIZATION',
3190: p_subject_table_name => 'HZ_PARTIES',
3191: p_object_id => x_party_id,
3192: p_object_type => 'ORGANIZATION',
3193: p_object_table_name => 'HZ_PARTIES',
3194: p_relationship_code => 'HAS_BRANCH',
3195: p_relationship_type => 'BANK_AND_BRANCH',
3196: p_created_by_module => l_bank_rec.organization_rec.created_by_module,
3197: p_application_id => l_bank_rec.organization_rec.application_id,

Line 3523: p_subject_table_name => 'HZ_PARTIES',

3519: update_relationship(
3520: p_relationship_id => p_relationship_id,
3521: p_subject_id => p_bank_party_id,
3522: p_subject_type => 'ORGANIZATION',
3523: p_subject_table_name => 'HZ_PARTIES',
3524: p_object_id =>
3525: l_bank_rec.organization_rec.party_rec.party_id,
3526: p_object_type => 'ORGANIZATION',
3527: p_object_table_name => 'HZ_PARTIES',

Line 3527: p_object_table_name => 'HZ_PARTIES',

3523: p_subject_table_name => 'HZ_PARTIES',
3524: p_object_id =>
3525: l_bank_rec.organization_rec.party_rec.party_id,
3526: p_object_type => 'ORGANIZATION',
3527: p_object_table_name => 'HZ_PARTIES',
3528: p_relationship_code => 'HAS_BRANCH',
3529: p_relationship_type => 'BANK_AND_BRANCH',
3530: p_created_by_module =>
3531: l_bank_rec.organization_rec.created_by_module,