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.6 2006/10/05 07:34:28 amourya noship $ */
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 591: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

587: x_msg_data OUT NOCOPY VARCHAR2,
588: x_unmatched_uom_class OUT NOCOPY VARCHAR2,
589: x_unmatched_currency OUT NOCOPY VARCHAR2) IS
590:
591: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
592: l_group_id NUMBER := 0;
593: l_gen_object_id NUMBER;
594: l_selected_meter NUMBER;
595: l_validate_meters VARCHAR2(1);

Line 831: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

827: x_msg_data OUT NOCOPY VARCHAR2,
828: x_unmatched_uom_class OUT NOCOPY VARCHAR2,
829: x_unmatched_currency OUT NOCOPY VARCHAR2) IS
830:
831: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
832: l_group_id NUMBER;
833:
834: l_gen_object_id number;
835: l_maint_group_id number;

Line 1738: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;

1734: x_msg_data OUT NOCOPY VARCHAR2,
1735: x_unmatched_uom_class OUT NOCOPY VARCHAR2,
1736: x_unmatched_currency OUT NOCOPY VARCHAR2) IS
1737:
1738: l_asset_failure_tbl EAM_FAILURE_ANALYSIS_PVT.eam_asset_failure_tbl_type;
1739: l_group_id NUMBER;
1740:
1741: l_gen_object_id number;
1742: l_maint_group_id number;

Line 3964: END EAM_FAILURE_ANALYSIS_PVT;

3960: --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)';
3961:
3962: END GET_CHILD_METER_RECS_CURSOR;
3963:
3964: END EAM_FAILURE_ANALYSIS_PVT;
3965:
3966:
3967: