APPS.WMS_LMS_LABOR_PRODUCTIVITY dependencies on WMS_ELS_GROUPED_TASKS_B

Line 29: -- table with the setup rows in wms_els_individual_tasks_b and wms_els_grouped_tasks_b

25:
26:
27:
28: -- This procedure will match all the transaction records in wms_els_trx_src
29: -- table with the setup rows in wms_els_individual_tasks_b and wms_els_grouped_tasks_b
30: --It will DO the following
31:
32: -- 1) do the matching of transaction data with els data. Start with the setup row
33: -- with least sequnce.Update the els_data_id column of WMS_ELS_TRX_SRC table

Line 97: FROM wms_els_grouped_tasks_b

93: task_range_from,
94: task_range_to,
95: group_size,
96: expected_travel_time
97: FROM wms_els_grouped_tasks_b
98: WHERE organization_id = l_org_id
99: ORDER BY sequence_number;
100:
101: CURSOR c_els_grouped_data_id(l_org_id NUMBER) IS

Line 103: FROM wms_els_grouped_tasks_b

99: ORDER BY sequence_number;
100:
101: CURSOR c_els_grouped_data_id(l_org_id NUMBER) IS
102: SELECT els_group_id
103: FROM wms_els_grouped_tasks_b
104: WHERE organization_id = l_org_id;
105:
106:
107:

Line 694: debug('Opening cursor for wms_els_grouped_tasks_b ','MATCH_RATE_TRX_RECORDS');

690:
691:
692: -- open the cursor for the passed org_id
693: IF g_debug=1 THEN
694: debug('Opening cursor for wms_els_grouped_tasks_b ','MATCH_RATE_TRX_RECORDS');
695: END IF;
696:
697: OPEN c_els_grouped_data(p_org_id);
698:

Line 707: debug('Start building the where clause for wms_els_grouped_tasks_b ','MATCH_RATE_TRX_RECORDS');

703: -- open the cursor for the passed org_id
704: BEGIN
705:
706: IF g_debug=1 THEN
707: debug('Start building the where clause for wms_els_grouped_tasks_b ','MATCH_RATE_TRX_RECORDS');
708: END IF;
709:
710: l_where_clause := NULL;
711: l_update_count := 0;

Line 877: -- start updating the catual timings in the wms_els_grouped_tasks_b table

873: END LOOP; -- matching for groups is done
874:
875: CLOSE c_els_grouped_data;
876:
877: -- start updating the catual timings in the wms_els_grouped_tasks_b table
878: OPEN c_els_grouped_data_id(p_org_id);
879: LOOP
880: FETCH c_els_grouped_data_id INTO l_group_data_id;
881: EXIT WHEN c_els_grouped_data_id%NOTFOUND;

Line 889: UPDATE WMS_ELS_GROUPED_TASKS_B SET actual_travel_time = (NVL(actual_travel_time,0) + l_avg_travel_time)/2

885:
886:
887: IF( l_avg_travel_time IS NOT NULL) THEN
888:
889: UPDATE WMS_ELS_GROUPED_TASKS_B SET actual_travel_time = (NVL(actual_travel_time,0) + l_avg_travel_time)/2
890: where els_group_id = l_group_data_id.els_group_id;
891:
892: END IF;
893: