eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_CM_UTIL dependencies on PJI_MT_MEASURES_TL

Line 146: ,p_itd_name IN pji_mt_measures_tl.name%TYPE

142:
143:
144: PROCEDURE Apply_Measure(p_itd_measure_id IN pji_mt_measures_b.measure_id%TYPE
145: ,p_ptd_measure_id IN pji_mt_measures_b.measure_id%TYPE
146: ,p_itd_name IN pji_mt_measures_tl.name%TYPE
147: ,p_ptd_name IN pji_mt_measures_tl.name%TYPE
148: ,p_qtd_measure_id IN pji_mt_measures_b.measure_id%TYPE
149: ,p_ytd_measure_id IN pji_mt_measures_b.measure_id%TYPE
150: ,p_qtd_name IN pji_mt_measures_tl.name%TYPE

Line 147: ,p_ptd_name IN pji_mt_measures_tl.name%TYPE

143:
144: PROCEDURE Apply_Measure(p_itd_measure_id IN pji_mt_measures_b.measure_id%TYPE
145: ,p_ptd_measure_id IN pji_mt_measures_b.measure_id%TYPE
146: ,p_itd_name IN pji_mt_measures_tl.name%TYPE
147: ,p_ptd_name IN pji_mt_measures_tl.name%TYPE
148: ,p_qtd_measure_id IN pji_mt_measures_b.measure_id%TYPE
149: ,p_ytd_measure_id IN pji_mt_measures_b.measure_id%TYPE
150: ,p_qtd_name IN pji_mt_measures_tl.name%TYPE
151: ,p_ytd_name IN pji_mt_measures_tl.name%TYPE

Line 150: ,p_qtd_name IN pji_mt_measures_tl.name%TYPE

146: ,p_itd_name IN pji_mt_measures_tl.name%TYPE
147: ,p_ptd_name IN pji_mt_measures_tl.name%TYPE
148: ,p_qtd_measure_id IN pji_mt_measures_b.measure_id%TYPE
149: ,p_ytd_measure_id IN pji_mt_measures_b.measure_id%TYPE
150: ,p_qtd_name IN pji_mt_measures_tl.name%TYPE
151: ,p_ytd_name IN pji_mt_measures_tl.name%TYPE
152: ,p_measure_set_code IN pji_mt_measures_b.measure_set_code%TYPE
153: ,p_last_update_date IN pji_mt_measures_b.last_update_date%TYPE
154: ,p_last_updated_by IN pji_mt_measures_b.last_updated_by%TYPE

Line 151: ,p_ytd_name IN pji_mt_measures_tl.name%TYPE

147: ,p_ptd_name IN pji_mt_measures_tl.name%TYPE
148: ,p_qtd_measure_id IN pji_mt_measures_b.measure_id%TYPE
149: ,p_ytd_measure_id IN pji_mt_measures_b.measure_id%TYPE
150: ,p_qtd_name IN pji_mt_measures_tl.name%TYPE
151: ,p_ytd_name IN pji_mt_measures_tl.name%TYPE
152: ,p_measure_set_code IN pji_mt_measures_b.measure_set_code%TYPE
153: ,p_last_update_date IN pji_mt_measures_b.last_update_date%TYPE
154: ,p_last_updated_by IN pji_mt_measures_b.last_updated_by%TYPE
155: ,p_creation_date IN pji_mt_measures_b.creation_date%TYPE

Line 177: UPDATE Pji_Mt_Measures_Tl

173: BEGIN
174: X_return_status :=Fnd_Api.G_RET_STS_SUCCESS;
175: IF p_itd_measure_id IS NOT NULL THEN
176: IF p_itd_name IS NOT NULL THEN
177: UPDATE Pji_Mt_Measures_Tl
178: SET Name = p_itd_name,
179: Last_Update_Date =p_last_update_date,
180: Last_Updated_By = p_last_updated_by,
181: Last_Update_Login = p_last_update_login,

Line 196: delete from PJI_MT_MEASURES_TL

192:
193: ELSE
194: NULL;
195: /* Commented out ,if delete functionality is added it can be uncommented
196: delete from PJI_MT_MEASURES_TL
197: where measure_id = l_itd_measure_id;
198:
199: delete from PJI_MT_MEASURES_B
200: where measure_id = l_itd_measure_id;

Line 232: UPDATE Pji_Mt_Measures_Tl

228: END IF;
229: IF p_ptd_measure_id IS NOT NULL THEN
230: IF p_ptd_name IS NOT NULL THEN
231:
232: UPDATE Pji_Mt_Measures_Tl
233: SET Name = p_ptd_name,
234: Last_Update_Date =p_last_update_date,
235: Last_Updated_By = p_last_updated_by,
236: Last_Update_Login = p_last_update_login,

Line 251: delete from PJI_MT_MEASURES_TL

247: END IF;
248: ELSE
249: NULL;
250: /* Commented out ,if delete functionality is added it can be uncommented
251: delete from PJI_MT_MEASURES_TL
252: where measure_id = l_ptd_measure_id;
253:
254: delete from PJI_MT_MEASURES_B
255: where measure_id = l_ptd_measure_id;

Line 287: UPDATE Pji_Mt_Measures_Tl

283:
284:
285: IF p_qtd_measure_id IS NOT NULL THEN
286: IF p_qtd_name IS NOT NULL THEN
287: UPDATE Pji_Mt_Measures_Tl
288: SET Name = p_qtd_name,
289: Last_Update_Date =p_last_update_date,
290: Last_Updated_By = p_last_updated_by,
291: Last_Update_Login = p_last_update_login,

Line 335: UPDATE Pji_Mt_Measures_Tl

331:
332:
333: IF p_ytd_measure_id IS NOT NULL THEN
334: IF p_ytd_name IS NOT NULL THEN
335: UPDATE Pji_Mt_Measures_Tl
336: SET Name = p_ytd_name,
337: Last_Update_Date =p_last_update_date,
338: Last_Updated_By = p_last_updated_by,
339: Last_Update_Login = p_last_update_login,