DBA Data[Home] [Help]

APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_LTP_RESRC_LEVL_PVT

Line 1: PACKAGE BODY AHL_LTP_RESRC_LEVL_PVT AS

1: PACKAGE BODY AHL_LTP_RESRC_LEVL_PVT AS
2: /* $Header: AHLVRLGB.pls 120.8 2008/02/25 11:35:34 rnahata ship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_RESRC_LEVL_PVT';
5: G_OPER_ASSOC_TYPE CONSTANT VARCHAR2(30) := 'OPERATION';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_RESRC_LEVL_PVT';

1: PACKAGE BODY AHL_LTP_RESRC_LEVL_PVT AS
2: /* $Header: AHLVRLGB.pls 120.8 2008/02/25 11:35:34 rnahata ship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_RESRC_LEVL_PVT';
5: G_OPER_ASSOC_TYPE CONSTANT VARCHAR2(30) := 'OPERATION';
6: G_RT_ASSOC_TYPE CONSTANT VARCHAR2(30) := 'ROUTE';
7: G_SECS_IN_DAY CONSTANT NUMBER := 86400;
8: G_SECS_IN_HOUR CONSTANT NUMBER := 3600;

Line 374: x_visit_task_times_tbl OUT NOCOPY AHL_LTP_RESRC_LEVL_PVT.Visit_Task_Times_Tbl_Type,

370: p_end_time IN DATE := NULL,
371: x_visit_start_time OUT NOCOPY DATE,
372: x_visit_end_time OUT NOCOPY DATE,
373: x_visit_end_hour OUT NOCOPY NUMBER,
374: x_visit_task_times_tbl OUT NOCOPY AHL_LTP_RESRC_LEVL_PVT.Visit_Task_Times_Tbl_Type,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2
378: ) IS

Line 575: x_plan_rsrc_tbl OUT NOCOPY AHL_LTP_RESRC_LEVL_PVT.Plan_Rsrc_Tbl_Type,

571: p_org_name IN VARCHAR2,
572: p_plan_id IN NUMBER,
573: p_start_time IN DATE,
574: p_end_time IN DATE,
575: x_plan_rsrc_tbl OUT NOCOPY AHL_LTP_RESRC_LEVL_PVT.Plan_Rsrc_Tbl_Type,
576: x_return_status OUT NOCOPY VARCHAR2,
577: x_msg_count OUT NOCOPY NUMBER,
578: x_msg_data OUT NOCOPY VARCHAR2
579: ) IS

Line 841: x_per_rsrc_tbl OUT NOCOPY Ahl_Ltp_Resrc_Levl_Pvt.Period_Rsrc_Req_Tbl_Type,

837: p_start_time IN DATE,
838: p_end_time IN DATE,
839: p_UOM_code IN VARCHAR2,
840: p_required_capacity IN NUMBER,
841: x_per_rsrc_tbl OUT NOCOPY Ahl_Ltp_Resrc_Levl_Pvt.Period_Rsrc_Req_Tbl_Type,
842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER,
844: x_msg_data OUT NOCOPY VARCHAR2
845: ) IS

Line 1541: x_task_req_tbl OUT NOCOPY AHL_LTP_RESRC_LEVL_PVT.Task_Requirement_Tbl_Type,

1537: p_dstart_time IN DATE,
1538: p_dend_time IN DATE,
1539: p_resource_id IN NUMBER,
1540: p_aso_bom_rsrc_type IN VARCHAR2,
1541: x_task_req_tbl OUT NOCOPY AHL_LTP_RESRC_LEVL_PVT.Task_Requirement_Tbl_Type,
1542: x_return_status OUT NOCOPY VARCHAR2,
1543: x_msg_count OUT NOCOPY NUMBER,
1544: x_msg_data OUT NOCOPY VARCHAR2
1545: ) IS

Line 4950: END Ahl_Ltp_Resrc_Levl_Pvt;

4946: END Append_WIP_Requirements;
4947:
4948: -- JARAMANA 24Aug2005 ends
4949: --
4950: END Ahl_Ltp_Resrc_Levl_Pvt;