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.WMS_WAVE_PLANNING_PVT dependencies on WMS_WAVE_PLANNING_PVT

Line 1: PACKAGE BODY wms_wave_planning_pvt as

1: PACKAGE BODY wms_wave_planning_pvt as
2: /* $Header: WMSWVPVB.pls 120.57.12020000.10 2013/03/25 06:46:55 ssrikaku ship $ */
3:
4: l_seq_val NUMBER;
5: g_mmtt_table num_t := num_t(); --11870443

Line 274: p_module => 'WMS_WAVE_PLANNING_PVT',

270: BEGIN
271:
272: IF p_debug = 1 THEN
273: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg,
274: p_module => 'WMS_WAVE_PLANNING_PVT',
275: p_level => 4);
276: END IF;
277:
278: END print_debug;

Line 635: wms_wave_planning_pvt.insert_wave_record(v_WAVE_HEADER_ID);

631:
632: if p_wave_template_name is not null then
633: --If Concurrent program is Scheduled and template name is given
634: --Create Wave records for Wave Headers and Advanced Criteria table
635: wms_wave_planning_pvt.insert_wave_record(v_WAVE_HEADER_ID);
636: --insert into Advanced Criteria
637:
638: if x_return_status <> 'S' then
639: raise wave_Creation_exception;

Line 1331: wms_wave_planning_pvt.get_current_work_load(l_cap_det.resource_type,

1327: if tbl_type = 1 then
1328: position := 0;
1329: FOR l_cap_det IN c_get_distinct_resource(l_planning_criteria_id) LOOP
1330: x_resource_capacity_tbl(position).resource_name := l_cap_det.resource_type;
1331: wms_wave_planning_pvt.get_current_work_load(l_cap_det.resource_type,
1332: l_planning_criteria_id,
1333: l_wave_header_id,
1334: current_load,
1335: resource_type,

Line 6555: /* WMS_WAVE_PLANNING_PVT.get_line_fill_rate(x_return_status,

6551: end if;
6552: end if;
6553:
6554: --Calculate the Planned Fill Rate for the Wave
6555: /* WMS_WAVE_PLANNING_PVT.get_line_fill_rate(x_return_status,
6556: p_wave_header_id);
6557: print_debug('Status after Call to Get the Fill Rate' ||
6558: x_return_status,
6559: l_debug); */

Line 6620: WMS_WAVE_PLANNING_PVT.labor_planning(p_wave_header_id,

6616:
6617: print_debug('Setup is available for Labor Planning. Calling Availability Check Labor Planning API ',
6618: l_debug);
6619:
6620: WMS_WAVE_PLANNING_PVT.labor_planning(p_wave_header_id,
6621: p_planning_criteria_id,
6622: x_return_status);
6623:
6624: elsif l_planning_method = 'R' and

Line 6961: l_temp_capacity := wms_wave_planning_pvt.get_resource_capacity(wst,

6957: from BOM_DEPT_RES_INSTANCES
6958: WHERE resource_id = p_resource_id
6959: and department_id = p_dept_id;
6960:
6961: l_temp_capacity := wms_wave_planning_pvt.get_resource_capacity(wst,
6962: wet,
6963: 0,
6964: 1440,
6965: l_date_diff);

Line 6988: l_temp_capacity := wms_wave_planning_pvt.get_resource_capacity(wst,

6984: sst := l_shift_tbl(i).start_time;
6985: print_debug('shet := ' || shet,l_debug);
6986: print_debug('sst := ' || sst,l_debug);
6987:
6988: l_temp_capacity := wms_wave_planning_pvt.get_resource_capacity(wst,
6989: wet,
6990: sst,
6991: shet,
6992: l_date_diff);

Line 7004: l_conv_rate := round(wms_wave_planning_pvt.get_conversion_rate(null,

7000: end loop;
7001:
7002: end if;
7003: print_debug('l_available_capacity before conversion := ' || l_available_capacity, l_debug);
7004: l_conv_rate := round(wms_wave_planning_pvt.get_conversion_rate(null,
7005:
7006: 'MIN',
7007:
7008: l_unit_of_measure));

Line 7242: wms_wave_planning_pvt.get_conversion_rate(null,

7238: l_unit_of_measure);
7239:
7240: x_total_capacity := round(round(l_total_capacity *
7241:
7242: wms_wave_planning_pvt.get_conversion_rate(null,
7243:
7244: l_unit_of_measure,
7245:
7246: l_uom)));

Line 7555: wms_wave_planning_pvt.get_source_subinventory(MSIB.INVENTORY_ITEM_id,

7551:
7552: cursor c_subinventories is
7553: select DISTINCT MSI.SECONDARY_INVENTORY_NAME,
7554: moqd.SUBINVENTORY_CODE,
7555: wms_wave_planning_pvt.get_source_subinventory(MSIB.INVENTORY_ITEM_id,
7556: MSI.SECONDARY_INVENTORY_NAME) source_subinventory,
7557: MSI.PICK_UOM_CODE,
7558: wms_wave_planning_pvt.get_conversion_rate(MSIB.INVENTORY_ITEM_id,
7559: MSI.PICK_UOM_CODE,

Line 7558: wms_wave_planning_pvt.get_conversion_rate(MSIB.INVENTORY_ITEM_id,

7554: moqd.SUBINVENTORY_CODE,
7555: wms_wave_planning_pvt.get_source_subinventory(MSIB.INVENTORY_ITEM_id,
7556: MSI.SECONDARY_INVENTORY_NAME) source_subinventory,
7557: MSI.PICK_UOM_CODE,
7558: wms_wave_planning_pvt.get_conversion_rate(MSIB.INVENTORY_ITEM_id,
7559: MSI.PICK_UOM_CODE,
7560: MSIB.PRIMARY_UOM_CODE) AS CONVERSION_RATE,
7561: MSI.PICKING_ORDER
7562: from MTL_SECONDARY_INVENTORIES MSI,

Line 7570: AND wms_wave_planning_pvt.get_conversion_rate(MSIB.INVENTORY_ITEM_id,

7566: and MSIB.INVENTORY_ITEM_ID = l_item_id
7567: AND MSI.PICK_UOM_CODE IS NOT NULL
7568: AND (MSI.SECONDARY_INVENTORY_NAME = v_picking_subinventory or
7569: v_picking_subinventory is null)
7570: AND wms_wave_planning_pvt.get_conversion_rate(MSIB.INVENTORY_ITEM_id,
7571: MSI.PICK_UOM_CODE,
7572: MSIB.PRIMARY_UOM_CODE) > 0
7573: AND moqd.INVENTORY_ITEM_id = MSIB.INVENTORY_ITEM_id
7574: AND moqd.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 7692: wms_wave_planning_pvt.get_current_work_load(l_resource.resource_type,

7688: /* for l_resource in c_labor_resource loop
7689:
7690: x_labor_stats_tbl(n2).resource_name := l_resource.resource_type;
7691: -- addition starts
7692: wms_wave_planning_pvt.get_current_work_load(l_resource.resource_type,
7693: p_planning_criteria_id,
7694: p_wave_header_id,
7695: x_current_load,
7696: x_resource_type,

Line 9352: l_field_name_table wms_wave_planning_pvt.field_name_table_type;

9348: select distinct transaction_temp_id from wms_waveplan_tasks_temp;
9349:
9350: rec_saved_queries c_saved_queries%rowtype;
9351:
9352: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
9353: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
9354: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
9355: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
9356:

Line 9353: l_field_value_table wms_wave_planning_pvt.field_value_table_type;

9349:
9350: rec_saved_queries c_saved_queries%rowtype;
9351:
9352: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
9353: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
9354: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
9355: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
9356:
9357: l_return_status VARCHAR2(1);

Line 9354: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;

9350: rec_saved_queries c_saved_queries%rowtype;
9351:
9352: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
9353: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
9354: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
9355: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
9356:
9357: l_return_status VARCHAR2(1);
9358: l_msg_data VARCHAR2(120);

Line 9355: l_query_type_table wms_wave_planning_pvt.query_type_table_type;

9351:
9352: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
9353: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
9354: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
9355: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
9356:
9357: l_return_status VARCHAR2(1);
9358: l_msg_data VARCHAR2(120);
9359: l_msg_count NUMBER;

Line 9681: (select * from table(wms_wave_planning_pvt.list_mmtt_release)); --11870443

9677: from wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
9678: where wdd.Source_line_id = mmtt.trx_source_line_id
9679: AND Nvl(wdd.REPLENISHMENT_STATUS, 'C') = 'C'
9680: and mmtt.transaction_temp_id in
9681: (select * from table(wms_wave_planning_pvt.list_mmtt_release)); --11870443
9682:
9683: /* cursor c_move_order_header is
9684: select distinct HEADER_ID
9685: from mtl_txn_request_lines

Line 10952: PROCEDURE SET_QUERY_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,

10948:
10949: RAISE fnd_api.g_exc_unexpected_error;
10950: end Task_Release_CP;
10951:
10952: PROCEDURE SET_QUERY_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
10953: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
10954: p_organization_id_table IN wms_wave_planning_pvt.organization_id_table_type,
10955: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
10956: x_return_status OUT NOCOPY VARCHAR2,

Line 10953: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,

10949: RAISE fnd_api.g_exc_unexpected_error;
10950: end Task_Release_CP;
10951:
10952: PROCEDURE SET_QUERY_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
10953: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
10954: p_organization_id_table IN wms_wave_planning_pvt.organization_id_table_type,
10955: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
10956: x_return_status OUT NOCOPY VARCHAR2,
10957: x_return_message OUT NOCOPY VARCHAR2) IS

Line 10954: p_organization_id_table IN wms_wave_planning_pvt.organization_id_table_type,

10950: end Task_Release_CP;
10951:
10952: PROCEDURE SET_QUERY_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
10953: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
10954: p_organization_id_table IN wms_wave_planning_pvt.organization_id_table_type,
10955: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
10956: x_return_status OUT NOCOPY VARCHAR2,
10957: x_return_message OUT NOCOPY VARCHAR2) IS
10958: i number;

Line 10955: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,

10951:
10952: PROCEDURE SET_QUERY_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
10953: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
10954: p_organization_id_table IN wms_wave_planning_pvt.organization_id_table_type,
10955: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
10956: x_return_status OUT NOCOPY VARCHAR2,
10957: x_return_message OUT NOCOPY VARCHAR2) IS
10958: i number;
10959: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 11334: PROCEDURE SET_ACTION_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,

11330: return null;
11331:
11332: end get_net_value;
11333:
11334: PROCEDURE SET_ACTION_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
11335: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
11336: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
11337: x_return_status OUT NOCOPY VARCHAR2,
11338: x_return_message OUT NOCOPY VARCHAR2) IS

Line 11335: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,

11331:
11332: end get_net_value;
11333:
11334: PROCEDURE SET_ACTION_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
11335: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
11336: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
11337: x_return_status OUT NOCOPY VARCHAR2,
11338: x_return_message OUT NOCOPY VARCHAR2) IS
11339: i number;

Line 11336: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,

11332: end get_net_value;
11333:
11334: PROCEDURE SET_ACTION_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
11335: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,
11336: p_query_type_table IN wms_wave_planning_pvt.query_type_table_type,
11337: x_return_status OUT NOCOPY VARCHAR2,
11338: x_return_message OUT NOCOPY VARCHAR2) IS
11339: i number;
11340: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 12129: WMS_WAVE_PLANNING_PVT.Plan_Wave(p_wave_header_id,

12125:
12126: print_debug('In Launch Online Plan Wave with Planning Criteria Id ' ||
12127: p_planning_criteria_id,
12128: l_debug);
12129: WMS_WAVE_PLANNING_PVT.Plan_Wave(p_wave_header_id,
12130: p_planning_criteria_id,
12131: x_return_status);
12132: end if;
12133:

Line 12317: WMS_WAVE_PLANNING_PVT.Init_Rules(l_pick_seq_rule_id,

12313: INTO l_ps_mode, l_use_header_flag, l_to_sub_tmp, l_to_loc_tmp, l_pick_seq_rule_id, l_pick_grouping_rule_id;
12314:
12315: IF (l_pick_grouping_rule_id IS NOT NULL AND g_pick_seq_rule_id IS NULL) THEN
12316: -- This case shd not happen....as release sequence rule is mandatory field in UI
12317: WMS_WAVE_PLANNING_PVT.Init_Rules(l_pick_seq_rule_id,
12318: l_pick_grouping_rule_id,
12319: l_return_status);
12320:
12321: else

Line 12323: WMS_WAVE_PLANNING_PVT.Init_Rules(g_pick_seq_rule_id,

12319: l_return_status);
12320:
12321: else
12322:
12323: WMS_WAVE_PLANNING_PVT.Init_Rules(g_pick_seq_rule_id,
12324: g_pick_grouping_rule_id,
12325: l_return_status);
12326:
12327: end if;

Line 12329: WMS_WAVE_PLANNING_PVT.Init_Cursor(l_organization_id,

12325: l_return_status);
12326:
12327: end if;
12328:
12329: WMS_WAVE_PLANNING_PVT.Init_Cursor(l_organization_id,
12330: v_advanced_sql,
12331: P_WAVE_HEADER_ID,
12332: l_return_status);
12333:

Line 12347: WMS_WAVE_PLANNING_PVT.Get_Lines(l_done_flag, l_return_status);

12343: --12371394 put the get_lines call and the insert to wwl inside a loop
12344: l_done_flag := FND_API.G_FALSE;
12345: LOOP
12346: EXIT WHEN l_done_flag = FND_API.G_TRUE;
12347: WMS_WAVE_PLANNING_PVT.Get_Lines(l_done_flag, l_return_status);
12348:
12349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12350: print_debug('Error occurred in Get Lines', l_debug);
12351: -- RETURN;

Line 14108: total_weight := total_weight + wms_wave_planning_pvt.get_conversion_rate(null,

14104: AND base_uom_flag = 'Y';
14105:
14106: for l_uom in c_uom loop
14107:
14108: total_weight := total_weight + wms_wave_planning_pvt.get_conversion_rate(null,
14109: l_uom.weight_uom_code,
14110: v_weight_uom) *
14111: l_uom.net_weight;
14112:

Line 14153: total_volume := total_volume + wms_wave_planning_pvt.get_conversion_rate(null,

14149: AND base_uom_flag = 'Y';
14150:
14151: for l_uom in c_uom loop
14152:
14153: total_volume := total_volume + wms_wave_planning_pvt.get_conversion_rate(null,
14154: l_uom.volume_uom_code,
14155: v_volume_uom) *
14156: l_uom.volume;
14157:

Line 14221: total_weight := total_weight + wms_wave_planning_pvt.get_conversion_rate(null,

14217:
14218: for l_uom in c_uom loop
14219:
14220: -- dbms_output.put_line( l_uom.weight_uom_code);
14221: total_weight := total_weight + wms_wave_planning_pvt.get_conversion_rate(null,
14222: l_uom.weight_uom_code,
14223: v_weight_uom) *
14224: l_uom.net_weight;
14225:

Line 14226: total_volume := total_volume + wms_wave_planning_pvt.get_conversion_rate(null,

14222: l_uom.weight_uom_code,
14223: v_weight_uom) *
14224: l_uom.net_weight;
14225:
14226: total_volume := total_volume + wms_wave_planning_pvt.get_conversion_rate(null,
14227: l_uom.volume_uom_code,
14228: v_volume_uom) *
14229: l_uom.volume;
14230:

Line 14303: PROCEDURE update_task(p_transaction_temp_id IN WMS_WAVE_PLANNING_PVT.transaction_temp_table_type,

14299: l_debug);
14300: x_return_status := FND_API.G_RET_STS_ERROR;
14301: end update_wave_header_status;
14302:
14303: PROCEDURE update_task(p_transaction_temp_id IN WMS_WAVE_PLANNING_PVT.transaction_temp_table_type,
14304: p_task_type_id IN WMS_WAVE_PLANNING_PVT.task_type_id_table_type,
14305: p_employee IN VARCHAR2,
14306: p_employee_id IN NUMBER,
14307: p_user_task_type IN VARCHAR2,

Line 14304: p_task_type_id IN WMS_WAVE_PLANNING_PVT.task_type_id_table_type,

14300: x_return_status := FND_API.G_RET_STS_ERROR;
14301: end update_wave_header_status;
14302:
14303: PROCEDURE update_task(p_transaction_temp_id IN WMS_WAVE_PLANNING_PVT.transaction_temp_table_type,
14304: p_task_type_id IN WMS_WAVE_PLANNING_PVT.task_type_id_table_type,
14305: p_employee IN VARCHAR2,
14306: p_employee_id IN NUMBER,
14307: p_user_task_type IN VARCHAR2,
14308: p_user_task_type_id IN NUMBER,

Line 14319: x_result OUT NOCOPY WMS_WAVE_PLANNING_PVT.result_table_type,

14315: p_to_status_id IN NUMBER,
14316: p_priority_type IN varchar2 DEFAULT 'S', --mitgupta
14317: p_priority IN NUMBER,
14318: p_clear_priority IN VARCHAR2,
14319: x_result OUT NOCOPY WMS_WAVE_PLANNING_PVT.result_table_type,
14320: x_message OUT NOCOPY WMS_WAVE_PLANNING_PVT.message_table_type,
14321: x_task_id OUT NOCOPY WMS_WAVE_PLANNING_PVT.task_id_table_type,
14322: x_return_status OUT NOCOPY VARCHAR2,
14323: x_return_msg OUT NOCOPY VARCHAR2,

Line 14320: x_message OUT NOCOPY WMS_WAVE_PLANNING_PVT.message_table_type,

14316: p_priority_type IN varchar2 DEFAULT 'S', --mitgupta
14317: p_priority IN NUMBER,
14318: p_clear_priority IN VARCHAR2,
14319: x_result OUT NOCOPY WMS_WAVE_PLANNING_PVT.result_table_type,
14320: x_message OUT NOCOPY WMS_WAVE_PLANNING_PVT.message_table_type,
14321: x_task_id OUT NOCOPY WMS_WAVE_PLANNING_PVT.task_id_table_type,
14322: x_return_status OUT NOCOPY VARCHAR2,
14323: x_return_msg OUT NOCOPY VARCHAR2,
14324: x_msg_count OUT NOCOPY NUMBER) IS

Line 14321: x_task_id OUT NOCOPY WMS_WAVE_PLANNING_PVT.task_id_table_type,

14317: p_priority IN NUMBER,
14318: p_clear_priority IN VARCHAR2,
14319: x_result OUT NOCOPY WMS_WAVE_PLANNING_PVT.result_table_type,
14320: x_message OUT NOCOPY WMS_WAVE_PLANNING_PVT.message_table_type,
14321: x_task_id OUT NOCOPY WMS_WAVE_PLANNING_PVT.task_id_table_type,
14322: x_return_status OUT NOCOPY VARCHAR2,
14323: x_return_msg OUT NOCOPY VARCHAR2,
14324: x_msg_count OUT NOCOPY NUMBER) IS
14325: l_task_id NUMBER;

Line 14331: l_transaction_temp_ids WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;

14327: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14328:
14329: TYPE status_table_type IS TABLE OF Varchar2(100);
14330:
14331: l_transaction_temp_ids WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14332: l_task_type_ids WMS_WAVE_PLANNING_PVT.task_type_id_table_type;
14333: l_statuses status_table_type;
14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14335: l_device_id NUMBER;

Line 14332: l_task_type_ids WMS_WAVE_PLANNING_PVT.task_type_id_table_type;

14328:
14329: TYPE status_table_type IS TABLE OF Varchar2(100);
14330:
14331: l_transaction_temp_ids WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14332: l_task_type_ids WMS_WAVE_PLANNING_PVT.task_type_id_table_type;
14333: l_statuses status_table_type;
14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14335: l_device_id NUMBER;
14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;

Line 14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;

14330:
14331: l_transaction_temp_ids WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14332: l_task_type_ids WMS_WAVE_PLANNING_PVT.task_type_id_table_type;
14333: l_statuses status_table_type;
14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14335: l_device_id NUMBER;
14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;
14337: l_message WMS_WP_TASKS_GTMP.error%TYPE;
14338: g_cannot_update_putaway WMS_WP_TASKS_GTMP.error%TYPE;

Line 14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;

14332: l_task_type_ids WMS_WAVE_PLANNING_PVT.task_type_id_table_type;
14333: l_statuses status_table_type;
14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14335: l_device_id NUMBER;
14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;
14337: l_message WMS_WP_TASKS_GTMP.error%TYPE;
14338: g_cannot_update_putaway WMS_WP_TASKS_GTMP.error%TYPE;
14339: g_task_updated WMS_WP_TASKS_GTMP.error%TYPE;
14340:

Line 15178: l_parent_temp_ids_tbl wms_wave_planning_pvt.transaction_temp_table_type;

15174: l_progress NUMBER;
15175:
15176: TYPE num_of_child_tasks_type IS TABLE OF wms_wp_tasks_gtmp.num_of_child_tasks%TYPE;
15177: l_num_of_child_tasks_tbl num_of_child_tasks_type;
15178: l_parent_temp_ids_tbl wms_wave_planning_pvt.transaction_temp_table_type;
15179: BEGIN
15180: IF l_debug = 1 THEN
15181: print_DEBUG('set_num_of_child_tasks entered ' ||
15182: TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),

Line 15303: wms_wave_planning_pvt.get_pick_fill_rate(x_return_status);

15299: end loop;
15300:
15301: -- Call to Calculate Pick Fill Rate for Released but not completed Lines
15302:
15303: wms_wave_planning_pvt.get_pick_fill_rate(x_return_status);
15304:
15305: if x_return_Status = 'S' then
15306: print_debug('Checking whether the wave can be closed. Call Check_wave_closed_status API : ',
15307: l_debug);

Line 15309: wms_wave_planning_pvt.Check_wave_closed_status(x_return_status);

15305: if x_return_Status = 'S' then
15306: print_debug('Checking whether the wave can be closed. Call Check_wave_closed_status API : ',
15307: l_debug);
15308:
15309: wms_wave_planning_pvt.Check_wave_closed_status(x_return_status);
15310: else
15311:
15312: RAISE fnd_api.g_exc_error;
15313:

Line 16949: l_transaction_temp_id_table WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;

16945: p_entity_value NUMBER,
16946: p_action_name VARCHAR2,
16947: x_return_status OUT nocopy VARCHAR2) IS
16948:
16949: l_transaction_temp_id_table WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
16950: l_task_type_id_table WMS_WAVE_PLANNING_PVT.task_type_id_table_type;
16951: row_in NUMBER := 0;
16952: l_select_query VARCHAR2(4000);
16953: l_from_query VARCHAR2(4000);

Line 16950: l_task_type_id_table WMS_WAVE_PLANNING_PVT.task_type_id_table_type;

16946: p_action_name VARCHAR2,
16947: x_return_status OUT nocopy VARCHAR2) IS
16948:
16949: l_transaction_temp_id_table WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
16950: l_task_type_id_table WMS_WAVE_PLANNING_PVT.task_type_id_table_type;
16951: row_in NUMBER := 0;
16952: l_select_query VARCHAR2(4000);
16953: l_from_query VARCHAR2(4000);
16954: l_where_query VARCHAR2(4000);

Line 16958: l_task_id_table wms_wave_planning_pvt.task_id_table_type;

16954: l_where_query VARCHAR2(4000);
16955: l_final_query VARCHAR2(4000) := NULL;
16956: type cur_typ IS ref CURSOR;
16957: c cur_typ;
16958: l_task_id_table wms_wave_planning_pvt.task_id_table_type;
16959: --x_return_status VARCHAR2(1);
16960:
16961: l_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
16962: l_updated_record NUMBER := 0;

Line 16968: l_result_table wms_wave_planning_pvt.result_table_type;

16964: l_msg_data VARCHAR2(120);
16965: l_msg_count NUMBER;
16966: l_save_count NUMBER;
16967: l_return_status VARCHAR2(120);
16968: l_result_table wms_wave_planning_pvt.result_table_type;
16969: l_message_table wms_wave_planning_pvt.message_table_type;
16970:
16971: CURSOR c_saved_actions(p_action_name varchar2) IS
16972: select field_name, field_value, query_type

Line 16969: l_message_table wms_wave_planning_pvt.message_table_type;

16965: l_msg_count NUMBER;
16966: l_save_count NUMBER;
16967: l_return_status VARCHAR2(120);
16968: l_result_table wms_wave_planning_pvt.result_table_type;
16969: l_message_table wms_wave_planning_pvt.message_table_type;
16970:
16971: CURSOR c_saved_actions(p_action_name varchar2) IS
16972: select field_name, field_value, query_type
16973: from wms_saved_queries

Line 16985: l_field_name_table wms_wave_planning_pvt.field_name_table_type;

16981: where query_name = p_action_name;
16982:
16983: rec_saved_actions c_saved_actions%rowtype;
16984:
16985: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
16986: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
16987: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
16988: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
16989:

Line 16986: l_field_value_table wms_wave_planning_pvt.field_value_table_type;

16982:
16983: rec_saved_actions c_saved_actions%rowtype;
16984:
16985: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
16986: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
16987: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
16988: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
16989:
16990: BEGIN

Line 16987: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;

16983: rec_saved_actions c_saved_actions%rowtype;
16984:
16985: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
16986: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
16987: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
16988: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
16989:
16990: BEGIN
16991:

Line 16988: l_query_type_table wms_wave_planning_pvt.query_type_table_type;

16984:
16985: l_field_name_table wms_wave_planning_pvt.field_name_table_type;
16986: l_field_value_table wms_wave_planning_pvt.field_value_table_type;
16987: l_organization_id_table wms_wave_planning_pvt.organization_id_table_type;
16988: l_query_type_table wms_wave_planning_pvt.query_type_table_type;
16989:
16990: BEGIN
16991:
16992: -- Clearing the tables.

Line 17238: print_DEBUG('Calling wms_wave_planning_pvt.UPDATE_TASK', l_debug);

17234: l_person_resource_code := NULL;
17235: END IF;
17236: /* End of Bug 5485730 */
17237: --call update task
17238: print_DEBUG('Calling wms_wave_planning_pvt.UPDATE_TASK', l_debug);
17239: print_DEBUG('Following are the input parameters', l_debug);
17240: print_DEBUG('p_employee => ' || l_employee, l_debug);
17241: print_DEBUG('p_employee_id => ' || l_employee_id, l_debug);
17242: print_DEBUG('p_user_task_type => ' || l_user_task_type, l_debug);

Line 17492: wms_wave_planning_pvt.create_batch_record(x_return_status, p_wave_id);

17488: WHERE delivery_detail_id = l_wdd_table(i);
17489: COMMIT;
17490:
17491: -- Call backorder API with the pls table as input.
17492: wms_wave_planning_pvt.create_batch_record(x_return_status, p_wave_id);
17493:
17494: IF x_return_status = 'S' THEN
17495:
17496: wsh_picking_batches_grp.release_wms_wave(p_release_mode => 'CONCURRENT',

Line 17950: 'S',Decode(wms_Wave_planning_pvt.get_loaded_status(wdd.delivery_Detail_id),1,6,2,7,Decode(Nvl(wdd.move_order_line_id,-99),-99,3,5)),

17946: Nvl(WWl.planned_FILL_RATE, 0) planned_fill_rate,
17947: Nvl(wwl.release_fill_rate,0) release_fill_rate,
17948: Nvl(wwl.pick_fill_rate,0) pick_fill_rate,
17949: Decode(wdd.released_status,
17950: 'S',Decode(wms_Wave_planning_pvt.get_loaded_status(wdd.delivery_Detail_id),1,6,2,7,Decode(Nvl(wdd.move_order_line_id,-99),-99,3,5)),
17951: 'C',11,
17952: 'B',Decode(wdd.replenishment_status,'R',4,2),
17953: 'R',1,
17954: 'K',3,

Line 18070: 'S',Decode(wms_Wave_planning_pvt.get_loaded_status(wdd.delivery_Detail_id),1,'Partially Picked',2,'Picked',Decode(Nvl(wdd.move_order_line_id,-99),-99,'Crossdock Planned','Tasked')),

18066: null,
18067: MSIV.concatenated_segments ITEM, --12642410
18068: (select meaning from FND_LOOKUP_VALUES WHERE lookup_type = 'PICK_STATUS' AND LANGUAGE = userenv('LANG') and lookup_code = wdd.released_status) line_status, --12693583
18069: Decode(wdd.released_status,
18070: 'S',Decode(wms_Wave_planning_pvt.get_loaded_status(wdd.delivery_Detail_id),1,'Partially Picked',2,'Picked',Decode(Nvl(wdd.move_order_line_id,-99),-99,'Crossdock Planned','Tasked')),
18071: 'C','Shipped',
18072: 'B',Decode(wdd.replenishment_status,'R','Replenishment Created','Backordered'),
18073: 'R','Ready to Release',
18074: 'Y',Decode(wlpn.lpn_context,11,Decode(mil.inventory_location_type,2,'Staged',4,'In Packing',5,'In Packing'),9,'Loaded to Dock')) LINE_PROGRESS,

Line 19209: WMS_WAVE_PLANNING_PVT.set_num_of_child_tasks;

19205: (wdth.transaction_source_type_id = 4
19206: and wdth.transaction_action_id = 27)
19207: );
19208:
19209: WMS_WAVE_PLANNING_PVT.set_num_of_child_tasks;
19210:
19211: insert into wms_wp_exceptions_gtmp_v(
19212: EXCEPTION_NAME,
19213: EXCEPTION_ID,

Line 19739: end WMS_WAVE_PLANNING_PVT;

19735: x_return_status := 'E';
19736:
19737: END remove_lines_endeca;
19738:
19739: end WMS_WAVE_PLANNING_PVT;
19740: