DBA Data[Home] [Help]

APPS.IEM_OP_ADMIN_PUB dependencies on IEM_OP_ERR_OBJ

Line 33: x_item_err OUT NOCOPY SYSTEM.IEM_OP_ERR_OBJ_ARRAY)

29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: x_total OUT NOCOPY NUMBER,
33: x_item_err OUT NOCOPY SYSTEM.IEM_OP_ERR_OBJ_ARRAY)
34: IS
35:
36:
37: l_api_name VARCHAR2(255);

Line 44: l_outbox_data SYSTEM.IEM_OP_ERR_OBJ;

40: l_op_rec op_rectype;
41:
42: TYPE get_status is REF CURSOR;
43: op_cur get_status;
44: l_outbox_data SYSTEM.IEM_OP_ERR_OBJ;
45: l_outbox_array SYSTEM.IEM_OP_ERR_OBJ_ARRAY;
46:
47: str VARCHAR2(500);
48:

Line 45: l_outbox_array SYSTEM.IEM_OP_ERR_OBJ_ARRAY;

41:
42: TYPE get_status is REF CURSOR;
43: op_cur get_status;
44: l_outbox_data SYSTEM.IEM_OP_ERR_OBJ;
45: l_outbox_array SYSTEM.IEM_OP_ERR_OBJ_ARRAY;
46:
47: str VARCHAR2(500);
48:
49: l_rt_interaction_id NUMBER;

Line 140: l_outbox_array := SYSTEM.IEM_OP_ERR_OBJ_ARRAY();

136:
137: end if;
138:
139: OPEN op_cur FOR str USING DATE_FORMAT, G_ACTIVE;
140: l_outbox_array := SYSTEM.IEM_OP_ERR_OBJ_ARRAY();
141: l_start := 0;
142:
143: LOOP
144: begin

Line 187: l_outbox_array(l_outbox_array.LAST) := SYSTEM.IEM_OP_ERR_OBJ(

183: when others then
184: null;
185: end;
186: l_outbox_array.EXTEND;
187: l_outbox_array(l_outbox_array.LAST) := SYSTEM.IEM_OP_ERR_OBJ(
188: l_op_rec.rt_media_item_id,
189: l_action, l_name,
190: l_op_rec.error_summary,
191: substr(l_op_rec.error_detail,1,200),

Line 216: x_item_err := SYSTEM.IEM_OP_ERR_OBJ_ARRAY();

212: if ( l_last > l_outbox_array.LAST ) then
213: l_last := l_outbox_array.LAST;
214: end if;
215:
216: x_item_err := SYSTEM.IEM_OP_ERR_OBJ_ARRAY();
217: if ( x_total > 0 ) then
218: FOR i in l_first..l_last LOOP
219: x_item_err.EXTEND;
220: x_item_err(x_item_err.LAST) := l_outbox_array(i);