APPS.MIGRATE_BATCH dependencies on PM_ROUT_DTL

Line 222: UPDATE pm_rout_dtl

218: );
219:
220: l_pos := 5;
221:
222: UPDATE pm_rout_dtl
223: SET in_use = 0
224: WHERE in_use IS NULL OR
225: in_use NOT in (0,100);
226:

Line 230: p_table_name => 'pm_rout_dtl',

226:
227: l_pos := 6;
228:
229: insert_message (
230: p_table_name => 'pm_rout_dtl',
231: p_procedure_name => 'unlock_all',
232: p_parameters => 'none',
233: p_message => 'number of records unlocked = ' || SQL%ROWCOUNT,
234: p_error_type => 'P'

Line 242: p_table_name => 'pm_btch_hdr/pm_matl_dtl/pm_rout_dtl',

238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: insert_message (
242: p_table_name => 'pm_btch_hdr/pm_matl_dtl/pm_rout_dtl',
243: p_procedure_name => 'unlock_all',
244: p_parameters => 'none',
245: p_message => SQLERRM || ' with pos = ' || l_pos,
246: p_error_type => 'D'

Line 256: FROM pm_rout_dtl

252: l_pos NUMBER := 0;
253:
254: CURSOR cur_get_del_steps IS
255: SELECT batch_id, batchstep_no
256: FROM pm_rout_dtl
257: WHERE delete_mark = 1;
258:
259: CURSOR cur_get_del_step_dtls IS
260: SELECT batchstepline_id

Line 541: FROM pm_rout_dtl

537: BEGIN
538: l_pos := 1;
539: SELECT 1
540: INTO v_exist
541: FROM pm_rout_dtl
542: WHERE batch_id = p_batch_id AND
543: delete_mark <> 1 AND
544: ROWNUM = 1;
545: l_pos := 2;

Line 559: p_table_name => 'pm_rout_dtl',

555: WHEN NO_DATA_FOUND THEN
556: RETURN 'N';
557: WHEN OTHERS THEN
558: insert_message (
559: p_table_name => 'pm_rout_dtl',
560: p_procedure_name => 'get_poc_data_ind',
561: p_parameters => p_batch_id,
562: p_message => SQLERRM || ' with pos = ' || l_pos,
563: p_error_type => 'D'

Line 666: p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,

662: END get_activity_id;
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

Line 2257: IF (is_table_migrated (p_table_name => 'PM_ROUT_DTL') = FALSE) THEN

2253: COMMIT;
2254: END IF;
2255: END IF;
2256:
2257: IF (is_table_migrated (p_table_name => 'PM_ROUT_DTL') = FALSE) THEN
2258: l_pos := 8;
2259: insert_batch_steps (x_return_status => l_return_status);
2260: l_pos := 9;
2261:

Line 2267: p_table_name => 'PM_ROUT_DTL',

2263: RAISE error_detail;
2264: END IF;
2265:
2266: set_table_migrated (
2267: p_table_name => 'PM_ROUT_DTL',
2268: x_return_status => l_return_status
2269: );
2270:
2271: IF p_commit THEN

Line 2841: v_step_rec pm_rout_dtl%ROWTYPE;

2837: );
2838: END insert_material_details;
2839:
2840: PROCEDURE insert_batch_steps (x_return_status OUT NOCOPY VARCHAR2) IS
2841: v_step_rec pm_rout_dtl%ROWTYPE;
2842: v_mass_ref_uom VARCHAR2 (4);
2843: v_volume_ref_uom VARCHAR2 (4);
2844: v_mass_qty NUMBER;
2845: v_volume_qty NUMBER;

Line 3007: FROM pm_rout_dtl

3003: ,
3004: NULL --actual_volume_qty
3005: ,
3006: NULL --actual_mass_qty
3007: FROM pm_rout_dtl
3008: WHERE in_use < 100 AND
3009: delete_mark <> 1;
3010:
3011: insert_message (

Line 3019: UPDATE pm_rout_dtl

3015: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3016: p_error_type => 'P'
3017: );
3018:
3019: UPDATE pm_rout_dtl
3020: SET in_use = in_use + 100
3021: WHERE in_use < 100 AND
3022: delete_mark <> 1;
3023: EXCEPTION