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.CE_BANK_PUB dependencies on HZ_PARTY_V2PUB

Line 191: l_org_rec hz_party_v2pub.organization_rec_type;

187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2
189: ) IS
190: l_bank_rec hz_bank_pub.bank_rec_type;
191: l_org_rec hz_party_v2pub.organization_rec_type;
192: l_party_rec hz_party_v2pub.party_rec_type;
193: l_party_number VARCHAR2(30);
194: l_profile_id NUMBER(15);
195: l_code_assignment_id NUMBER(15);

Line 192: l_party_rec hz_party_v2pub.party_rec_type;

188: x_msg_data OUT NOCOPY VARCHAR2
189: ) IS
190: l_bank_rec hz_bank_pub.bank_rec_type;
191: l_org_rec hz_party_v2pub.organization_rec_type;
192: l_party_rec hz_party_v2pub.party_rec_type;
193: l_party_number VARCHAR2(30);
194: l_profile_id NUMBER(15);
195: l_code_assignment_id NUMBER(15);
196: l_bank_number VARCHAR2(30);

Line 422: l_org_rec hz_party_v2pub.organization_rec_type;

418: x_msg_count OUT NOCOPY NUMBER,
419: x_msg_data OUT NOCOPY VARCHAR2
420: ) IS
421: l_bank_rec hz_bank_pub.bank_rec_type;
422: l_org_rec hz_party_v2pub.organization_rec_type;
423: l_party_rec hz_party_v2pub.party_rec_type;
424: l_profile_id NUMBER(15);
425: l_ca_object_version_number NUMBER(15);
426: l_country_code VARCHAR2(60);

Line 423: l_party_rec hz_party_v2pub.party_rec_type;

419: x_msg_data OUT NOCOPY VARCHAR2
420: ) IS
421: l_bank_rec hz_bank_pub.bank_rec_type;
422: l_org_rec hz_party_v2pub.organization_rec_type;
423: l_party_rec hz_party_v2pub.party_rec_type;
424: l_profile_id NUMBER(15);
425: l_ca_object_version_number NUMBER(15);
426: l_country_code VARCHAR2(60);
427: l_bank_number VARCHAR2(30);

Line 655: l_org_rec hz_party_v2pub.organization_rec_type;

651: l_branch_end DATE;
652: l_bank_ovn NUMBER(15);
653: l_branch_ovn NUMBER(15);
654: l_bank_rec hz_bank_pub.bank_rec_type;
655: l_org_rec hz_party_v2pub.organization_rec_type;
656: l_party_rec hz_party_v2pub.party_rec_type;
657: l_profile_id NUMBER(15);
658: BEGIN
659: SAVEPOINT set_bank_end_date;

Line 656: l_party_rec hz_party_v2pub.party_rec_type;

652: l_bank_ovn NUMBER(15);
653: l_branch_ovn NUMBER(15);
654: l_bank_rec hz_bank_pub.bank_rec_type;
655: l_org_rec hz_party_v2pub.organization_rec_type;
656: l_party_rec hz_party_v2pub.party_rec_type;
657: l_profile_id NUMBER(15);
658: BEGIN
659: SAVEPOINT set_bank_end_date;
660:

Line 982: l_org_rec hz_party_v2pub.organization_rec_type;

978: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
979: AND hz_p.party_id = p_bank_id;
980:
981: l_branch_rec hz_bank_pub.bank_rec_type;
982: l_org_rec hz_party_v2pub.organization_rec_type;
983: l_party_rec hz_party_v2pub.party_rec_type;
984: l_party_number VARCHAR2(30);
985: l_profile_id NUMBER(15);
986: l_rel_id NUMBER(15);

Line 983: l_party_rec hz_party_v2pub.party_rec_type;

979: AND hz_p.party_id = p_bank_id;
980:
981: l_branch_rec hz_bank_pub.bank_rec_type;
982: l_org_rec hz_party_v2pub.organization_rec_type;
983: l_party_rec hz_party_v2pub.party_rec_type;
984: l_party_number VARCHAR2(30);
985: l_profile_id NUMBER(15);
986: l_rel_id NUMBER(15);
987: l_rel_party_id NUMBER(15);

Line 1283: l_org_rec hz_party_v2pub.organization_rec_type;

1279: AND owner_table_name = 'HZ_PARTIES'
1280: AND owner_table_id = p_branch_id;
1281:
1282: l_branch_rec hz_bank_pub.bank_rec_type;
1283: l_org_rec hz_party_v2pub.organization_rec_type;
1284: l_party_rec hz_party_v2pub.party_rec_type;
1285: l_party_number VARCHAR2(30);
1286: l_profile_id NUMBER(15);
1287: l_rel_id NUMBER(15);

Line 1284: l_party_rec hz_party_v2pub.party_rec_type;

1280: AND owner_table_id = p_branch_id;
1281:
1282: l_branch_rec hz_bank_pub.bank_rec_type;
1283: l_org_rec hz_party_v2pub.organization_rec_type;
1284: l_party_rec hz_party_v2pub.party_rec_type;
1285: l_party_number VARCHAR2(30);
1286: l_profile_id NUMBER(15);
1287: l_rel_id NUMBER(15);
1288: l_rel_party_id NUMBER(15);

Line 1570: l_org_rec hz_party_v2pub.organization_rec_type;

1566: l_branch_party_ovn NUMBER(15);
1567: l_account_ovn NUMBER(15);
1568: l_rfc_ovn NUMBER(15);
1569: l_branch_rec hz_bank_pub.bank_rec_type;
1570: l_org_rec hz_party_v2pub.organization_rec_type;
1571: l_party_rec hz_party_v2pub.party_rec_type;
1572: l_profile_id NUMBER(15);
1573: l_rel_id NUMBER(15);
1574: l_rel_party_id NUMBER(15);

Line 1571: l_party_rec hz_party_v2pub.party_rec_type;

1567: l_account_ovn NUMBER(15);
1568: l_rfc_ovn NUMBER(15);
1569: l_branch_rec hz_bank_pub.bank_rec_type;
1570: l_org_rec hz_party_v2pub.organization_rec_type;
1571: l_party_rec hz_party_v2pub.party_rec_type;
1572: l_profile_id NUMBER(15);
1573: l_rel_id NUMBER(15);
1574: l_rel_party_id NUMBER(15);
1575: l_rel_party_number NUMBER(15);