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_LMS_UTILS dependencies on DUAL

Line 193: FROM wms_els_individual_tasks_b

189: )
190: IS
191:
192: CURSOR els_history(l_org_id NUMBER,l_purge_date VARCHAR2) IS SELECT els_data_id
193: FROM wms_els_individual_tasks_b
194: WHERE history_flag = 1
195: AND organization_id = l_org_id
196: AND archive_date <= NVL (TO_DATE(l_purge_date,'YYYY/MM/DD HH24:MI:SS') ,SYSDATE);
197:

Line 247: -- delete all records from ems_els_individual_tasks table which have

243: END IF;
244:
245: l_records_deleted:=0;
246:
247: -- delete all records from ems_els_individual_tasks table which have
248: -- been marked as hsitory
249:
250: FORALL j IN l_els_id_tab.first..l_els_id_tab.last
251:

Line 252: DELETE wms_els_individual_tasks_b

248: -- been marked as hsitory
249:
250: FORALL j IN l_els_id_tab.first..l_els_id_tab.last
251:
252: DELETE wms_els_individual_tasks_b
253: WHERE els_data_id = l_els_id_tab(j);
254:
255: l_records_deleted :=SQL%ROWCOUNT;
256:

Line 258: debug('Number of records deleted from wms_els_individual_tasks_b table '|| l_records_deleted,

254:
255: l_records_deleted :=SQL%ROWCOUNT;
256:
257: IF g_debug=1 THEN
258: debug('Number of records deleted from wms_els_individual_tasks_b table '|| l_records_deleted,
259: 'PURGE_LMS_SETUP_HISTORY'
260: );
261: END IF;
262:

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 532: CURSOR els_individual_tasks_cur(l_org_id NUMBER) IS

528: * so that the values will be used to create the history records while executing
529: * the "Standardize Actual to Expected times" request.
530: */
531:
532: CURSOR els_individual_tasks_cur(l_org_id NUMBER) IS
533: SELECT ELS_DATA_ID
534: , ORGANIZATION_ID
535: , SEQUENCE_NUMBER
536: , ANALYSIS_ID

Line 578: FROM wms_els_individual_tasks_b

574: , ATTRIBUTE12
575: , ATTRIBUTE13
576: , ATTRIBUTE14
577: , ATTRIBUTE15
578: FROM wms_els_individual_tasks_b
579: WHERE organization_id= l_org_id
580: AND nvl(HISTORY_FLAG, -999) <> 1;
581:
582: /* The following cursor has been added to fetch the records from TL table

Line 586: CURSOR els_individual_tasks_tl_cur(l_els_data_id NUMBER) IS

582: /* The following cursor has been added to fetch the records from TL table
583: * for each els_data_id that is present in the base table.
584: */
585:
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

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 613: FOR els_individual_tasks_rec IN els_individual_tasks_cur(p_org_id) LOOP

609: IF g_debug=1 THEN
610: debug('Before creating History Records' , 'COPY_ACTUAL_TIMINGS');
611: END IF;
612:
613: FOR els_individual_tasks_rec IN els_individual_tasks_cur(p_org_id) LOOP
614:
615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL
616: INTO l_new_els_data_id
617: FROM dual;

Line 615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL

611: END IF;
612:
613: FOR els_individual_tasks_rec IN els_individual_tasks_cur(p_org_id) LOOP
614:
615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL
616: INTO l_new_els_data_id
617: FROM dual;
618:
619: INSERT INTO wms_els_individual_tasks_b (

Line 617: FROM dual;

613: FOR els_individual_tasks_rec IN els_individual_tasks_cur(p_org_id) LOOP
614:
615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL
616: INTO l_new_els_data_id
617: FROM dual;
618:
619: INSERT INTO wms_els_individual_tasks_b (
620: ELS_DATA_ID
621: , ORGANIZATION_ID

Line 619: INSERT INTO wms_els_individual_tasks_b (

615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL
616: INTO l_new_els_data_id
617: FROM dual;
618:
619: INSERT INTO wms_els_individual_tasks_b (
620: ELS_DATA_ID
621: , ORGANIZATION_ID
622: , SEQUENCE_NUMBER
623: , ANALYSIS_ID

Line 672: , els_individual_tasks_rec.ORGANIZATION_ID

668: , ATTRIBUTE13
669: , ATTRIBUTE14
670: , ATTRIBUTE15)
671: VALUES ( l_new_els_data_id
672: , els_individual_tasks_rec.ORGANIZATION_ID
673: , els_individual_tasks_rec.SEQUENCE_NUMBER
674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID

Line 673: , els_individual_tasks_rec.SEQUENCE_NUMBER

669: , ATTRIBUTE14
670: , ATTRIBUTE15)
671: VALUES ( l_new_els_data_id
672: , els_individual_tasks_rec.ORGANIZATION_ID
673: , els_individual_tasks_rec.SEQUENCE_NUMBER
674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID

Line 674: , els_individual_tasks_rec.ANALYSIS_ID

670: , ATTRIBUTE15)
671: VALUES ( l_new_els_data_id
672: , els_individual_tasks_rec.ORGANIZATION_ID
673: , els_individual_tasks_rec.SEQUENCE_NUMBER
674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID

Line 675: , els_individual_tasks_rec.ACTIVITY_ID

671: VALUES ( l_new_els_data_id
672: , els_individual_tasks_rec.ORGANIZATION_ID
673: , els_individual_tasks_rec.SEQUENCE_NUMBER
674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID

Line 676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID

672: , els_individual_tasks_rec.ORGANIZATION_ID
673: , els_individual_tasks_rec.SEQUENCE_NUMBER
674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY

Line 677: , els_individual_tasks_rec.OPERATION_ID

673: , els_individual_tasks_rec.SEQUENCE_NUMBER
674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID

Line 678: , els_individual_tasks_rec.EQUIPMENT_ID

674: , els_individual_tasks_rec.ANALYSIS_ID
675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY

Line 679: , els_individual_tasks_rec.SOURCE_ZONE_ID

675: , els_individual_tasks_rec.ACTIVITY_ID
676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID

Line 680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY

676: , els_individual_tasks_rec.ACTIVITY_DETAIL_ID
677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM

Line 681: , els_individual_tasks_rec.DESTINATION_ZONE_ID

677: , els_individual_tasks_rec.OPERATION_ID
678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY

Line 682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY

678: , els_individual_tasks_rec.EQUIPMENT_ID
679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY

Line 683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID

679: , els_individual_tasks_rec.SOURCE_ZONE_ID
680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID

Line 684: , els_individual_tasks_rec.TRANSACTION_UOM

680: , els_individual_tasks_rec.SOURCE_SUBINVENTORY
681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID

Line 685: , els_individual_tasks_rec.FROM_QUANTITY

681: , els_individual_tasks_rec.DESTINATION_ZONE_ID
682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID

Line 686: , els_individual_tasks_rec.TO_QUANTITY

682: , els_individual_tasks_rec.DESTINATION_SUBINVENTORY
683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID

Line 687: , els_individual_tasks_rec.ITEM_CATEGORY_ID

683: , els_individual_tasks_rec.LABOR_TXN_SOURCE_ID
684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID

Line 688: , els_individual_tasks_rec.OPERATION_PLAN_ID

684: , els_individual_tasks_rec.TRANSACTION_UOM
685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME

Line 689: , els_individual_tasks_rec.GROUP_ID

685: , els_individual_tasks_rec.FROM_QUANTITY
686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME

Line 690: , els_individual_tasks_rec.TASK_TYPE_ID

686: , els_individual_tasks_rec.TO_QUANTITY
687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME

Line 691: , els_individual_tasks_rec.TASK_METHOD_ID

687: , els_individual_tasks_rec.ITEM_CATEGORY_ID
688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME

Line 692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME

688: , els_individual_tasks_rec.OPERATION_PLAN_ID
689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME

Line 693: , els_individual_tasks_rec.EXPECTED_TXN_TIME

689: , els_individual_tasks_rec.GROUP_ID
690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME
697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME

Line 694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME

690: , els_individual_tasks_rec.TASK_TYPE_ID
691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME
697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME
698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD

Line 695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME

691: , els_individual_tasks_rec.TASK_METHOD_ID
692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME
697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME
698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD
699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.

Line 696: , els_individual_tasks_rec.ACTUAL_TXN_TIME

692: , els_individual_tasks_rec.EXPECTED_TRAVEL_TIME
693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME
697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME
698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD
699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.
700: , SYSDATE -- ARCHIVE_DATE

Line 697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME

693: , els_individual_tasks_rec.EXPECTED_TXN_TIME
694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME
697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME
698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD
699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.
700: , SYSDATE -- ARCHIVE_DATE
701: , els_individual_tasks_rec.NUM_TRX_MATCHED

Line 698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD

694: , els_individual_tasks_rec.EXPECTED_IDLE_TIME
695: , els_individual_tasks_rec.ACTUAL_TRAVEL_TIME
696: , els_individual_tasks_rec.ACTUAL_TXN_TIME
697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME
698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD
699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.
700: , SYSDATE -- ARCHIVE_DATE
701: , els_individual_tasks_rec.NUM_TRX_MATCHED
702: , FND_GLOBAL.USER_ID

Line 701: , els_individual_tasks_rec.NUM_TRX_MATCHED

697: , els_individual_tasks_rec.ACTUAL_IDLE_TIME
698: , els_individual_tasks_rec.TRAVEL_TIME_THRESHOLD
699: , 1 -- The new record created will be a history record. Hence, it takes the values as 1.
700: , SYSDATE -- ARCHIVE_DATE
701: , els_individual_tasks_rec.NUM_TRX_MATCHED
702: , FND_GLOBAL.USER_ID
703: , FND_GLOBAL.LOGIN_ID
704: , FND_GLOBAL.USER_ID
705: , SYSDATE

Line 707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY

703: , FND_GLOBAL.LOGIN_ID
704: , FND_GLOBAL.USER_ID
705: , SYSDATE
706: , SYSDATE
707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY
708: , els_individual_tasks_rec.ATTRIBUTE1
709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4

Line 708: , els_individual_tasks_rec.ATTRIBUTE1

704: , FND_GLOBAL.USER_ID
705: , SYSDATE
706: , SYSDATE
707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY
708: , els_individual_tasks_rec.ATTRIBUTE1
709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5

Line 709: , els_individual_tasks_rec.ATTRIBUTE2

705: , SYSDATE
706: , SYSDATE
707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY
708: , els_individual_tasks_rec.ATTRIBUTE1
709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6

Line 710: , els_individual_tasks_rec.ATTRIBUTE3

706: , SYSDATE
707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY
708: , els_individual_tasks_rec.ATTRIBUTE1
709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7

Line 711: , els_individual_tasks_rec.ATTRIBUTE4

707: , els_individual_tasks_rec.ATTRIBUTE_CATEGORY
708: , els_individual_tasks_rec.ATTRIBUTE1
709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8

Line 712: , els_individual_tasks_rec.ATTRIBUTE5

708: , els_individual_tasks_rec.ATTRIBUTE1
709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9

Line 713: , els_individual_tasks_rec.ATTRIBUTE6

709: , els_individual_tasks_rec.ATTRIBUTE2
710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10

Line 714: , els_individual_tasks_rec.ATTRIBUTE7

710: , els_individual_tasks_rec.ATTRIBUTE3
711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12

Line 715: , els_individual_tasks_rec.ATTRIBUTE8

711: , els_individual_tasks_rec.ATTRIBUTE4
712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13

Line 716: , els_individual_tasks_rec.ATTRIBUTE9

712: , els_individual_tasks_rec.ATTRIBUTE5
713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13
720: , els_individual_tasks_rec.ATTRIBUTE14

Line 717: , els_individual_tasks_rec.ATTRIBUTE10

713: , els_individual_tasks_rec.ATTRIBUTE6
714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13
720: , els_individual_tasks_rec.ATTRIBUTE14
721: , els_individual_tasks_rec.ATTRIBUTE15);

Line 718: , els_individual_tasks_rec.ATTRIBUTE12

714: , els_individual_tasks_rec.ATTRIBUTE7
715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13
720: , els_individual_tasks_rec.ATTRIBUTE14
721: , els_individual_tasks_rec.ATTRIBUTE15);
722:

Line 719: , els_individual_tasks_rec.ATTRIBUTE13

715: , els_individual_tasks_rec.ATTRIBUTE8
716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13
720: , els_individual_tasks_rec.ATTRIBUTE14
721: , els_individual_tasks_rec.ATTRIBUTE15);
722:
723: /* Insert the history record data in TL tables*/

Line 720: , els_individual_tasks_rec.ATTRIBUTE14

716: , els_individual_tasks_rec.ATTRIBUTE9
717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13
720: , els_individual_tasks_rec.ATTRIBUTE14
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

Line 721: , els_individual_tasks_rec.ATTRIBUTE15);

717: , els_individual_tasks_rec.ATTRIBUTE10
718: , els_individual_tasks_rec.ATTRIBUTE12
719: , els_individual_tasks_rec.ATTRIBUTE13
720: , els_individual_tasks_rec.ATTRIBUTE14
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(

Line 724: FOR els_individual_tasks_tl_rec IN els_individual_tasks_tl_cur(els_individual_tasks_rec.els_data_id) LOOP

720: , els_individual_tasks_rec.ATTRIBUTE14
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

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 736: , els_individual_tasks_tl_rec.language

732: , CREATED_BY
733: , CREATION_DATE
734: , LAST_UPDATE_DATE)
735: VALUES( l_new_els_data_id
736: , els_individual_tasks_tl_rec.language
737: , els_individual_tasks_tl_rec.source_lang
738: , els_individual_tasks_tl_rec.description
739: , FND_GLOBAL.USER_ID
740: , FND_GLOBAL.LOGIN_ID

Line 737: , els_individual_tasks_tl_rec.source_lang

733: , CREATION_DATE
734: , LAST_UPDATE_DATE)
735: VALUES( l_new_els_data_id
736: , els_individual_tasks_tl_rec.language
737: , els_individual_tasks_tl_rec.source_lang
738: , els_individual_tasks_tl_rec.description
739: , FND_GLOBAL.USER_ID
740: , FND_GLOBAL.LOGIN_ID
741: , FND_GLOBAL.USER_ID

Line 738: , els_individual_tasks_tl_rec.description

734: , LAST_UPDATE_DATE)
735: VALUES( l_new_els_data_id
736: , els_individual_tasks_tl_rec.language
737: , els_individual_tasks_tl_rec.source_lang
738: , els_individual_tasks_tl_rec.description
739: , FND_GLOBAL.USER_ID
740: , FND_GLOBAL.LOGIN_ID
741: , FND_GLOBAL.USER_ID
742: , SYSDATE

Line 754: UPDATE wms_els_individual_tasks_b

750:
751: /* End of fix for bug # 5520074 */
752:
753: --update the expected value fields with the actual values.
754: UPDATE wms_els_individual_tasks_b
755: SET
756: Expected_Travel_Time = NVL(Actual_Travel_time,Expected_Travel_Time),
757: Expected_Txn_Time = NVL(Actual_Txn_Time,Expected_Txn_Time),
758: Expected_Idle_Time = NVL(Actual_Idle_Time,Expected_Idle_Time),

Line 781: debug('Error in copying timings for Individual and manual tasks','CALCULATE_ACTUAL_TIMINGS');

777: EXCEPTION
778: WHEN OTHERS THEN
779:
780: IF g_debug=1 THEN
781: debug('Error in copying timings for Individual and manual tasks','CALCULATE_ACTUAL_TIMINGS');
782: END IF;
783:
784: l_error := l_error + 1 ;
785: END;

Line 864: SELECT els_data_id FROM WMS_ELS_INDIVIDUAL_TASKS_B WHERE

860: ) IS
861:
862:
863: CURSOR C_ELS_DATA_ID (l_organization_id NUMBER) IS
864: SELECT els_data_id FROM WMS_ELS_INDIVIDUAL_TASKS_B WHERE
865: organization_id=l_organization_id
866: and history_flag IS NULL;
867:
868: -- Ignore history rows

Line 968: UPDATE wms_els_individual_tasks_b SET

964: FORALL i IN l_els_data_id_tab.first .. l_els_data_id_tab.last
965: --Bulk update the els data table with actual timings.
966: --Bulk update is used here for performance enhancement resons.
967:
968: UPDATE wms_els_individual_tasks_b SET
969: actual_travel_time=(
970: SELECT AVG(travel_time) FROM WMS_ELS_TRX_SRC
971: WHERE els_data_id=l_els_data_id_tab(i)
972: AND NVL(Transaction_Date,SYSDATE) >= NVL(l_date,SYSDATE)

Line 1056: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_exp_resource

1052: RETURN NUMBER IS
1053: is_unprocessed NUMBER;
1054: BEGIN
1055:
1056: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_exp_resource
1057: where els_data_id IS NULL and organization_id = p_org_id
1058: );
1059: RETURN 1;
1060:

Line 1073: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_trx_src

1069: RETURN NUMBER IS
1070: is_unprocessed NUMBER;
1071: BEGIN
1072:
1073: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_trx_src
1074: where els_data_id IS NULL
1075: and organization_id = p_org_id
1076: and els_trx_src_id <= p_max_id
1077: );

Line 1431: from WMS_ELS_INDIVIDUAL_TASKS_B

1427:
1428:
1429: BEGIN
1430: select round(MAX(sequence_number),-1) into x_seq_num_ind_and_sys_directed
1431: from WMS_ELS_INDIVIDUAL_TASKS_B
1432: where group_id= 3
1433: AND history_flag IS null
1434: AND organization_id = p_org_id;-- individual group
1435: EXCEPTION

Line 1434: AND organization_id = p_org_id;-- individual group

1430: select round(MAX(sequence_number),-1) into x_seq_num_ind_and_sys_directed
1431: from WMS_ELS_INDIVIDUAL_TASKS_B
1432: where group_id= 3
1433: AND history_flag IS null
1434: AND organization_id = p_org_id;-- individual group
1435: EXCEPTION
1436: WHEN OTHERS THEN
1437: x_seq_num_ind_and_sys_directed := 0;
1438: END;

Line 1442: from WMS_ELS_INDIVIDUAL_TASKS_B

1438: END;
1439:
1440: BEGIN
1441: select round(MAX(sequence_number),-1) into x_seq_num_man_and_sys_directed
1442: from WMS_ELS_INDIVIDUAL_TASKS_B
1443: where group_id= 2
1444: AND history_flag IS null
1445: AND organization_id = p_org_id; -- manual group
1446: EXCEPTION

Line 1453: from WMS_ELS_INDIVIDUAL_TASKS_B

1449: END;
1450:
1451: BEGIN
1452: select round(MAX(sequence_number),-1) into x_seq_num_man_and_usr_directed
1453: from WMS_ELS_INDIVIDUAL_TASKS_B
1454: where group_id= 1
1455: AND history_flag IS null
1456: AND organization_id = p_org_id; -- manual group
1457: EXCEPTION

Line 1556: -- setup table(WMS_ELS_INDIVIDUAL_TASKS_B)

1552: END IF;
1553:
1554: -- Proceed if all required parameters are passed.
1555: -- get the max of the sequence numbers (as per HLD)in the
1556: -- setup table(WMS_ELS_INDIVIDUAL_TASKS_B)
1557: -- for both the Individual and the manual group.
1558:
1559: IF (P_ORG_ID IS NOT NULL) THEN
1560:

Line 1557: -- for both the Individual and the manual group.

1553:
1554: -- Proceed if all required parameters are passed.
1555: -- get the max of the sequence numbers (as per HLD)in the
1556: -- setup table(WMS_ELS_INDIVIDUAL_TASKS_B)
1557: -- for both the Individual and the manual group.
1558:
1559: IF (P_ORG_ID IS NOT NULL) THEN
1560:
1561: GET_MAX_SEQ_NUMBERS ( x_seq_num_ind_and_sys_directed => l_seq_num_ind_and_sys_directed

Line 1569: debug('The value of new seq for individual and system directed tasks '|| l_seq_num_ind_and_sys_directed,'STANDARDIZE_LINES');

1565: , p_org_id => p_org_id
1566: );
1567:
1568: IF g_debug=1 THEN
1569: debug('The value of new seq for individual and system directed tasks '|| l_seq_num_ind_and_sys_directed,'STANDARDIZE_LINES');
1570: debug('The value of new seq for manual and system directed tasks '|| l_seq_num_man_and_sys_directed,'STANDARDIZE_LINES');
1571: debug('The value of new seq for manual and user directed tasks '|| l_seq_num_man_and_usr_directed,'STANDARDIZE_LINES');
1572: debug('The value of new seq for grouped tasks '|| l_seq_num_grouped,'STANDARDIZE_LINES');
1573: END IF;

Line 1590: debug('Before inserting into individual tasks table','STANDARDIZE_LINES');

1586:
1587: END IF;
1588:
1589: IF g_debug=1 THEN
1590: debug('Before inserting into individual tasks table','STANDARDIZE_LINES');
1591: END IF;
1592:
1593:
1594:

Line 1654: -- Inserting into individual or manual tasks table.

1650: end loop;
1651:
1652: ----------------------------------------------------------------------------
1653: --
1654: -- Inserting into individual or manual tasks table.
1655: --
1656: ----------------------------------------------------------------------------
1657:
1658:

Line 1668: INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B

1664: BEGIN
1665: -- dbms_output.put_line(l_els_trx_src_id || ' els_trx_src_id value');
1666: if( l_els_trx_src_id <> 0 ) then
1667:
1668: INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B
1669: (
1670: els_data_id
1671: , organization_id
1672: , sequence_number

Line 1704: wms_els_individual_tasks_s.nextval

1700: , created_by
1701: , creation_date
1702: )
1703: SELECT
1704: wms_els_individual_tasks_s.nextval
1705: , organization_id
1706: , decode(group_id,1,nvl(l_seq_num_man_and_usr_directed,0)+10,
1707: 2,nvl(l_seq_num_man_and_sys_directed,0) + 10,
1708: 3,nvl(l_seq_num_ind_and_sys_directed,0) + 10

Line 1778: debug('Error Occured in Individual Task Insertion ' || SQLERRM ,'STANDARDIZE_LINES');

1774: X_NUM_LINES_INSERTED_TASKS := 0;
1775: X_NUM_LINES_INSERTED_GROUP := 0;
1776:
1777: IF g_debug=1 THEN
1778: debug('Error Occured in Individual Task Insertion ' || SQLERRM ,'STANDARDIZE_LINES');
1779: END IF;
1780:
1781: return;
1782: END;

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 1813: FROM WMS_ELS_INDIVIDUAL_TASKS_B b,

1809: , b.last_update_login
1810: , b.created_by
1811: , b.creation_date
1812: , b.last_update_date
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

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 1827: debug('Num lines inserted into WMS_ELS_INDIVIDUAL_TASKS_B '||X_NUM_LINES_INSERTED_TASKS ,'STANDARDIZE_LINES');

1823: --X_NUM_LINES_INSERTED_TASKS := SQL%ROWCOUNT;
1824:
1825:
1826: IF g_debug=1 THEN
1827: debug('Num lines inserted into WMS_ELS_INDIVIDUAL_TASKS_B '||X_NUM_LINES_INSERTED_TASKS ,'STANDARDIZE_LINES');
1828: debug('Before inserting into grouped tasks table','STANDARDIZE_LINES');
1829: END IF;
1830:
1831:

Line 2040: debug('The value of new seq for individual and system directed tasks '|| l_seq_num_ind_and_sys_directed,'STANDARDIZE_LINES_CP');

2036: , x_seq_num_grouped => l_seq_num_grouped
2037: , p_org_id => p_org_id
2038: );
2039: IF g_debug=1 THEN
2040: debug('The value of new seq for individual and system directed tasks '|| l_seq_num_ind_and_sys_directed,'STANDARDIZE_LINES_CP');
2041: debug('The value of new seq for manual and system directed tasks '|| l_seq_num_man_and_sys_directed,'STANDARDIZE_LINES_CP');
2042: debug('The value of new seq for manual and user directed tasks '|| l_seq_num_man_and_usr_directed,'STANDARDIZE_LINES_CP');
2043: debug('The value of new seq for grouped tasks '|| l_seq_num_grouped,'STANDARDIZE_LINES_CP');
2044: END IF;

Line 2075: ' INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B '

2071: BEGIN
2072: -- for manual and user directed tasks
2073:
2074: EXECUTE IMMEDIATE
2075: ' INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B '
2076: || ' ( '
2077: || ' els_data_id '
2078: || ' , organization_id '
2079: || ' , sequence_number '

Line 2107: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id

2103: || ' , created_by '
2104: || ' , creation_date '
2105: || ' ) '
2106: || ' SELECT '
2107: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id
2108: || ' , organization_id ' --organization_id
2109: || ' , nvl ( ' || l_seq_num_man_and_usr_directed || ',0)+10*ROWNUM ' --sequence_number
2110: || ' , ' || p_analysis_type --analysis_id
2111: || ' , activity_id ' --activity_id

Line 2191: ' INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B '

2187: -- for manual and system directed tasks
2188: BEGIN
2189:
2190: EXECUTE IMMEDIATE
2191: ' INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B '
2192: || ' ( '
2193: || ' els_data_id '
2194: || ' , organization_id '
2195: || ' , sequence_number '

Line 2223: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id

2219: || ' , created_by '
2220: || ' , creation_date '
2221: || ' ) '
2222: || ' SELECT '
2223: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id
2224: || ' , organization_id ' --organization_id
2225: || ' , nvl ( ' || l_seq_num_man_and_sys_directed || ',0)+10*ROWNUM ' --sequence_number
2226: || ' , ' || p_analysis_type --analysis_id
2227: || ' , activity_id ' --activity_id

Line 2304: -- for individual and system directed tasks

2300: END;
2301:
2302: l_num_lines_inserted :=0;--reinitialize
2303:
2304: -- for individual and system directed tasks
2305:
2306: BEGIN
2307:
2308: EXECUTE IMMEDIATE

Line 2309: ' INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B '

2305:
2306: BEGIN
2307:
2308: EXECUTE IMMEDIATE
2309: ' INSERT INTO WMS_ELS_INDIVIDUAL_TASKS_B '
2310: || ' ( '
2311: || ' els_data_id '
2312: || ' , organization_id '
2313: || ' , sequence_number '

Line 2341: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id

2337: || ' , created_by '
2338: || ' , creation_date '
2339: || ' ) '
2340: || ' SELECT '
2341: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id
2342: || ' , organization_id ' --organization_id
2343: || ' , nvl ( ' || l_seq_num_ind_and_sys_directed || ',0)+10*ROWNUM ' --sequence_number
2344: || ' , ' || p_analysis_type --analysis_id
2345: || ' , activity_id ' --activity_id

Line 2405: debug('Standardization for individual and system directed tasks successfull','STANDARDIZE_LINES_CP');

2401:
2402: l_num_lines_inserted := SQL%ROWCOUNT;
2403:
2404: IF g_debug=1 THEN
2405: debug('Standardization for individual and system directed tasks successfull','STANDARDIZE_LINES_CP');
2406: debug('Number of lines inserted for individual and system directed tasks'|| l_num_lines_inserted,'STANDARDIZE_LINES_CP');
2407: END IF;
2408:
2409: EXCEPTION

Line 2406: debug('Number of lines inserted for individual and system directed tasks'|| l_num_lines_inserted,'STANDARDIZE_LINES_CP');

2402: l_num_lines_inserted := SQL%ROWCOUNT;
2403:
2404: IF g_debug=1 THEN
2405: debug('Standardization for individual and system directed tasks successfull','STANDARDIZE_LINES_CP');
2406: debug('Number of lines inserted for individual and system directed tasks'|| l_num_lines_inserted,'STANDARDIZE_LINES_CP');
2407: END IF;
2408:
2409: EXCEPTION
2410: WHEN OTHERS THEN

Line 2412: debug('Standardization for individual and system directed tasks failed'||SQLERRM,'STANDARDIZE_LINES_CP');

2408:
2409: EXCEPTION
2410: WHEN OTHERS THEN
2411: IF g_debug=1 THEN
2412: debug('Standardization for individual and system directed tasks failed'||SQLERRM,'STANDARDIZE_LINES_CP');
2413: END IF;
2414:
2415: l_num_sql_failed := l_num_sql_failed + 1;
2416: l_which_group_failed := l_which_group_failed || '3,';

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 2461: FROM WMS_ELS_INDIVIDUAL_TASKS_B b,

2457: , b.last_update_login
2458: , b.created_by
2459: , b.creation_date
2460: , b.last_update_date
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

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 2488: -- Now when the insertion to WMS_ELS_INDIVIDUAL_TASKS_B and

2484: RETURN;
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

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:

Line 2499: FROM dual;

2495: IF (l_which_group_failed IS NOT NULL) THEN
2496:
2497: SELECT substr(l_which_group_failed,0,length(l_which_group_failed)-1)
2498: INTO l_which_group_failed
2499: FROM dual;
2500:
2501: IF g_debug=1 THEN
2502: debug('Value of l_which_group_failed '||l_which_group_failed,'STANDARDIZE_LINES_CP');
2503: END IF;