APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on EAM_FAILURE_ANALYSIS_PVT

Line 1: PACKAGE BODY EAM_FAILURE_ANALYSIS_PVT AS

1: PACKAGE BODY EAM_FAILURE_ANALYSIS_PVT AS
2: /* $Header: EAMVFALB.pls 120.11.12020000.2 2012/12/27 09:29:06 weichang ship $ */
3:
4: g_module_name VARCHAR2(30);
5:

Line 21: L_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

17:
18: sql_stmt VARCHAR2(4000);
19: l_lookup_meaning VARCHAR2(30);
20: c_ref_failures SYS_REFCURSOR;
21: L_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
22: l_group_id NUMBER;
23: l_ref_failures SYS_REFCURSOR;
24: l_unmatched_uom_class VARCHAR2(1) := 'N';
25: l_unmatched_currency VARCHAR2(1) := 'N';

Line 599: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

595: x_msg_data OUT NOCOPY VARCHAR2,
596: x_unmatched_uom_class OUT NOCOPY VARCHAR2,
597: x_unmatched_currency OUT NOCOPY VARCHAR2) IS
598:
599: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
600: l_group_id NUMBER := 0;
601: l_gen_object_id NUMBER;
602: l_selected_meter NUMBER;
603: l_validate_meters VARCHAR2(1);

Line 841: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

837: x_msg_data OUT NOCOPY VARCHAR2,
838: x_unmatched_uom_class OUT NOCOPY VARCHAR2,
839: x_unmatched_currency OUT NOCOPY VARCHAR2) IS
840:
841: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
842: l_group_id NUMBER;
843:
844: l_gen_object_id number;
845: l_maint_group_id number;

Line 1754: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

1750: x_msg_data OUT NOCOPY VARCHAR2,
1751: x_unmatched_uom_class OUT NOCOPY VARCHAR2,
1752: x_unmatched_currency OUT NOCOPY VARCHAR2) IS
1753:
1754: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
1755: l_group_id NUMBER;
1756:
1757: l_gen_object_id number;
1758: l_maint_group_id number;

Line 4640: END EAM_FAILURE_ANALYSIS_PVT;

4636: --OPEN x_ref_failures FOR l_sql_stmt||' '||l_sql_stmt2||' '||l_sql_stmt3||' '||l_where_clause||' '||l_from_date_clause||') CONNECT BY PRIOR OBJECT_ID = PARENT_OBJECT_ID)';
4637:
4638: END GET_CHILD_METER_RECS_CURSOR;
4639:
4640: END EAM_FAILURE_ANALYSIS_PVT;
4641: