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: *
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,
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
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: )
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
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';
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:
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,
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,
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,
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,
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,
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
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
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
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,
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
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
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:
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,
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
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
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:
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;