236:
237:
238: /* Only used when updating parties */
239: PROCEDURE report_errors(
240: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
241: P_ACTION IN VARCHAR2,
242: P_DML_EXCEPTION IN VARCHAR2
243: ) IS
244: num_exp NUMBER;
355:
356: /* Populate error table when exception happens during updating or
357: inserting parties. */
358: PROCEDURE populate_error_table(
359: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
360: P_DUP_VAL_EXP IN VARCHAR2,
361: P_SQL_ERRM IN VARCHAR2 ) IS
362:
363: dup_val_exp_val VARCHAR2(1) := null;
448: *
449: ********************************************************************************/
450:
451: PROCEDURE process_insert_rels (
452: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
453: ,x_return_status OUT NOCOPY VARCHAR2
454: ,x_msg_count OUT NOCOPY NUMBER
455: ,x_msg_data OUT NOCOPY VARCHAR2
456: ) IS
1332: *
1333: ********************************************************************************/
1334:
1335: PROCEDURE process_update_rels (
1336: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
1337: ,x_return_status OUT NOCOPY VARCHAR2
1338: ,x_msg_count OUT NOCOPY NUMBER
1339: ,x_msg_data OUT NOCOPY VARCHAR2
1340: ) IS
1686: *
1687: ********************************************************************************/
1688:
1689: PROCEDURE load_relationships (
1690: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
1691: ,x_return_status OUT NOCOPY VARCHAR2
1692: ,x_msg_count OUT NOCOPY NUMBER
1693: ,x_msg_data OUT NOCOPY VARCHAR2
1694: ) IS