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_BANK_PUB

Line 123: | hz_bank_pub.create_bank |

119: | DESCRIPTION |
120: | Create a bank as a TCA organization party. |
121: | |
122: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
123: | hz_bank_pub.create_bank |
124: | |
125: | ARGUMENTS |
126: | IN: |
127: | p_init_msg_list Initialize message stack if it is set to |

Line 190: l_bank_rec hz_bank_pub.bank_rec_type;

186: x_return_status OUT NOCOPY VARCHAR2,
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);

Line 285: hz_bank_pub.create_bank(fnd_api.g_false, l_bank_rec, x_bank_id, l_party_number,

281: if (l_gen_party_num = 'N') then
282: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
283: end if;
284:
285: hz_bank_pub.create_bank(fnd_api.g_false, l_bank_rec, x_bank_id, l_party_number,
286: l_profile_id, l_code_assignment_id,
287: x_return_status, x_msg_count, x_msg_data);
288:
289: if (l_gen_party_num = 'N') then

Line 354: | hz_bank_pub.update_bank |

350: | DESCRIPTION |
351: | Update a bank organization. |
352: | |
353: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
354: | hz_bank_pub.update_bank |
355: | |
356: | ARGUMENTS |
357: | IN: |
358: | p_init_msg_list Initialize message stack if it is set to |

Line 421: l_bank_rec hz_bank_pub.bank_rec_type;

417: x_return_status OUT NOCOPY VARCHAR2,
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);

Line 525: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,

521: AND owner_table_name = 'HZ_PARTIES'
522: AND owner_table_id = p_bank_id
523: AND status = 'A';
524:
525: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,
526: p_object_version_number, l_ca_object_version_number,
527: l_profile_id, x_return_status, x_msg_count, x_msg_data);
528:
529: -- raise an exception if error updating a bank

Line 590: | hz_bank_pub.update_bank |

586: | DESCRIPTION |
587: | Set the end date of a bank. |
588: | |
589: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
590: | hz_bank_pub.update_bank |
591: | |
592: | ARGUMENTS |
593: | IN: |
594: | p_init_msg_list Initialize message stack if it is set to |

Line 654: l_bank_rec hz_bank_pub.bank_rec_type;

650: l_bank_end DATE;
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

Line 741: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,

737: RAISE fnd_api.g_exc_error;
738: END IF;
739: CLOSE c_bank_ovn;
740:
741: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,
742: l_bank_ovn, p_object_version_number,
743: l_profile_id, x_return_status, x_msg_count, x_msg_data);
744:
745: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 902: | hz_bank_pub.create_bank_branch |

898: | DESCRIPTION |
899: | Create a bank branch as a TCA organization party. |
900: | |
901: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
902: | hz_bank_pub.create_bank_branch |
903: | |
904: | ARGUMENTS |
905: | IN: |
906: | p_init_msg_list Initialize message stack if it is set to |

Line 981: l_branch_rec hz_bank_pub.bank_rec_type;

977: AND SYSDATE between TRUNC(hz_org.effective_start_date)
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);

Line 1105: hz_bank_pub.create_bank_branch(fnd_api.g_false, l_branch_rec, p_bank_id,

1101: if (l_gen_party_num = 'N') then
1102: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
1103: end if;
1104:
1105: hz_bank_pub.create_bank_branch(fnd_api.g_false, l_branch_rec, p_bank_id,
1106: x_branch_id, l_party_number,
1107: l_profile_id, l_rel_id,
1108: l_rel_party_id, l_rel_party_number,
1109: l_bch_code_assignment_id, l_typ_code_assignment_id,

Line 1198: | hz_bank_pub.update_bank_branch |

1194: | DESCRIPTION |
1195: | Update a bank branch organization party in TCA. |
1196: | |
1197: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1198: | hz_bank_pub.update_bank_branch |
1199: | |
1200: | ARGUMENTS |
1201: | IN: |
1202: | p_init_msg_list Initialize message stack if it is set to |

Line 1282: l_branch_rec hz_bank_pub.bank_rec_type;

1278: WHERE contact_point_type = 'EFT'
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);

Line 1387: hz_bank_pub.update_bank_branch(fnd_api.g_false, l_branch_rec, null,

1383: l_branch_rec.branch_type := p_branch_type;
1384: l_branch_rec.rfc_code := p_rfc_identifier;
1385: l_branch_rec.organization_rec := l_org_rec;
1386:
1387: hz_bank_pub.update_bank_branch(fnd_api.g_false, l_branch_rec, null,
1388: l_rel_id,
1389: p_bch_object_version_number, p_typ_object_version_number,
1390: p_rfc_object_version_number,
1391: l_profile_id, l_rel_party_id, l_rel_party_number,

Line 1491: | hz_bank_pub.update_bank |

1487: | DESCRIPTION |
1488: | Set the end date of a bank branch. |
1489: | |
1490: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1491: | hz_bank_pub.update_bank |
1492: | |
1493: | ARGUMENTS |
1494: | IN: |
1495: | p_init_msg_list Initialize message stack if it is set to |

Line 1569: l_branch_rec hz_bank_pub.bank_rec_type;

1565: l_bank_ovn NUMBER(15);
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);

Line 1704: hz_bank_pub.update_bank_branch(fnd_api.g_false, l_branch_rec, null,

1700: l_rfc_ovn := null;
1701: END IF;
1702: CLOSE c_rfc_ovn;
1703:
1704: hz_bank_pub.update_bank_branch(fnd_api.g_false, l_branch_rec, null,
1705: l_rel_id,
1706: l_branch_party_ovn, p_object_version_number,
1707: l_rfc_ovn,
1708: l_profile_id, l_rel_party_id, l_rel_party_number,