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.AHL_AMP_WORKBENCH_PVT dependencies on AHL_AMP_WORKBENCH_PVT

Line 1: PACKAGE BODY AHL_AMP_WORKBENCH_PVT AS

1: PACKAGE BODY AHL_AMP_WORKBENCH_PVT AS
2: /* $Header: AHLVAMPB.pls 120.0.12020000.2 2012/12/10 16:59:08 prakkum noship $ */
3:
4: -----------------------------------------------------------------
5: -- Define Global CONSTANTS --

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_AMP_WORKBENCH_PVT';

4: -----------------------------------------------------------------
5: -- Define Global CONSTANTS --
6: -----------------------------------------------------------------
7: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_AMP_WORKBENCH_PVT';
9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
10: ------------------------------------
11: -- Common constants and variables --
12: ------------------------------------

Line 160: l_number_of_days := AHL_AMP_WORKBENCH_PVT.GET_NUMBER_OF_WORKING_DAYS(p_org_id,p_dept_id,p_start_dt,p_end_date);

156:
157: BEGIN
158: l_remaining_units := GREATEST(p_usage_units,p_applied_units) - p_applied_units;
159:
160: l_number_of_days := AHL_AMP_WORKBENCH_PVT.GET_NUMBER_OF_WORKING_DAYS(p_org_id,p_dept_id,p_start_dt,p_end_date);
161:
162: IF l_number_of_days =0 THEN
163: RETURN NULL;
164: END IF;

Line 182: l_new_req_end_date := AHL_AMP_WORKBENCH_PVT.GET_NEXT_WORKING_DATE(p_org_id,p_dept_id,sysdate,l_more_days_needed);

178: l_more_days_needed := l_more_days_needed +1;
179: END IF;
180:
181: IF p_start_dt <= sysdate THEN
182: l_new_req_end_date := AHL_AMP_WORKBENCH_PVT.GET_NEXT_WORKING_DATE(p_org_id,p_dept_id,sysdate,l_more_days_needed);
183: ELSE
184: l_new_req_end_date := AHL_AMP_WORKBENCH_PVT.GET_NEXT_WORKING_DATE(p_org_id,p_dept_id,p_start_dt,l_more_days_needed);
185: END IF;
186:

Line 184: l_new_req_end_date := AHL_AMP_WORKBENCH_PVT.GET_NEXT_WORKING_DATE(p_org_id,p_dept_id,p_start_dt,l_more_days_needed);

180:
181: IF p_start_dt <= sysdate THEN
182: l_new_req_end_date := AHL_AMP_WORKBENCH_PVT.GET_NEXT_WORKING_DATE(p_org_id,p_dept_id,sysdate,l_more_days_needed);
183: ELSE
184: l_new_req_end_date := AHL_AMP_WORKBENCH_PVT.GET_NEXT_WORKING_DATE(p_org_id,p_dept_id,p_start_dt,l_more_days_needed);
185: END IF;
186:
187: RETURN l_new_req_end_date;
188: END;

Line 225: l_rem_number_of_days := AHL_AMP_WORKBENCH_PVT.GET_NUMBER_OF_WORKING_DAYS(p_org_id,p_dept_id,l_start_dt,p_end_date);

221: l_start_dt := sysdate;
222: ELSE
223: l_start_dt := p_start_date;
224: END IF ;
225: l_rem_number_of_days := AHL_AMP_WORKBENCH_PVT.GET_NUMBER_OF_WORKING_DAYS(p_org_id,p_dept_id,l_start_dt,p_end_date);
226:
227: -- Calcualte he capacity
228: IF l_rem_number_of_days = 0 THEN /* if no working day found i.e during holiday then the resource capacity is 0*/
229: l_req_on_cal_date:= 0;

Line 313: SELECT SUM (AHL_AMP_WORKBENCH_PVT.GET_DAY_REQUIREMENT(NVL(wor.usage_rate_or_amount,0),

309:
310: --cursor 1 Resource_requirement
311: CURSOR c_resource_req(c_oranization_id NUMBER,c_department_id NUMBER, c_on_date DATE, c_resource_id NUMBER)
312: IS
313: SELECT SUM (AHL_AMP_WORKBENCH_PVT.GET_DAY_REQUIREMENT(NVL(wor.usage_rate_or_amount,0),
314: NVL(wor.APPLIED_RESOURCE_UNITS,0),wor.organization_id,c_department_id,wor.start_date,wor.completion_date,c_on_date)) req_amt, wor.uom_code
315: FROM wip_operation_resources wor,
316: wip_discrete_jobs wdj,
317: wip_entities wip

Line 354: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : ASCP plan date = '|| x_plan_date );

350: SELECT MAX(ASCP_PLAN_DATE)
351: INTO x_plan_date
352: FROM AHL_DEPT_RESOURCE_CAPACITY;
353: IF G_DEBUG = 'Y' THEN
354: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : ASCP plan date = '|| x_plan_date );
355: END IF;
356:
357: -- set the start date
358: l_start_date := TRUNC(p_start_date);

Line 368: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : EXITING after reached NO. of records = '|| l_output_record_counter );

364: FOR cur_date IN c_working_dates(p_organization_id,p_department_id,l_start_date,p_no_of_days)
365: LOOP
366: IF l_output_record_counter >= ( p_no_of_days -1 ) THEN
367: IF G_DEBUG = 'Y' THEN
368: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : EXITING after reached NO. of records = '|| l_output_record_counter );
369: END IF;
370: EXIT; -- number fo records reached . SO exit from main loop. actually this condition is not needed. but added to handle cornercases
371: END IF;
372:

Line 376: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : reached NO. of records = '|| l_output_record_counter );

372:
373: l_output_record_counter := l_output_record_counter+1;
374: l_curr_date := cur_date.cal_date;
375: IF G_DEBUG = 'Y' THEN
376: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : reached NO. of records = '|| l_output_record_counter );
377: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : DATE = '|| l_curr_date );
378: END IF;
379:
380: -- set the date

Line 377: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : DATE = '|| l_curr_date );

373: l_output_record_counter := l_output_record_counter+1;
374: l_curr_date := cur_date.cal_date;
375: IF G_DEBUG = 'Y' THEN
376: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : reached NO. of records = '|| l_output_record_counter );
377: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : DATE = '|| l_curr_date );
378: END IF;
379:
380: -- set the date
381: p_x_resource_output(l_output_record_counter).on_date := l_curr_date;

Line 397: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : REq = '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' req units = ' ||l_requirement);

393: l_requirement:=0;
394: END IF;
395:
396: IF G_DEBUG = 'Y' THEN
397: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : REq = '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' req units = ' ||l_requirement);
398: END IF;
399:
400: -- get the resource avail
401: OPEN c_resource_avail(p_organization_id,p_department_id,p_x_resource_input(l_index).resource_id,l_curr_date);

Line 408: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : AVAIL= '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' avail units = ' ||l_availability);

404: l_availability :=0;
405: END IF;
406:
407: IF G_DEBUG = 'Y' THEN
408: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : AVAIL= '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' avail units = ' ||l_availability);
409: END IF;
410:
411: -- clacualte capacity
412: IF l_availability = 0 AND l_requirement = 0 THEN

Line 426: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case index = '|| l_index );

422: l_capacity:= p_max_range;
423: END IF;
424:
425: IF G_DEBUG = 'Y' THEN
426: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case index = '|| l_index );
427: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case resource Id = '|| p_x_resource_input(l_index).resource_id );
428: END IF;
429: CASE (l_index )
430: WHEN 1 THEN

Line 427: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case resource Id = '|| p_x_resource_input(l_index).resource_id );

423: END IF;
424:
425: IF G_DEBUG = 'Y' THEN
426: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case index = '|| l_index );
427: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case resource Id = '|| p_x_resource_input(l_index).resource_id );
428: END IF;
429: CASE (l_index )
430: WHEN 1 THEN
431: p_x_resource_output(l_output_record_counter).r1_capacity := l_capacity;

Line 1803: END AHL_AMP_WORKBENCH_PVT;

1799: CLOSE c_fleet_id_for_unit;
1800: RETURN NULL;
1801: END GET_FLEET_HEADER_ID;
1802:
1803: END AHL_AMP_WORKBENCH_PVT;