APPS.HZ_BANK_PUB dependencies on HZ_BANK_VAL_GT

Line 365: | temp table hz_bank_val_gt. |

361: | Branches to be created. |
362: | 23-JAN-2004 Rajesh Jose Modified so that updation will |
363: | insert the party_id of the |
364: | concerned bank or branch into the |
365: | temp table hz_bank_val_gt. |
366: +=======================================================================*/
367: PROCEDURE validate_bank_org (
368: p_bank_rec IN bank_rec_type,
369: p_intended_type IN VARCHAR2,

Line 486: DELETE FROM hz_bank_val_gt;

482: end if;
483: END IF;
484:
485: -- There should be no pre-existing temporary bank records.
486: DELETE FROM hz_bank_val_gt;
487: -- create the temporary bank record
488:
489: INSERT INTO hz_bank_val_gt (
490: temp_id,

Line 489: INSERT INTO hz_bank_val_gt (

485: -- There should be no pre-existing temporary bank records.
486: DELETE FROM hz_bank_val_gt;
487: -- create the temporary bank record
488:
489: INSERT INTO hz_bank_val_gt (
490: temp_id,
491: bank_or_branch_number,
492: bank_code,
493: branch_code,

Line 2588: from hz_bank_val_gt;

2584: END IF;
2585:
2586: -- Retrieving the party_id that we are using to create the bank record.
2587: select temp_id into l_bank_rec.organization_rec.party_rec.party_id
2588: from hz_bank_val_gt;
2589:
2590: -- create the organization profile.
2591: hz_party_v2pub.create_organization(
2592: p_organization_rec => l_bank_rec.organization_rec,

Line 3096: from hz_bank_val_gt;

3092:
3093: -- Retrieving the party_id that we are using to create the bank record.
3094:
3095: select temp_id into l_bank_rec.organization_rec.party_rec.party_id
3096: from hz_bank_val_gt;
3097:
3098: -- create the organization profile.
3099: hz_party_v2pub.create_organization(
3100: p_organization_rec => l_bank_rec.organization_rec,