DBA Data[Home] [Help]

APPS.HZ_MIXNM_UTILITY dependencies on HZ_PARTY_V2PUB

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

2715: *
2716: * OUT:
2717: *
2718: * NOTES
2719: * This will be called only from HZ_PARTY_V2PUB.do_create_party.
2720: * And only when a new party is created by a non-user_entered source system.
2721: *
2722: * MODIFICATION HISTORY
2723: *

Line 2729: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE

2725: */
2726:
2727: PROCEDURE create_exceptions (
2728: p_party_type IN VARCHAR2,
2729: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2730: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2731: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2732: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2733: p_third_party_content_source IN VARCHAR2,

Line 2730: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,

2726:
2727: PROCEDURE create_exceptions (
2728: p_party_type IN VARCHAR2,
2729: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2730: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2731: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2732: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2733: p_third_party_content_source IN VARCHAR2,
2734: p_party_id IN NUMBER

Line 2731: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE

2727: PROCEDURE create_exceptions (
2728: p_party_type IN VARCHAR2,
2729: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2730: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2731: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2732: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2733: p_third_party_content_source IN VARCHAR2,
2734: p_party_id IN NUMBER
2735: )

Line 2732: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,

2728: p_party_type IN VARCHAR2,
2729: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
2730: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2731: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
2732: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2733: p_third_party_content_source IN VARCHAR2,
2734: p_party_id IN NUMBER
2735: )
2736: IS

Line 2759: p_old_rec => HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,

2755:
2756: HZ_MIXNM_API_DYNAMIC_PKG.initAttributeList
2757: (p_create_update_flag => 'C',
2758: p_new_rec => p_organization_rec,
2759: p_old_rec => HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2760: x_name_list => l_name_list,
2761: x_new_value_is_null_list => l_null_list);
2762:
2763: l_entity_name := 'HZ_ORGANIZATION_PROFILES';

Line 2770: p_old_rec => HZ_PARTY_V2PUB.G_MISS_PERSON_REC,

2766:
2767: HZ_MIXNM_API_DYNAMIC_PKG.initAttributeList
2768: (p_create_update_flag => 'C',
2769: p_new_rec => p_person_rec,
2770: p_old_rec => HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
2771: x_name_list => l_name_list,
2772: x_new_value_is_null_list => l_null_list);
2773:
2774:

Line 3782: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3778: p_create_update_sst_flag IN VARCHAR2,
3779: p_raise_error_flag IN VARCHAR2,
3780: p_party_type IN VARCHAR2,
3781: p_party_id IN NUMBER,
3782: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3779: p_raise_error_flag IN VARCHAR2,
3780: p_party_type IN VARCHAR2,
3781: p_party_id IN NUMBER,
3782: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3780: p_party_type IN VARCHAR2,
3781: p_party_id IN NUMBER,
3782: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3781: p_party_id IN NUMBER,
3782: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3789: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

Line 3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3782: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3789: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3790: p_data_source_type IN VARCHAR2,

Line 3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3783: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3789: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3790: p_data_source_type IN VARCHAR2,
3791: x_return_status IN OUT NOCOPY VARCHAR2

Line 3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3784: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3789: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3790: p_data_source_type IN VARCHAR2,
3791: x_return_status IN OUT NOCOPY VARCHAR2
3792: ) IS

Line 3789: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

3785: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3786: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3787: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3788: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3789: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
3790: p_data_source_type IN VARCHAR2,
3791: x_return_status IN OUT NOCOPY VARCHAR2
3792: ) IS
3793: BEGIN

Line 3860: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3856: p_create_update_flag IN VARCHAR2,
3857: p_create_update_sst_flag IN VARCHAR2,
3858: p_raise_error_flag IN VARCHAR2,
3859: p_party_id IN NUMBER,
3860: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3861: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3862: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3863: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3864: p_data_source_type IN VARCHAR2,

Line 3861: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3857: p_create_update_sst_flag IN VARCHAR2,
3858: p_raise_error_flag IN VARCHAR2,
3859: p_party_id IN NUMBER,
3860: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3861: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3862: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3863: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3864: p_data_source_type IN VARCHAR2,
3865: x_return_status IN OUT NOCOPY VARCHAR2

Line 3862: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3858: p_raise_error_flag IN VARCHAR2,
3859: p_party_id IN NUMBER,
3860: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3861: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3862: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3863: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3864: p_data_source_type IN VARCHAR2,
3865: x_return_status IN OUT NOCOPY VARCHAR2
3866: ) IS

Line 3863: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3859: p_party_id IN NUMBER,
3860: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3861: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3862: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3863: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3864: p_data_source_type IN VARCHAR2,
3865: x_return_status IN OUT NOCOPY VARCHAR2
3866: ) IS
3867:

Line 4045: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4041: p_create_update_flag IN VARCHAR2,
4042: p_create_update_sst_flag IN VARCHAR2,
4043: p_raise_error_flag IN VARCHAR2,
4044: p_party_id IN NUMBER,
4045: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4046: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4047: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4048: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4049: p_data_source_type IN VARCHAR2,

Line 4046: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4042: p_create_update_sst_flag IN VARCHAR2,
4043: p_raise_error_flag IN VARCHAR2,
4044: p_party_id IN NUMBER,
4045: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4046: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4047: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4048: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4049: p_data_source_type IN VARCHAR2,
4050: x_return_status IN OUT NOCOPY VARCHAR2

Line 4047: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4043: p_raise_error_flag IN VARCHAR2,
4044: p_party_id IN NUMBER,
4045: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4046: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4047: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4048: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4049: p_data_source_type IN VARCHAR2,
4050: x_return_status IN OUT NOCOPY VARCHAR2
4051: ) IS

Line 4048: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4044: p_party_id IN NUMBER,
4045: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4046: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4047: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4048: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4049: p_data_source_type IN VARCHAR2,
4050: x_return_status IN OUT NOCOPY VARCHAR2
4051: ) IS
4052:

Line 4053: l_new_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := p_new_organization_rec;

4049: p_data_source_type IN VARCHAR2,
4050: x_return_status IN OUT NOCOPY VARCHAR2
4051: ) IS
4052:
4053: l_new_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := p_new_organization_rec;
4054: l_new_value_is_null_list INDEXVARCHAR1List;
4055: l_sst_value_is_null_list INDEXVARCHAR1List;
4056: l_sst_value_is_not_null_list INDEXVARCHAR1List;
4057: l_updatable_flag_list INDEXVARCHAR1List;