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

Line 2729: * This will be called only from HZ_PARTY_V2PUB.do_create_party.

2725: *
2726: * OUT:
2727: *
2728: * NOTES
2729: * This will be called only from HZ_PARTY_V2PUB.do_create_party.
2730: * And only when a new party is created by a non-user_entered source system.
2731: *
2732: * MODIFICATION HISTORY
2733: *

Line 2739: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE

2735: */
2736:
2737: PROCEDURE create_exceptions (
2738: p_party_type IN VARCHAR2,
2739: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2740: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2741: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2742: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2743: p_third_party_content_source IN VARCHAR2,

Line 2740: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,

2736:
2737: PROCEDURE create_exceptions (
2738: p_party_type IN VARCHAR2,
2739: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2740: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2741: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2742: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2743: p_third_party_content_source IN VARCHAR2,
2744: p_party_id IN NUMBER

Line 2741: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE

2737: PROCEDURE create_exceptions (
2738: p_party_type IN VARCHAR2,
2739: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2740: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2741: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2742: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2743: p_third_party_content_source IN VARCHAR2,
2744: p_party_id IN NUMBER
2745: )

Line 2742: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,

2738: p_party_type IN VARCHAR2,
2739: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2740: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2741: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2742: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2743: p_third_party_content_source IN VARCHAR2,
2744: p_party_id IN NUMBER
2745: )
2746: IS

Line 2769: p_old_rec => HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,

2765:
2766: HZ_MIXNM_API_DYNAMIC_PKG.initAttributeList
2767: (p_create_update_flag => 'C',
2768: p_new_rec => p_organization_rec,
2769: p_old_rec => HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2770: x_name_list => l_name_list,
2771: x_new_value_is_null_list => l_null_list);
2772:
2773: l_entity_name := 'HZ_ORGANIZATION_PROFILES';

Line 2780: p_old_rec => HZ_PARTY_V2PUB.G_MISS_PERSON_REC,

2776:
2777: HZ_MIXNM_API_DYNAMIC_PKG.initAttributeList
2778: (p_create_update_flag => 'C',
2779: p_new_rec => p_person_rec,
2780: p_old_rec => HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2781: x_name_list => l_name_list,
2782: x_new_value_is_null_list => l_null_list);
2783:
2784:

Line 3792: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3788: p_create_update_sst_flag IN VARCHAR2,
3789: p_raise_error_flag IN VARCHAR2,
3790: p_party_type IN VARCHAR2,
3791: p_party_id IN NUMBER,
3792: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3789: p_raise_error_flag IN VARCHAR2,
3790: p_party_type IN VARCHAR2,
3791: p_party_id IN NUMBER,
3792: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3790: p_party_type IN VARCHAR2,
3791: p_party_id IN NUMBER,
3792: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3791: p_party_id IN NUMBER,
3792: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3799: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3792: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3799: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3800: p_data_source_type IN VARCHAR2,

Line 3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3793: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3799: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3800: p_data_source_type IN VARCHAR2,
3801: x_return_status IN OUT NOCOPY VARCHAR2

Line 3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3794: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3799: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3800: p_data_source_type IN VARCHAR2,
3801: x_return_status IN OUT NOCOPY VARCHAR2
3802: ) IS

Line 3799: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3795: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3796: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3797: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3798: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3799: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3800: p_data_source_type IN VARCHAR2,
3801: x_return_status IN OUT NOCOPY VARCHAR2
3802: ) IS
3803: BEGIN

Line 3870: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3866: p_create_update_flag IN VARCHAR2,
3867: p_create_update_sst_flag IN VARCHAR2,
3868: p_raise_error_flag IN VARCHAR2,
3869: p_party_id IN NUMBER,
3870: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3871: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3872: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3873: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3874: p_data_source_type IN VARCHAR2,

Line 3871: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3867: p_create_update_sst_flag IN VARCHAR2,
3868: p_raise_error_flag IN VARCHAR2,
3869: p_party_id IN NUMBER,
3870: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3871: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3872: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3873: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3874: p_data_source_type IN VARCHAR2,
3875: x_return_status IN OUT NOCOPY VARCHAR2

Line 3872: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3868: p_raise_error_flag IN VARCHAR2,
3869: p_party_id IN NUMBER,
3870: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3871: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3872: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3873: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3874: p_data_source_type IN VARCHAR2,
3875: x_return_status IN OUT NOCOPY VARCHAR2
3876: ) IS

Line 3873: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3869: p_party_id IN NUMBER,
3870: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3871: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3872: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3873: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3874: p_data_source_type IN VARCHAR2,
3875: x_return_status IN OUT NOCOPY VARCHAR2
3876: ) IS
3877:

Line 4055: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4051: p_create_update_flag IN VARCHAR2,
4052: p_create_update_sst_flag IN VARCHAR2,
4053: p_raise_error_flag IN VARCHAR2,
4054: p_party_id IN NUMBER,
4055: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4056: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4057: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4058: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4059: p_data_source_type IN VARCHAR2,

Line 4056: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4052: p_create_update_sst_flag IN VARCHAR2,
4053: p_raise_error_flag IN VARCHAR2,
4054: p_party_id IN NUMBER,
4055: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4056: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4057: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4058: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4059: p_data_source_type IN VARCHAR2,
4060: x_return_status IN OUT NOCOPY VARCHAR2

Line 4057: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4053: p_raise_error_flag IN VARCHAR2,
4054: p_party_id IN NUMBER,
4055: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4056: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4057: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4058: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4059: p_data_source_type IN VARCHAR2,
4060: x_return_status IN OUT NOCOPY VARCHAR2
4061: ) IS

Line 4058: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4054: p_party_id IN NUMBER,
4055: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4056: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4057: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4058: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4059: p_data_source_type IN VARCHAR2,
4060: x_return_status IN OUT NOCOPY VARCHAR2
4061: ) IS
4062:

Line 4063: l_new_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := p_new_organization_rec;

4059: p_data_source_type IN VARCHAR2,
4060: x_return_status IN OUT NOCOPY VARCHAR2
4061: ) IS
4062:
4063: l_new_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := p_new_organization_rec;
4064: l_new_value_is_null_list INDEXVARCHAR1List;
4065: l_sst_value_is_null_list INDEXVARCHAR1List;
4066: l_sst_value_is_not_null_list INDEXVARCHAR1List;
4067: l_updatable_flag_list INDEXVARCHAR1List;