[Home] [Help]
88: END;
89:
90: PROCEDURE wwtt_dump
91: IS
92: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
93: CURSOR cur_wwtt
94: IS
95: SELECT transaction_temp_id, task_id, is_modified, status_id,
96: status_id_original, person_id, person_id_original, priority,
165:
166: visible_columns visible_columns_type;
167: l_user_id NUMBER;
168: BEGIN
169: fnd_profile.get ('USER_ID', l_user_id);
170:
171: SELECT NVL (jcgc.visible_flag, jgc.visible_flag)
172: BULK COLLECT INTO visible_columns
173: FROM jtf_grid_cols_b jgc, jtf_custom_grid_cols jcgc
470: --associated with parent tasks
471: PROCEDURE set_num_of_child_tasks
472: IS
473: l_debug NUMBER
474: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
475: l_progress NUMBER;
476:
477: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;
478:
2115: )
2116: RETURN VARCHAR2
2117: IS
2118: l_where_generic VARCHAR2 (4000);
2119: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2120: --R12: Additional Query criteria
2121: --Age UOM conversion factor
2122: n VARCHAR2 (10);
2123: BEGIN
3741: --Age UOM conversion factor
3742: n VARCHAR2 (10);
3743:
3744: l_debug NUMBER
3745: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3746:
3747: BEGIN
3748:
3749: if (p_from_sales_order_id = p_to_sales_order_id) then
5863: l_is_completed BOOLEAN;
5864: l_wms_task_type NUMBER; -- for bug 5129375
5865: l_task_count NUMBER;
5866: l_debug NUMBER
5867: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
5868: BEGIN
5869: IF p_is_completed THEN
5870:
5871: /*Bug 3627575:Setting the variable to true for Inbound queries*/
7153: --R12: Additional Query criteria
7154: --Age UOM conversion factor
7155: n VARCHAR2 (10);
7156: l_debug NUMBER
7157: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
7158: BEGIN
7159: -- Cycle tasks currently cannot have priorities, quantities or dest sub/loc. If user wants to
7160: -- query up tasks with certain priorities, quantities or dest sub/loc, we should not
7161: -- query cycle count tasks.
8278: l_is_completed BOOLEAN;
8279: l_wms_task_type NUMBER; -- for bug 5129375
8280: l_task_count NUMBER;
8281: l_debug NUMBER
8282: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
8283: BEGIN
8284: IF p_is_completed THEN
8285:
8286: /*Bug 3627575:Setting the variable to true for Inbound queries*/
8885: l_is_dispatched BOOLEAN;
8886: l_is_active BOOLEAN;
8887: l_is_loaded BOOLEAN;
8888: l_is_completed BOOLEAN;
8889: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
8890:
8891: BEGIN
8892: IF p_is_completed
8893: THEN
9388: )
9389: IS
9390: l_parent_inserted NUMBER := 0;
9391: l_is_pending BOOLEAN := p_is_pending;
9392: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9393: BEGIN
9394: x_return_status := 'S';
9395:
9396: -- Delete any existing records in the temp table
9974: IS
9975: l_task_id NUMBER;
9976: l_index NUMBER;
9977: l_message wms_waveplan_tasks_temp.error%TYPE;
9978: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9979:
9980: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
9981:
9982: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;
10594: l_update_date DATE;
10595: l_non_cycle_count_number NUMBER := 0;
10596: l_cycle_count_number NUMBER := 0;
10597: l_children_task_count NUMBER := 0;
10598: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10599:
10600: CURSOR cur_wwtt
10601: IS
10602: SELECT transaction_temp_id, task_type_id, mmtt_last_updated_by,
11544: l_msg_data VARCHAR2 (2000);
11545: l_msg_count NUMBER;
11546: l_error_code NUMBER;
11547: l_cancel_plan BOOLEAN;
11548: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
11549: BEGIN
11550:
11551: FOR i IN 1 .. p_transaction_temp_table.COUNT
11552: LOOP