APPS.WMS_LMS_UTILS dependencies on WMS_ELS_INDIVIDUAL_TASKS_TL

Line 267: DELETE wms_els_individual_tasks_tl

263: l_records_deleted:=0;
264:
265: FORALL k IN l_els_id_tab.first..l_els_id_tab.last
266:
267: DELETE wms_els_individual_tasks_tl
268: WHERE els_data_id = l_els_id_tab(k);
269:
270: l_records_deleted :=SQL%ROWCOUNT;
271:

Line 273: debug('Number of records deleted from wms_els_individual_tasks_tl table '|| l_records_deleted,

269:
270: l_records_deleted :=SQL%ROWCOUNT;
271:
272: IF g_debug=1 THEN
273: debug('Number of records deleted from wms_els_individual_tasks_tl table '|| l_records_deleted,
274: 'PURGE_LMS_SETUP_HISTORY'
275: );
276: END IF;
277:

Line 590: FROM wms_els_individual_tasks_tl

586: CURSOR els_individual_tasks_tl_cur(l_els_data_id NUMBER) IS
587: SELECT description
588: , language
589: , source_lang
590: FROM wms_els_individual_tasks_tl
591: WHERE els_data_id = l_els_data_id;
592:
593: l_new_els_data_id NUMBER;
594:

Line 725: INSERT INTO wms_els_individual_tasks_tl(

721: , els_individual_tasks_rec.ATTRIBUTE15);
722:
723: /* Insert the history record data in TL tables*/
724: FOR els_individual_tasks_tl_rec IN els_individual_tasks_tl_cur(els_individual_tasks_rec.els_data_id) LOOP
725: INSERT INTO wms_els_individual_tasks_tl(
726: ELS_DATA_ID
727: , LANGUAGE
728: , SOURCE_LANG
729: , DESCRIPTION

Line 1792: INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_TL

1788:
1789: --We dont know how many new rows are created in the Base table. Also we dont have the els_Data_id's of all those rows.
1790: --So we have the inner select Query.
1791:
1792: INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_TL
1793: (
1794: els_data_id,
1795: language,
1796: source_lang,

Line 1817: FROM wms_els_individual_tasks_tl

1813: FROM WMS_ELS_INDIVIDUAL_TASKS_B b,
1814: FND_LANGUAGES L
1815: WHERE els_data_id NOT IN (
1816: SELECT DISTINCT els_data_id
1817: FROM wms_els_individual_tasks_tl
1818: )
1819: AND L.INSTALLED_FLAG in ('I', 'B');
1820:
1821:

Line 2440: INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_TL

2436:
2437: BEGIN
2438: -- insert lines into TL table for all lines inserted into Base tables
2439:
2440: INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_TL
2441: (
2442: els_data_id,
2443: language,
2444: source_lang,

Line 2465: FROM wms_els_individual_tasks_tl

2461: FROM WMS_ELS_INDIVIDUAL_TASKS_B b,
2462: FND_LANGUAGES L
2463: WHERE els_data_id NOT IN (
2464: SELECT DISTINCT els_data_id
2465: FROM wms_els_individual_tasks_tl
2466: )
2467: AND L.INSTALLED_FLAG in ('I', 'B');
2468:
2469: EXCEPTION

Line 2489: -- WMS_ELS_INDIVIDUAL_TASKS_TL table is successfull now we can proceed

2485:
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: