DBA Data[Home] [Help]

APPS.WMS_LMS_UTILS dependencies on WMS_ELS_GROUPED_TASKS_TL

Line 1930: INSERT INTO WMS_ELS_GROUPED_TASKS_TL

1926: IF g_debug=1 THEN
1927: debug('Num lines inserted in groups table'||X_NUM_LINES_INSERTED_GROUP ,'STANDARDIZE_LINES');
1928: END IF;
1929:
1930: INSERT INTO WMS_ELS_GROUPED_TASKS_TL
1931: (
1932: els_group_id,
1933: language,
1934: source_lang,

Line 1955: FROM wms_els_grouped_tasks_tl

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
1956: )
1957: AND L.INSTALLED_FLAG in ('I', 'B');
1958:
1959:

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 2622: INSERT INTO WMS_ELS_GROUPED_TASKS_TL

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
2623: (
2624: els_group_id,
2625: language,
2626: source_lang,

Line 2647: FROM wms_els_grouped_tasks_tl

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
2648: )
2649: AND L.INSTALLED_FLAG in ('I', 'B');
2650:
2651: EXCEPTION