[Home] [Help]
42: NULL;
43: END print_debug;
44:
45: /**
46: * This Procedure is used to insert values into table mtl_replenish_lines.
47: * @param x_return_status Return Status
48: * @param x_msg_count Message Count
49: * @param x_msg_data Message Data
50: * @param p_organization_id Organization Id
112: END IF;
113:
114: fnd_message.set_name('INV', 'INV_RC_CREATED_FROM_MOBILE');
115:
116: INSERT INTO mtl_replenish_lines
117: (
118: replenishment_line_id
119: , replenishment_header_id
120: , organization_id
144: , secondary_uom_count_quantity
145: -- INCVONV, NSRIVAST
146: )
147: VALUES (
148: mtl_replenish_lines_s.NEXTVAL
149: , p_replenish_header_id
150: , p_organization_id
151: , SYSDATE
152: , fnd_global.user_id
185: x_return_status := fnd_api.g_ret_sts_error;
186: END insert_row;
187:
188: /**
189: * This Procedure is used to update table mtl_replenish_lines.
190: * @param x_return_status Return Status
191: * @param x_msg_count Message Count
192: * @param x_msg_data Message Data
193: * @param p_item_id Item ID
234: );
235: END IF;
236:
237: -- Convert the count quantity into the item primary uom quantity.
238: UPDATE mtl_replenish_lines
239: SET last_update_date = SYSDATE
240: , last_updated_by = fnd_global.user_id
241: , last_update_login = fnd_global.login_id
242: , count_quantity = p_count_quantity
327: , ml.meaning count_type
328: , mrl.replenishment_line_id replenishment_line_id
329: , msiv.description item_description
330: , msiv.primary_uom_code primary_uom_code
331: FROM mtl_item_locations mil, mtl_system_items_vl msiv, mtl_secondary_locators msl, mtl_replenish_lines mrl, mfg_lookups ml
332: WHERE msl.inventory_item_id = msiv.inventory_item_id
333: AND msl.organization_id = msiv.organization_id
334: AND msl.secondary_locator = mil.inventory_location_id
335: AND msl.organization_id = mil.organization_id
365: , ml.meaning count_type
366: , mrl.replenishment_line_id replenishment_line_id
367: , msiv.description item_description
368: , msiv.primary_uom_code primary_uom_code
369: FROM mtl_system_items_vl msiv, mtl_item_sub_inventories mis, mtl_replenish_lines mrl, mfg_lookups ml
370: WHERE mis.inventory_item_id = msiv.inventory_item_id
371: AND mis.organization_id = msiv.organization_id
372: AND mis.organization_id = p_organization_id
373: AND mis.secondary_inventory = p_subinventory_code
445: AND(
446: (
447: p_planning_level = 1
448: AND NOT EXISTS(SELECT 1
449: FROM mtl_replenish_lines mrl
450: WHERE mrl.replenishment_header_id = mrh.replenishment_header_id
451: AND mrl.locator_id IS NULL)
452: )
453: OR(
452: )
453: OR(
454: p_planning_level = 2
455: AND NOT EXISTS(SELECT 1
456: FROM mtl_replenish_lines mrl
457: WHERE mrl.replenishment_header_id = mrh.replenishment_header_id
458: AND mrl.locator_id IS NOT NULL)
459: )
460: );
525: SELECT 1
526: INTO l_record_exists
527: FROM DUAL
528: WHERE EXISTS(SELECT 1
529: FROM mtl_replenish_lines
530: WHERE replenishment_header_id = p_replenish_header_id
531: AND count_quantity IS NULL
532: AND error_flag IS NULL);
533: EXCEPTION
542: INTO l_error_record_exists
543: FROM DUAL
544: WHERE EXISTS(
545: SELECT 1
546: FROM mtl_replenish_lines mrl
547: WHERE replenishment_header_id = p_replenish_header_id
548: AND(
549: (count_type_code = 1
550: AND p_quantity_tracked = 1)
689: INTO l_count_valid
690: FROM DUAL
691: WHERE EXISTS(
692: SELECT 1
693: FROM mtl_replenish_lines
694: WHERE replenishment_header_id = p_replenish_header_id
695: AND((p_planning_level = 1
696: AND locator_id IS NULL)
697: OR(p_planning_level = 2