[Home] [Help]
94: mtrl.header_id so that update of GROUPING_RULE_ID of mtrh (for header_id) is
95: done efficiently knowing the fact that the cursor may fetch multiple lines
96: from same header and across headers. column header_id is used to update GROUPINNG_RULE_ID
97: of MTRH, project_id and task_id are used as input parameters for the new call
98: INV_PR_PICK_SLIP_NUMBER.GET_PICK_SLIP_NUMBER() to generate the pick slip number.*/
99: CURSOR c_move_order_lines IS
100: SELECT mtrl.line_id
101: , mtrl.inventory_item_id
102: , mtrh.move_order_type
200: SET grouping_rule_id = p_pick_slip_group_rule_id
201: WHERE header_id = move_ord_rec.header_id;
202:
203: -- Flushing out the Cached Pick Slip Numbers.
204: inv_pr_pick_slip_number.delete_wip_ps_tbl;
205: END IF;
206:
207: SELECT serial_number_control_code
208: INTO serial_control_code
251: p_pick_slip_group_rule_id (hence default null) */
252: IF p_pick_slip_group_rule_id IS NOT NULL THEN
253: -- Looping for each allocation of the MO Line for which Pick Slip Number is not stamped.
254: FOR v_mmtt IN c_mmtt LOOP
255: inv_pr_pick_slip_number.get_pick_slip_number(
256: p_pick_grouping_rule_id => p_pick_slip_group_rule_id
257: , p_org_id => p_org_id
258: , p_wip_entity_id => NULL
259: , p_rep_schedule_id => NULL