34: */
35:
36: PROCEDURE initAttributeList (
37: p_create_update_flag IN VARCHAR2,
38: p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
39: p_old_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
40: x_name_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
41: x_new_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
42: );
35:
36: PROCEDURE initAttributeList (
37: p_create_update_flag IN VARCHAR2,
38: p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
39: p_old_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
40: x_name_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
41: x_new_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
42: );
43:
65: * 05-01-2002 Jianying Huang o Created
66: */
67:
68: PROCEDURE getColumnNullProperty (
69: p_sst_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
70: x_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
71: x_value_is_not_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
72: );
73:
96: */
97:
98: PROCEDURE createSSTRecord (
99: p_new_data_source IN VARCHAR2,
100: p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
101: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
102: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
103: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
104: );
97:
98: PROCEDURE createSSTRecord (
99: p_new_data_source IN VARCHAR2,
100: p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
101: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
102: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
103: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
104: );
105:
133: PROCEDURE updateSSTRecord (
134: -- Bug 4201309 : add parameter p_create_update_flag
135: p_create_update_flag IN VARCHAR2,
136: p_new_data_source IN VARCHAR2,
137: p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
138: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
139: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
140: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
141: p_new_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
134: -- Bug 4201309 : add parameter p_create_update_flag
135: p_create_update_flag IN VARCHAR2,
136: p_new_data_source IN VARCHAR2,
137: p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
138: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
139: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
140: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
141: p_new_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
142: x_data_source_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
171: */
172:
173: PROCEDURE initAttributeList (
174: p_create_update_flag IN VARCHAR2,
175: p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
176: p_old_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
177: x_name_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
178: x_new_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
179: );
172:
173: PROCEDURE initAttributeList (
174: p_create_update_flag IN VARCHAR2,
175: p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
176: p_old_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
177: x_name_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
178: x_new_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
179: );
180:
202: * 05-01-2002 Jianying Huang o Created
203: */
204:
205: PROCEDURE getColumnNullProperty (
206: p_sst_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
207: x_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
208: x_value_is_not_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
209: );
210:
233: */
234:
235: PROCEDURE createSSTRecord (
236: p_new_data_source IN VARCHAR2,
237: p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
238: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
239: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
240: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
241: );
234:
235: PROCEDURE createSSTRecord (
236: p_new_data_source IN VARCHAR2,
237: p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
238: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
239: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
240: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
241: );
242:
270: PROCEDURE updateSSTRecord (
271: -- Bug 4201309 : add parameter p_create_update_flag
272: p_create_update_flag IN VARCHAR2,
273: p_new_data_source IN VARCHAR2,
274: p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
275: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
276: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
277: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
278: p_new_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
271: -- Bug 4201309 : add parameter p_create_update_flag
272: p_create_update_flag IN VARCHAR2,
273: p_new_data_source IN VARCHAR2,
274: p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
275: p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
276: p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
277: p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
278: p_new_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
279: x_data_source_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List