APPS.HZ_IMP_LOAD_CREDITRATINGS_PKG dependencies on HZ_IMP_LOAD_WRAPPER

Line 169: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

165: PROCEDURE disable_debug;
166: */
167: ----------------------------------------------
168: PROCEDURE process_cr_ins (
169: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
170: ,x_return_status OUT NOCOPY VARCHAR2
171: ,x_msg_count OUT NOCOPY NUMBER
172: ,x_msg_data OUT NOCOPY VARCHAR2 );
173: ----------------------------------------------

Line 175: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

171: ,x_msg_count OUT NOCOPY NUMBER
172: ,x_msg_data OUT NOCOPY VARCHAR2 );
173: ----------------------------------------------
174: procedure report_errors (
175: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
176: ,P_ACTION IN VARCHAR2
177: ,P_DML_EXCEPTION IN VARCHAR2);
178: ----------------------------------------------
179: procedure open_upd_cursor (

Line 180: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

176: ,P_ACTION IN VARCHAR2
177: ,P_DML_EXCEPTION IN VARCHAR2);
178: ----------------------------------------------
179: procedure open_upd_cursor (
180: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
181: ,update_cursor IN OUT NOCOPY update_cursor_type);
182: ----------------------------------------------
183: procedure process_cr_upd (
184: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

Line 184: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

180: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
181: ,update_cursor IN OUT NOCOPY update_cursor_type);
182: ----------------------------------------------
183: procedure process_cr_upd (
184: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
185: ,x_return_status OUT NOCOPY VARCHAR2
186: ,x_msg_count OUT NOCOPY NUMBER
187: ,x_msg_data OUT NOCOPY VARCHAR2 );
188:

Line 190: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

186: ,x_msg_count OUT NOCOPY NUMBER
187: ,x_msg_data OUT NOCOPY VARCHAR2 );
188:
189: PROCEDURE populate_error_table(
190: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
191: P_DUP_VAL_EXP IN VARCHAR2,
192: P_SQL_ERRM IN VARCHAR2 );
193:
194: --------------------------------------

Line 245: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

241: *
242: */
243: --------------------------------------
244: PROCEDURE open_upd_cursor (
245: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
246: ,update_cursor IN OUT NOCOPY update_cursor_type) IS
247: l_sql_str1 VARCHAR2(32767) :=
248: 'SELECT
249: crsg.action_flag,

Line 768: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

764: *
765: */
766: --------------------------------------
767: PROCEDURE process_cr_ins (
768: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
769: ,x_return_status OUT NOCOPY VARCHAR2
770: ,x_msg_count OUT NOCOPY NUMBER
771: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
772:

Line 1811: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

1807: *
1808: */
1809: --------------------------------------
1810: PROCEDURE process_cr_upd(
1811: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
1812: ,x_return_status OUT NOCOPY VARCHAR2
1813: ,x_msg_count OUT NOCOPY NUMBER
1814: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
1815:

Line 2199: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,

2195: */
2196: --------------------------------------
2197:
2198: PROCEDURE populate_error_table(
2199: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
2200: P_DUP_VAL_EXP IN VARCHAR2,
2201: P_SQL_ERRM IN VARCHAR2 ) IS
2202:
2203: dup_val_exp_val VARCHAR2(1) := null;

Line 2324: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

2320: *
2321: */
2322: --------------------------------------
2323: procedure report_errors (
2324: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
2325: ,P_ACTION IN VARCHAR2
2326: ,P_DML_EXCEPTION IN VARCHAR2 ) IS
2327:
2328: -- local variables

Line 2663: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE

2659: */
2660: --------------------------------------
2661:
2662: PROCEDURE load_creditratings (
2663: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
2664: ,x_return_status OUT NOCOPY VARCHAR2
2665: ,x_msg_count OUT NOCOPY NUMBER
2666: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
2667: