APPS.HZ_IMP_LOAD_FINREPORTS_PKG dependencies on HZ_IMP_LOAD_WRAPPER

Line 73: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

69: PROCEDURE disable_debug;
70: */
71:
72: PROCEDURE process_insert_reports (
73: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2 );
77:

Line 79: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2 );
77:
78: PROCEDURE process_update_reports (
79: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2 );
83:

Line 86: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE);

82: x_msg_data OUT NOCOPY VARCHAR2 );
83:
84: PROCEDURE open_update_cursor (
85: update_cursor IN OUT NOCOPY update_cursor_type,
86: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE);
87:
88: PROCEDURE report_errors(
89: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
90: P_DML_EXCEPTION IN VARCHAR2);

Line 89: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

85: update_cursor IN OUT NOCOPY update_cursor_type,
86: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE);
87:
88: PROCEDURE report_errors(
89: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
90: P_DML_EXCEPTION IN VARCHAR2);
91:
92: PROCEDURE populate_error_table(
93: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

Line 93: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

89: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
90: P_DML_EXCEPTION IN VARCHAR2);
91:
92: PROCEDURE populate_error_table(
93: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
94: P_DUP_VAL_EXP IN VARCHAR2,
95: P_SQL_ERRM IN VARCHAR2 );
96:
97: PROCEDURE load_finreports (

Line 98: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

94: P_DUP_VAL_EXP IN VARCHAR2,
95: P_SQL_ERRM IN VARCHAR2 );
96:
97: PROCEDURE load_finreports (
98: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2 )
102: IS

Line 190: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

186: END load_finreports;
187:
188:
189: PROCEDURE process_insert_reports (
190: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2 ) IS
194:

Line 558: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

554: END process_insert_reports;
555:
556:
557: PROCEDURE populate_error_table(
558: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
559: P_DUP_VAL_EXP IN VARCHAR2,
560: P_SQL_ERRM IN VARCHAR2 ) IS
561:
562: dup_val_exp_val VARCHAR2(1) := null;

Line 646: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

642: END populate_error_table;
643:
644:
645: PROCEDURE process_update_reports (
646: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2 ) IS
650: c_update_cursor update_cursor_type;

Line 782: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

778: END process_update_reports;
779:
780:
781: PROCEDURE open_update_cursor (update_cursor IN OUT NOCOPY update_cursor_type,
782: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
783: ) IS
784: l_sql_query varchar2(11000) :=
785: 'SELECT /*+ leading(fr_sg) use_nl(fr_int) rowid(fr_int) */
786: fr_int.ROWID,

Line 884: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

880: END open_update_cursor;
881:
882:
883: PROCEDURE report_errors(
884: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
885: P_DML_EXCEPTION IN VARCHAR2
886: ) IS
887:
888: num_exp NUMBER;