DBA Data[Home] [Help]

APPS.PJI_MAP_ROWSET_MEASURE dependencies on PJI_MT_ROWSET_DET

Line 114: delete from pji_mt_rowset_det

110: );
111:
112: --Bug 3798976. Delete all the detail records and populate with the new list
113: --with the correct order.
114: delete from pji_mt_rowset_det
115: where rowset_code = p_rowset_code;
116:
117: l_display_order_tbl := SYSTEM.pa_num_tbl_type();
118:

Line 126: insert into PJI_MT_ROWSET_DET(

122: l_display_order_tbl(i) := i;
123: end loop;
124:
125: forall i in p_measure_set_code_add_tb1.FIRST .. p_measure_set_code_add_tb1.LAST
126: insert into PJI_MT_ROWSET_DET(
127: ROWSET_CODE,
128: MEASURE_SET_CODE,
129: OBJECT_VERSION_NUMBER,
130: DISPLAY_ORDER,

Line 150: delete from PJI_MT_ROWSET_DET

146: end if;
147:
148: if p_measure_set_code_del_tb1.count <> 0 then
149: forall i in p_measure_set_code_del_tb1.FIRST .. p_measure_set_code_del_tb1.LAST
150: delete from PJI_MT_ROWSET_DET
151: where rowset_code=p_rowset_code
152: and measure_set_code=p_measure_set_code_del_tb1(i);
153: end if;
154:

Line 228: delete from pji_mt_rowset_det where rowset_code=p_rowset_code;

224: x_msg_count := 0;
225:
226: pji_mt_rowset_pkg.delete_row(p_rowset_code => p_rowset_code);
227:
228: delete from pji_mt_rowset_det where rowset_code=p_rowset_code;
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;