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_B

Line 144: PROCEDURE Apply_Measure(p_itd_measure_id IN pji_mt_measures_b.measure_id%TYPE

140: END Generate_Procedure_String;
141:
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

Line 145: ,p_ptd_measure_id IN pji_mt_measures_b.measure_id%TYPE

141:
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

Line 148: ,p_qtd_measure_id IN pji_mt_measures_b.measure_id%TYPE

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
152: ,p_measure_set_code IN pji_mt_measures_b.measure_set_code%TYPE

Line 149: ,p_ytd_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
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

Line 152: ,p_measure_set_code IN pji_mt_measures_b.measure_set_code%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
156: ,p_created_by IN pji_mt_measures_b.created_by%TYPE

Line 153: ,p_last_update_date IN pji_mt_measures_b.last_update_date%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
156: ,p_created_by IN pji_mt_measures_b.created_by%TYPE
157: ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%TYPE

Line 154: ,p_last_updated_by IN pji_mt_measures_b.last_updated_by%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
156: ,p_created_by IN pji_mt_measures_b.created_by%TYPE
157: ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%TYPE
158: ,X_return_status OUT NOCOPY VARCHAR2

Line 155: ,p_creation_date IN pji_mt_measures_b.creation_date%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
156: ,p_created_by IN pji_mt_measures_b.created_by%TYPE
157: ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%TYPE
158: ,X_return_status OUT NOCOPY VARCHAR2
159: ,X_msg_data OUT NOCOPY VARCHAR2

Line 156: ,p_created_by IN pji_mt_measures_b.created_by%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
156: ,p_created_by IN pji_mt_measures_b.created_by%TYPE
157: ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%TYPE
158: ,X_return_status OUT NOCOPY VARCHAR2
159: ,X_msg_data OUT NOCOPY VARCHAR2
160: ,X_msg_count OUT NOCOPY NUMBER

Line 157: ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%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
156: ,p_created_by IN pji_mt_measures_b.created_by%TYPE
157: ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%TYPE
158: ,X_return_status OUT NOCOPY VARCHAR2
159: ,X_msg_data OUT NOCOPY VARCHAR2
160: ,X_msg_count OUT NOCOPY NUMBER
161: ) AS

Line 199: delete from PJI_MT_MEASURES_B

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;
201: */
202: -- PJI_MT_MEASURES_PKG.DELETE_ROW (p_measure_id =>l_itd_measure_id);
203: END IF;

Line 254: delete from PJI_MT_MEASURES_B

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;
256: */
257: -- PJI_MT_MEASURES_PKG.DELETE_ROW (p_measure_id =>l_ptd_measure_id);
258: END IF;