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:
44: /**
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:
44: /**
45: * PROCEDURE getColumnNullProperty
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:
74: /**
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:
74: /**
75: * PROCEDURE createSSTRecord
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:
106: /**
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:
106: /**
107: * PROCEDURE updateSSTRecord
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
143: );
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
143: );
144:
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
143: );
144:
145: /**
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
143: );
144:
145: /**
146: * PROCEDURE initAttributeList
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:
181: /**
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:
181: /**
182: * PROCEDURE getColumnNullProperty
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:
211: /**
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:
211: /**
212: * PROCEDURE createSSTRecord
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:
243: /**
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:
243: /**
244: * PROCEDURE updateSSTRecord
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
280: );
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
280: );
281:
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
280: );
281:
282: END HZ_MIXNM_API_DYNAMIC_PKG;
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
280: );
281:
282: END HZ_MIXNM_API_DYNAMIC_PKG;