APPS.WMS_LMS_UTILS dependencies on WMS_ELS_GROUPED_TASKS_B

Line 794: UPDATE wms_els_grouped_tasks_b

790:
791:
792: BEGIN
793: --update the expected value fields with the actual values.
794: UPDATE wms_els_grouped_tasks_b
795: SET
796: Expected_Travel_Time = NVL(Actual_Travel_time,Expected_Travel_Time)
797: WHERE
798: organization_id= p_org_id;

Line 1464: from WMS_ELS_GROUPED_TASKS_B

1460: END;
1461:
1462: BEGIN
1463: select round(MAX(sequence_number),-1) into x_seq_num_grouped
1464: from WMS_ELS_GROUPED_TASKS_B
1465: where organization_id = p_org_id; -- grouped tasks
1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: x_seq_num_grouped := 0;

Line 1841: 'INSERT INTO WMS_ELS_GROUPED_TASKS_B' ||

1837: ----------------------------------------------------------------------------
1838:
1839: --l_query1 :=
1840: EXECUTE IMMEDIATE
1841: 'INSERT INTO WMS_ELS_GROUPED_TASKS_B' ||
1842: '(' ||
1843: ' Els_Group_Id' ||
1844: ' , Organization_id' ||
1845: ' , Sequence_Number' ||

Line 1951: FROM WMS_ELS_GROUPED_TASKS_B b,

1947: b.last_update_login,
1948: b.created_by,
1949: b.creation_date,
1950: b.last_update_date
1951: FROM WMS_ELS_GROUPED_TASKS_B b,
1952: FND_LANGUAGES L
1953: WHERE els_group_id NOT IN (
1954: SELECT DISTINCT els_group_id
1955: FROM wms_els_grouped_tasks_tl

Line 2490: -- to inserting lines in the WMS_ELS_GROUPED_TASKS_B and WMS_ELS_GROUPED_TASKS_TL table

2486: END;
2487:
2488: -- Now when the insertion to WMS_ELS_INDIVIDUAL_TASKS_B and
2489: -- WMS_ELS_INDIVIDUAL_TASKS_TL table is successfull now we can proceed
2490: -- to inserting lines in the WMS_ELS_GROUPED_TASKS_B and WMS_ELS_GROUPED_TASKS_TL table
2491:
2492: l_num_lines_inserted :=0;--reinitialize
2493:
2494:

Line 2516: 'INSERT INTO WMS_ELS_GROUPED_TASKS_B' ||

2512:
2513: BEGIN
2514:
2515: EXECUTE IMMEDIATE
2516: 'INSERT INTO WMS_ELS_GROUPED_TASKS_B' ||
2517: '(' ||
2518: ' Els_Group_Id' ||
2519: ' , Organization_id' ||
2520: ' , Sequence_Number' ||

Line 2618: -- proceed with TL table only when insertion to WMS_ELS_GROUPED_TASKS_B is a success

2614: RETURN;
2615:
2616: END;
2617:
2618: -- proceed with TL table only when insertion to WMS_ELS_GROUPED_TASKS_B is a success
2619:
2620: BEGIN
2621:
2622: INSERT INTO WMS_ELS_GROUPED_TASKS_TL

Line 2643: FROM WMS_ELS_GROUPED_TASKS_B b,

2639: b.last_update_login,
2640: b.created_by,
2641: b.creation_date,
2642: b.last_update_date
2643: FROM WMS_ELS_GROUPED_TASKS_B b,
2644: FND_LANGUAGES L
2645: WHERE els_group_id NOT IN (
2646: SELECT DISTINCT els_group_id
2647: FROM wms_els_grouped_tasks_tl