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.MIGRATE_BATCH dependencies on PM_OPRN_DTL

Line 27: -- batch by batch processing in order to normalize pm_oprn_dtl

23: -- split_trans_line deals with completed default transactions that are
24: -- either plain or non-plain with 0 qty. Here, for 0 qty completed, the
25: -- transaction can be flipped to pending. For non-zero completed plain, a
26: -- 0 qty pending transaction is inserted. insert_batch_step_dtls performs
27: -- batch by batch processing in order to normalize pm_oprn_dtl
28: -- into gme_batch_step_activities and gme_batch_step_resources.
29: --
30: -- The main package to call is migrate_batch.run. If it is called with no parameters,
31: -- or as migrate_batch.run(p_commit => FALSE) a rollback is performed at the end of the

Line 84: g_resource pm_oprn_dtl.resources%TYPE;

80: --
81: -- G. Muratore - 06/09/2005 Bug 4249832 Removed hard coded schemas per gscc.
82: /***********************************************************/
83:
84: g_resource pm_oprn_dtl.resources%TYPE;
85: g_batch_id pm_btch_hdr_bak.batch_id%TYPE;
86: g_min_capacity NUMBER;
87: g_max_capacity NUMBER;
88: g_capacity_uom VARCHAR2 (4);

Line 261: FROM pm_oprn_dtl

257: WHERE delete_mark = 1;
258:
259: CURSOR cur_get_del_step_dtls IS
260: SELECT batchstepline_id
261: FROM pm_oprn_dtl
262: WHERE delete_mark = 1;
263:
264: l_cur_get_del_steps cur_get_del_steps%ROWTYPE;
265: l_cur_get_del_step_dtls cur_get_del_step_dtls%ROWTYPE;

Line 273: UPDATE pm_oprn_dtl

269:
270: OPEN cur_get_del_steps;
271: FETCH cur_get_del_steps INTO l_cur_get_del_steps;
272: WHILE cur_get_del_steps%FOUND LOOP
273: UPDATE pm_oprn_dtl
274: SET delete_mark = 1
275: WHERE batch_id = l_cur_get_del_steps.batch_id AND
276: batchstep_no = l_cur_get_del_steps.batchstep_no;
277:

Line 296: p_table_name => 'pm_oprn_dtl/pc_tran_pnd',

292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: insert_message (
296: p_table_name => 'pm_oprn_dtl/pc_tran_pnd',
297: p_procedure_name => 'del_step_dtl_for_del_steps',
298: p_parameters => 'none',
299: p_message => SQLERRM || ' with pos = ' || l_pos,
300: p_error_type => 'D'

Line 338: FROM pm_oprn_dtl

334: BEGIN
335: l_pos := 1;
336: SELECT plan_rsrc_count * plan_rsrc_usage
337: INTO v_resource_usage
338: FROM pm_oprn_dtl
339: WHERE batchstepline_id = p_batchstepline_id;
340: l_pos := 2;
341: RETURN v_resource_usage;
342: EXCEPTION

Line 345: p_table_name => 'pm_oprn_dtl',

341: RETURN v_resource_usage;
342: EXCEPTION
343: WHEN OTHERS THEN
344: insert_message (
345: p_table_name => 'pm_oprn_dtl',
346: p_procedure_name => 'get_planned_usage',
347: p_parameters => p_batchstepline_id,
348: p_message => SQLERRM || ' with pos = ' || l_pos,
349: p_error_type => 'D'

Line 667: p_activity IN pm_oprn_dtl.activity%TYPE,

663:
664: FUNCTION get_rsrc_offset (
665: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
666: p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,
667: p_activity IN pm_oprn_dtl.activity%TYPE,
668: p_offset IN pm_oprn_dtl.offset_interval%TYPE
669: )
670: RETURN NUMBER IS
671: l_act_offset NUMBER;

Line 668: p_offset IN pm_oprn_dtl.offset_interval%TYPE

664: FUNCTION get_rsrc_offset (
665: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
666: p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,
667: p_activity IN pm_oprn_dtl.activity%TYPE,
668: p_offset IN pm_oprn_dtl.offset_interval%TYPE
669: )
670: RETURN NUMBER IS
671: l_act_offset NUMBER;
672: l_pos NUMBER := 0;

Line 707: p_resources IN pm_oprn_dtl.resources%TYPE,

703: END get_rsrc_offset;
704:
705: PROCEDURE get_capacity (
706: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
707: p_resources IN pm_oprn_dtl.resources%TYPE,
708: x_min_capacity OUT NOCOPY NUMBER,
709: x_max_capacity OUT NOCOPY NUMBER,
710: x_capacity_uom OUT NOCOPY VARCHAR2,
711: x_return_status OUT NOCOPY VARCHAR2

Line 714: v_rsrc pm_oprn_dtl.resources%TYPE,

710: x_capacity_uom OUT NOCOPY VARCHAR2,
711: x_return_status OUT NOCOPY VARCHAR2
712: ) IS
713: CURSOR get_resource_capacity (
714: v_rsrc pm_oprn_dtl.resources%TYPE,
715: v_batch_id pm_btch_hdr_bak.batch_id%TYPE
716: ) IS
717: SELECT min_capacity,
718: max_capacity,

Line 782: p_rsrc pm_oprn_dtl.resources%TYPE

778: END get_capacity;
779:
780: FUNCTION get_min_capacity (
781: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
782: p_rsrc pm_oprn_dtl.resources%TYPE
783: )
784: RETURN NUMBER IS
785: l_min_c NUMBER;
786: l_max_c NUMBER;

Line 839: p_rsrc pm_oprn_dtl.resources%TYPE

835: END get_min_capacity;
836:
837: FUNCTION get_max_capacity (
838: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
839: p_rsrc pm_oprn_dtl.resources%TYPE
840: )
841: RETURN NUMBER IS
842: l_min_c NUMBER;
843: l_max_c NUMBER;

Line 896: p_rsrc pm_oprn_dtl.resources%TYPE

892: END get_max_capacity;
893:
894: FUNCTION get_capacity_uom (
895: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
896: p_rsrc pm_oprn_dtl.resources%TYPE
897: )
898: RETURN VARCHAR2 IS
899: l_min_c NUMBER;
900: l_max_c NUMBER;

Line 2276: IF (is_table_migrated (p_table_name => 'PM_OPRN_DTL') = FALSE) THEN

2272: COMMIT;
2273: END IF;
2274: END IF;
2275:
2276: IF (is_table_migrated (p_table_name => 'PM_OPRN_DTL') = FALSE) THEN
2277: l_pos := 10;
2278: insert_batch_step_dtls (x_return_status => l_return_status);
2279: l_pos := 11;
2280:

Line 2286: p_table_name => 'PM_OPRN_DTL',

2282: RAISE error_detail;
2283: END IF;
2284:
2285: set_table_migrated (
2286: p_table_name => 'PM_OPRN_DTL',
2287: x_return_status => l_return_status
2288: );
2289:
2290: IF p_commit THEN

Line 3045: FROM pm_oprn_dtl

3041: MIN (plan_start_date) plan_start_date,
3042: MAX (plan_cmplt_date) plan_cmplt_date,
3043: MIN (actual_start_date) actual_start_date,
3044: MAX (actual_cmplt_date) actual_cmplt_date
3045: FROM pm_oprn_dtl
3046: WHERE delete_mark < 100 AND
3047: delete_mark <> 1
3048: GROUP BY batch_id, batchstep_no, activity;
3049:

Line 3051: v_batch_id pm_oprn_dtl.batch_id%TYPE,

3047: delete_mark <> 1
3048: GROUP BY batch_id, batchstep_no, activity;
3049:
3050: CURSOR get_oprn_dtl (
3051: v_batch_id pm_oprn_dtl.batch_id%TYPE,
3052: v_step_no pm_oprn_dtl.batchstep_no%TYPE,
3053: v_activity pm_oprn_dtl.activity%TYPE,
3054: v_offset pm_oprn_dtl.offset_interval%TYPE
3055: ) IS

Line 3052: v_step_no pm_oprn_dtl.batchstep_no%TYPE,

3048: GROUP BY batch_id, batchstep_no, activity;
3049:
3050: CURSOR get_oprn_dtl (
3051: v_batch_id pm_oprn_dtl.batch_id%TYPE,
3052: v_step_no pm_oprn_dtl.batchstep_no%TYPE,
3053: v_activity pm_oprn_dtl.activity%TYPE,
3054: v_offset pm_oprn_dtl.offset_interval%TYPE
3055: ) IS
3056: SELECT *

Line 3053: v_activity pm_oprn_dtl.activity%TYPE,

3049:
3050: CURSOR get_oprn_dtl (
3051: v_batch_id pm_oprn_dtl.batch_id%TYPE,
3052: v_step_no pm_oprn_dtl.batchstep_no%TYPE,
3053: v_activity pm_oprn_dtl.activity%TYPE,
3054: v_offset pm_oprn_dtl.offset_interval%TYPE
3055: ) IS
3056: SELECT *
3057: FROM pm_oprn_dtl

Line 3054: v_offset pm_oprn_dtl.offset_interval%TYPE

3050: CURSOR get_oprn_dtl (
3051: v_batch_id pm_oprn_dtl.batch_id%TYPE,
3052: v_step_no pm_oprn_dtl.batchstep_no%TYPE,
3053: v_activity pm_oprn_dtl.activity%TYPE,
3054: v_offset pm_oprn_dtl.offset_interval%TYPE
3055: ) IS
3056: SELECT *
3057: FROM pm_oprn_dtl
3058: WHERE batch_id = v_batch_id AND

Line 3057: FROM pm_oprn_dtl

3053: v_activity pm_oprn_dtl.activity%TYPE,
3054: v_offset pm_oprn_dtl.offset_interval%TYPE
3055: ) IS
3056: SELECT *
3057: FROM pm_oprn_dtl
3058: WHERE batch_id = v_batch_id AND
3059: batchstep_no = v_step_no AND
3060: activity = v_activity AND
3061: offset_interval = v_offset AND

Line 3317: FROM pm_oprn_dtl

3313: ,
3314: actual_rsrc_qty,
3315: plan_rsrc_qty,
3316: 0 --calculate_charges
3317: FROM pm_oprn_dtl
3318: WHERE delete_mark < 100 AND
3319: delete_mark <> 1;
3320:
3321: insert_message (

Line 3329: UPDATE pm_oprn_dtl

3325: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3326: p_error_type => 'P'
3327: );
3328:
3329: UPDATE pm_oprn_dtl
3330: SET delete_mark = delete_mark + 100
3331: WHERE delete_mark < 100 AND
3332: delete_mark <> 1;
3333:

Line 3346: p_table_name => 'PM_OPRN_DTL',

3342: x_return_status := l_return_status;
3343: WHEN OTHERS THEN
3344: x_return_status := 'D';
3345: insert_message (
3346: p_table_name => 'PM_OPRN_DTL',
3347: p_procedure_name => 'INSERT_BATCH_STEP_DTLS',
3348: p_parameters => '',
3349: p_message => SQLERRM,
3350: p_error_type => x_return_status