APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_IMP_LOAD_WRAPPER

Line 198: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

194: PROCEDURE disable_debug;
195: */
196:
197: PROCEDURE open_update_cursor (update_cursor IN OUT NOCOPY update_cursor_type,
198: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
199: );
200:
201: PROCEDURE process_insert_addresses (
202: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

Line 202: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

198: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
199: );
200:
201: PROCEDURE process_insert_addresses (
202: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2
206: );

Line 209: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

205: x_msg_data OUT NOCOPY VARCHAR2
206: );
207:
208: PROCEDURE populate_error_table(
209: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
210: P_DUP_VAL_EXP IN VARCHAR2,
211: P_SQL_ERRM IN VARCHAR2 );
212:
213: PROCEDURE process_update_addresses (

Line 214: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

210: P_DUP_VAL_EXP IN VARCHAR2,
211: P_SQL_ERRM IN VARCHAR2 );
212:
213: PROCEDURE process_update_addresses (
214: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2
218: );

Line 221: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

217: x_msg_data OUT NOCOPY VARCHAR2
218: );
219:
220: PROCEDURE report_errors(
221: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
222: P_DML_EXCEPTION IN VARCHAR2);
223:
224: PROCEDURE sync_party_tax_profile
225: ( P_BATCH_ID IN NUMBER,

Line 310: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

306: END validate_desc_flexfield_f;
307:
308:
309: PROCEDURE load_addresses (
310: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
311: P_UPDATE_STR_ADDR IN VARCHAR2,
312: P_MAINTAIN_LOC_HIST IN VARCHAR2,
313: P_ALLOW_ADDR_CORR IN VARCHAR2,
314: x_return_status OUT NOCOPY VARCHAR2,

Line 462: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

458: END load_addresses;
459:
460:
461: PROCEDURE process_insert_addresses (
462: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2
466: ) IS

Line 1215: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

1211: end process_insert_addresses;
1212:
1213:
1214: PROCEDURE populate_error_table(
1215: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
1216: P_DUP_VAL_EXP IN VARCHAR2,
1217: P_SQL_ERRM IN VARCHAR2 ) IS
1218:
1219: dup_val_exp_val VARCHAR2(1) := null;

Line 1298: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

1294: END populate_error_table;
1295:
1296:
1297: PROCEDURE open_update_cursor (update_cursor IN OUT NOCOPY update_cursor_type,
1298: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
1299: ) IS
1300:
1301: /* Note: Is it a problem to generate foreign key party site, location id */
1302: /* here for move? Many ids from sequence would be lost. */

Line 1951: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

1947: END validate_DSS_security;
1948:
1949:
1950: PROCEDURE process_update_addresses (
1951: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
1952: x_return_status OUT NOCOPY VARCHAR2,
1953: x_msg_count OUT NOCOPY NUMBER,
1954: x_msg_data OUT NOCOPY VARCHAR2
1955: ) IS

Line 3037: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

3033: end process_update_addresses;
3034:
3035:
3036: PROCEDURE report_errors(
3037: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
3038: P_DML_EXCEPTION IN VARCHAR2
3039: ) IS
3040: num_exp NUMBER;
3041: exp_ind NUMBER := 1;