123: *
124: **********************************************/
125:
126: PROCEDURE report_errors(
127: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
128: P_ACTION IN VARCHAR2,
129: P_DML_EXCEPTION IN VARCHAR2
130: ) IS
131: l_error_id HZ_IMP_CLASSIFICS_INT.ERROR_ID%TYPE;
254: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
255: *
256: * ARGUMENTS
257: * IN:
258: * P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
259: * P_DUP_VAL_EXP IN VARCHAR2
260: * P_SQL_ERRM IN VARCHAR2
261: *
262: * OUT
268: *
269: ********************************************************************************/
270:
271: PROCEDURE populate_error_table(
272: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
273: P_DUP_VAL_EXP IN VARCHAR2,
274: P_SQL_ERRM IN VARCHAR2 ) IS
275:
276: dup_val_exp_val VARCHAR2(1) := null;
359: *
360: ********************************************************************************/
361:
362: PROCEDURE process_insert_code_assignment (
363: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
364: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
365: ,X_MSG_COUNT OUT NOCOPY NUMBER
366: ,X_MSG_DATA OUT NOCOPY VARCHAR2
367: ) IS
1071: *
1072: ********************************************************************************/
1073:
1074: PROCEDURE process_update_code_assignment (
1075: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
1076: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1077: ,X_MSG_COUNT OUT NOCOPY NUMBER
1078: ,X_MSG_DATA OUT NOCOPY VARCHAR2
1079: ) IS
1293: *
1294: ********************************************************************************/
1295:
1296: PROCEDURE load_code_assignments (
1297: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
1298: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1299: ,X_MSG_COUNT OUT NOCOPY NUMBER
1300: ,X_MSG_DATA OUT NOCOPY VARCHAR2
1301: ) IS