APPS.HZ_BANK_PUB dependencies on HZ_BANK_VAL_GT

Line 377: | temp table hz_bank_val_gt. |

373: | Branches to be created. |
374: | 23-JAN-2004 Rajesh Jose Modified so that updation will |
375: | insert the party_id of the |
376: | concerned bank or branch into the |
377: | temp table hz_bank_val_gt. |
378: +=======================================================================*/
379: PROCEDURE validate_bank_org (
380: p_bank_rec IN bank_rec_type,
381: p_intended_type IN VARCHAR2,

Line 498: DELETE FROM hz_bank_val_gt;

494: end if;
495: END IF;
496:
497: -- There should be no pre-existing temporary bank records.
498: DELETE FROM hz_bank_val_gt;
499: -- create the temporary bank record
500:
501: INSERT INTO hz_bank_val_gt (
502: temp_id,

Line 501: INSERT INTO hz_bank_val_gt (

497: -- There should be no pre-existing temporary bank records.
498: DELETE FROM hz_bank_val_gt;
499: -- create the temporary bank record
500:
501: INSERT INTO hz_bank_val_gt (
502: temp_id,
503: bank_or_branch_number,
504: bank_code,
505: branch_code,

Line 2603: from hz_bank_val_gt;

2599: END IF;
2600:
2601: -- Retrieving the party_id that we are using to create the bank record.
2602: select temp_id into l_bank_rec.organization_rec.party_rec.party_id
2603: from hz_bank_val_gt;
2604:
2605: -- create the organization profile.
2606: hz_party_v2pub.create_organization(
2607: p_organization_rec => l_bank_rec.organization_rec,

Line 3111: from hz_bank_val_gt;

3107:
3108: -- Retrieving the party_id that we are using to create the bank record.
3109:
3110: select temp_id into l_bank_rec.organization_rec.party_rec.party_id
3111: from hz_bank_val_gt;
3112:
3113: -- create the organization profile.
3114: hz_party_v2pub.create_organization(
3115: p_organization_rec => l_bank_rec.organization_rec,