1 PACKAGE AHL_REPORT_UTILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVRPTS.pls 120.2.12020000.2 2012/12/07 14:04:05 sareepar ship $ */
3
4 -- START: Defining local functions signatures --
5 --------------------------------------------------------------------
6
7 -- Returns the Id of the open UE whose due date is nearest in the furture to sysdate
8 FUNCTION Get_Restrictive_UE(P_INSTANCE_ID IN NUMBER, P_MR_PGM_SUB_TYPE IN VARCHAR2)
9 RETURN NUMBER;
10
11 -- Returns the Id of the open UE whose due date is nearest in the furture to sysdate
12 -- when MR PST is picked from the common setup page
13 FUNCTION Get_Restrictive_UE_CRF(P_INSTANCE_ID IN NUMBER)
14 RETURN NUMBER;
15
16 -- Returns the remaining counter value for the appropriate counter
17 FUNCTION Get_Remaining_Counter_UOM(P_UE_ID IN NUMBER, P_COUNTER_INDEX IN VARCHAR2, P_REPORT_NAME IN VARCHAR2)
18 RETURN NUMBER;
19
20
21 -- Record for counter table
22 TYPE Rem_Counter_Rec_Type IS RECORD (
23 PARAMETER_ID NUMBER := NULL,
24 COUNTER_PARAMETER_NAME VARCHAR2(80) := NULL,
25 COUNTER_PARAMETER_VALUE VARCHAR2(80) := NULL
26 );
27
28
29 -- Start of Comments --
30 -- Function name : Get_SpecLimit_Counter_Value
31 -- Type : Public
32 -- Function : Returns the spec limit counter value for the appropriate counter.
33 -- Pre-reqs :
34 -- Parameters :
35 -- p_ue_id IN NUMBER Required
36 -- p_counter_index IN NUMBER Required
37 --
38 -- End of Comments.
39 FUNCTION Get_SpecLimit_Counter_Value
40 (
41 p_ue_id IN NUMBER,
42 p_counter_index IN VARCHAR2
43 )
44 RETURN NUMBER;
45
46
47 -- Start of Comments --
48 -- Function name : Get_Since_Repair_Reading
49 -- Type : Public
50 -- Function : Returns the spec limit counter value for the appropriate counter.
51 -- Pre-reqs :
52 -- Parameters :
53 -- p_item_instance_id IN NUMBER Required
54 -- p_counter_index IN VARCHAR2 Required
55 -- End of Comments.
56 FUNCTION Get_Since_Repair_Reading
57 (
58 p_item_instance_id IN NUMBER,
59 p_counter_index IN VARCHAR2
60 )
61 RETURN NUMBER;
62
63
64 -- Declare COUNTER TABLE type for record
65 TYPE Rem_Counter_Tbl_Type IS TABLE OF Rem_Counter_Rec_Type
66 INDEX BY BINARY_INTEGER;
67
68 --To insert/update counters values.
69 PROCEDURE Insert_Rem_Counters (
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
72 p_commit IN VARCHAR2 := Fnd_Api.g_false,
73 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
74 p_rem_counter_tbl IN OUT NOCOPY Rem_Counter_Tbl_Type,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80 -- Returns the count of the item groups in which the given instance's item is associated
81 FUNCTION Get_Item_Group_Count(P_INSTANCE_ID IN NUMBER)
82 RETURN NUMBER;
83
84 -- Returns the first instance that happens to be a unit for a given instance
85 FUNCTION Get_First_Instance(P_INSTANCE_ID IN NUMBER)
86 RETURN NUMBER;
87
88 -- Returns the root instance up the hierarchy for a given instance
89 FUNCTION Get_Root_Instance(P_INSTANCE_ID IN NUMBER)
90 RETURN NUMBER;
91
92 -- Returns the message defined for the given label
93 FUNCTION Get_Fnd_Message(P_MESSAGE_CODE VARCHAR2)
94 RETURN VARCHAR2 ;
95
96 --Inserts setup data in the ahl_parameters table
97 PROCEDURE Insert_Ahl_Parameters;
98
99 -- Returns the current date in the user defined format
100 FUNCTION Get_Date
101 RETURN VARCHAR2 ;
102
103 -- Returns the parent UC for a given instance
104 FUNCTION Get_Parent_UC(P_INSTANCE_ID IN NUMBER)
105 RETURN VARCHAR2;
106
107 -- Returns the position of a current instance
108 FUNCTION Get_Position(P_INSTANCE_ID IN NUMBER, P_ITEM_GRP_ID IN NUMBER)
109 RETURN VARCHAR2;
110
111 END AHL_REPORT_UTILS_PVT;
112