APPS.HZ_IMP_LOAD_FINNUMBERS_PKG dependencies on HZ_IMP_LOAD_WRAPPER

Line 32: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE );

28: l_createdby_errors LOOKUP_ERROR;
29:
30: PROCEDURE open_update_cursor (
31: update_cursor IN OUT NOCOPY update_cursor_type,
32: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE );
33:
34:
35: PROCEDURE process_insert_finnumbers (
36: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

Line 36: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

32: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE );
33:
34:
35: PROCEDURE process_insert_finnumbers (
36: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2 );
40:

Line 43: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

39: x_msg_data OUT NOCOPY VARCHAR2 );
40:
41:
42: PROCEDURE process_update_finnumbers (
43: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2 );
47:

Line 50: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

46: x_msg_data OUT NOCOPY VARCHAR2 );
47:
48:
49: PROCEDURE report_errors(
50: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
51: P_DML_EXCEPTION IN VARCHAR2);
52:
53:
54: PROCEDURE populate_error_table(

Line 55: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

51: P_DML_EXCEPTION IN VARCHAR2);
52:
53:
54: PROCEDURE populate_error_table(
55: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
56: P_DUP_VAL_EXP IN VARCHAR2 );
57:
58: --------------------------------------
59: -- forward declaration of private procedures and functions

Line 67: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

63: PROCEDURE disable_debug;
64: */
65:
66: PROCEDURE load_finnumbers (
67: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2 )
71: IS

Line 156: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE) IS

152: END load_finnumbers;
153:
154:
155: PROCEDURE open_update_cursor ( update_cursor IN OUT NOCOPY update_cursor_type,
156: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE) IS
157: l_sql_query VARCHAR2(11000) :=
158: 'SELECT fn_int.ROWID,
159: fn_sg.action_flag,
160: fn_sg.financial_report_id,

Line 213: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

209: END open_update_cursor;
210:
211:
212: PROCEDURE process_insert_finnumbers (
213: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2 ) IS
217:

Line 456: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

452: END process_insert_finnumbers;
453:
454:
455: PROCEDURE populate_error_table(
456: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
457: P_DUP_VAL_EXP IN VARCHAR2 ) IS
458:
459: dup_val_exp_val VARCHAR2(1) := null;
460: other_exp_val VARCHAR2(1) := 'Y';

Line 531: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

527: END populate_error_table;
528:
529:
530: PROCEDURE process_update_finnumbers (
531: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
532: x_return_status OUT NOCOPY VARCHAR2,
533: x_msg_count OUT NOCOPY NUMBER,
534: x_msg_data OUT NOCOPY VARCHAR2 ) IS
535: c_update_cursor update_cursor_type;

Line 614: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

610: END process_update_finnumbers;
611:
612:
613: PROCEDURE report_errors(
614: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
615: P_DML_EXCEPTION IN VARCHAR2
616: ) IS
617:
618: num_exp NUMBER;