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 221: l_org_rec hz_party_v2pub.organization_rec_type;

217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2
219: ) IS
220: l_bank_rec hz_bank_pub.bank_rec_type;
221: l_org_rec hz_party_v2pub.organization_rec_type;
222: l_party_rec hz_party_v2pub.party_rec_type;
223: l_party_number VARCHAR2(30);
224: l_profile_id NUMBER(15);
225: l_code_assignment_id NUMBER(15);

Line 222: l_party_rec hz_party_v2pub.party_rec_type;

218: x_msg_data OUT NOCOPY VARCHAR2
219: ) IS
220: l_bank_rec hz_bank_pub.bank_rec_type;
221: l_org_rec hz_party_v2pub.organization_rec_type;
222: l_party_rec hz_party_v2pub.party_rec_type;
223: l_party_number VARCHAR2(30);
224: l_profile_id NUMBER(15);
225: l_code_assignment_id NUMBER(15);
226: l_bank_number VARCHAR2(30);

Line 452: l_org_rec hz_party_v2pub.organization_rec_type;

448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2
450: ) IS
451: l_bank_rec hz_bank_pub.bank_rec_type;
452: l_org_rec hz_party_v2pub.organization_rec_type;
453: l_party_rec hz_party_v2pub.party_rec_type;
454: l_profile_id NUMBER(15);
455: l_ca_object_version_number NUMBER(15);
456: l_country_code VARCHAR2(60);

Line 453: l_party_rec hz_party_v2pub.party_rec_type;

449: x_msg_data OUT NOCOPY VARCHAR2
450: ) IS
451: l_bank_rec hz_bank_pub.bank_rec_type;
452: l_org_rec hz_party_v2pub.organization_rec_type;
453: l_party_rec hz_party_v2pub.party_rec_type;
454: l_profile_id NUMBER(15);
455: l_ca_object_version_number NUMBER(15);
456: l_country_code VARCHAR2(60);
457: l_bank_number VARCHAR2(30);

Line 683: l_org_rec hz_party_v2pub.organization_rec_type;

679: l_branch_end DATE;
680: l_bank_ovn NUMBER(15);
681: l_branch_ovn NUMBER(15);
682: l_bank_rec hz_bank_pub.bank_rec_type;
683: l_org_rec hz_party_v2pub.organization_rec_type;
684: l_party_rec hz_party_v2pub.party_rec_type;
685: l_profile_id NUMBER(15);
686: BEGIN
687: SAVEPOINT set_bank_end_date;

Line 684: l_party_rec hz_party_v2pub.party_rec_type;

680: l_bank_ovn NUMBER(15);
681: l_branch_ovn NUMBER(15);
682: l_bank_rec hz_bank_pub.bank_rec_type;
683: l_org_rec hz_party_v2pub.organization_rec_type;
684: l_party_rec hz_party_v2pub.party_rec_type;
685: l_profile_id NUMBER(15);
686: BEGIN
687: SAVEPOINT set_bank_end_date;
688:

Line 1010: l_org_rec hz_party_v2pub.organization_rec_type;

1006: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
1007: AND hz_p.party_id = p_bank_id;
1008:
1009: l_branch_rec hz_bank_pub.bank_rec_type;
1010: l_org_rec hz_party_v2pub.organization_rec_type;
1011: l_party_rec hz_party_v2pub.party_rec_type;
1012: l_party_number VARCHAR2(30);
1013: l_profile_id NUMBER(15);
1014: l_rel_id NUMBER(15);

Line 1011: l_party_rec hz_party_v2pub.party_rec_type;

1007: AND hz_p.party_id = p_bank_id;
1008:
1009: l_branch_rec hz_bank_pub.bank_rec_type;
1010: l_org_rec hz_party_v2pub.organization_rec_type;
1011: l_party_rec hz_party_v2pub.party_rec_type;
1012: l_party_number VARCHAR2(30);
1013: l_profile_id NUMBER(15);
1014: l_rel_id NUMBER(15);
1015: l_rel_party_id NUMBER(15);

Line 1340: l_org_rec hz_party_v2pub.organization_rec_type;

1336: AND owner_table_name = 'HZ_PARTIES'
1337: AND owner_table_id = p_branch_id;
1338:
1339: l_branch_rec hz_bank_pub.bank_rec_type;
1340: l_org_rec hz_party_v2pub.organization_rec_type;
1341: l_party_rec hz_party_v2pub.party_rec_type;
1342: l_party_number VARCHAR2(30);
1343: l_profile_id NUMBER(15);
1344: l_rel_id NUMBER(15);

Line 1341: l_party_rec hz_party_v2pub.party_rec_type;

1337: AND owner_table_id = p_branch_id;
1338:
1339: l_branch_rec hz_bank_pub.bank_rec_type;
1340: l_org_rec hz_party_v2pub.organization_rec_type;
1341: l_party_rec hz_party_v2pub.party_rec_type;
1342: l_party_number VARCHAR2(30);
1343: l_profile_id NUMBER(15);
1344: l_rel_id NUMBER(15);
1345: l_rel_party_id NUMBER(15);

Line 1667: l_org_rec hz_party_v2pub.organization_rec_type;

1663: l_bank_ovn NUMBER(15);
1664: l_branch_party_ovn NUMBER(15);
1665: l_rfc_ovn NUMBER(15);
1666: l_branch_rec hz_bank_pub.bank_rec_type;
1667: l_org_rec hz_party_v2pub.organization_rec_type;
1668: l_party_rec hz_party_v2pub.party_rec_type;
1669: l_profile_id NUMBER(15);
1670: l_rel_id NUMBER(15);
1671: l_rel_party_id NUMBER(15);

Line 1668: l_party_rec hz_party_v2pub.party_rec_type;

1664: l_branch_party_ovn NUMBER(15);
1665: l_rfc_ovn NUMBER(15);
1666: l_branch_rec hz_bank_pub.bank_rec_type;
1667: l_org_rec hz_party_v2pub.organization_rec_type;
1668: l_party_rec hz_party_v2pub.party_rec_type;
1669: l_profile_id NUMBER(15);
1670: l_rel_id NUMBER(15);
1671: l_rel_party_id NUMBER(15);
1672: l_rel_party_number NUMBER(15);