1 PACKAGE EDR_MSCA_UTIL AS
2 /* $Header: EDRVMTLS.pls 120.1.12000000.1 2007/01/18 05:56:34 appldev ship $ */
3
4
5 --Reference cursor which is used in LOV queries.
6 TYPE l_genref IS REF CURSOR;
7
8
9 --This proecdeure would obtain the e-record text for the specified e-record ID.
10
11 -- Start of comments
12 -- API name : GET_ERECORD_TEXT
13 -- Type : Private Utility.
14 -- Function : Obtains the e-record text for s given e-record ID.
15 -- Pre-reqs : None.
16 -- Parameters :
17 -- IN : p_erecord_id IN NUMBER - The e-record ID value
18
19 -- OUT : x_text_erecord OUT NOCOPY VARCHAR2 - The e-record text.
20 -- : x_error_msg OUT NOCOPY VARCHAR2 - The return message indicating success/error.
21
22 PROCEDURE GET_ERECORD_TEXT(p_erecord_id IN NUMBER,
23 x_text_erecord OUT NOCOPY VARCHAR2,
24 x_error_msg OUT NOCOPY VARCHAR2);
25
26 --This procedeure would obtain all the lookup codes and corresponding meanings for
27 --the specified lookup type.
28
29 -- Start of comments
30 -- API name : GET_LOOKUP
31 -- Type : Private Utility.
32 -- Function : Obtains the lookup details
33 -- Pre-reqs : None.
34 -- Parameters :
35 -- IN : p_lookup_type IN VARCHAR2 - The lookup type
36 -- : p_meaning IN VARCHAR2 - The Entered meaning in lov
37
38 -- OUT : x_lookup OUT NOCOPY L_GENREF - The lookup details
39
40 PROCEDURE GET_LOOKUP(x_lookup OUT NOCOPY L_GENREF,
41 p_lookup_type IN VARCHAR2,
42 p_meaning IN VARCHAR2);
43
44
45 --This procedeure would obtain all the lookup codes and corresponding meanings for
46 --the specified lookup type except that of the excluded lookup code
47
48 -- Start of comments
49 -- API name : GET_LOOKUP
50 -- Type : Private Utility.
51 -- Function : Obtains the lookup details except of the excluded lookup code.
52 -- Pre-reqs : None.
53 -- Parameters :
54 -- IN : p_lookup_type IN VARCHAR2 - The lookup type
55 -- : p_excluded_lookup_code IN VARCHAR2 - The lookup code to be excluded
56 -- : p_meaning IN VARCHAR2 - The Entered meaning in lov
57
58 -- OUT : x_lookup OUT NOCOPY L_GENREF - The lookup details
59
60 PROCEDURE GET_LOOKUP(x_lookup OUT NOCOPY l_genref,
61 p_lookup_type IN VARCHAR2,
62 p_exclude_lookup_code IN VARCHAR2,
63 p_meaning IN VARCHAR2);
64
65
66 --This procedure would obtain all the approvers for the specified transaction
67 --based on the event key.
68
69 -- Start of comments
70 -- API name : GET_LOOKUP
71 -- Type : Private Utility.
72 -- Function : Obtains the lookup details
73 -- Pre-reqs : None.
74 -- Parameters :
75 -- IN : p_eventkey IN NUMBER - The event key value
76 -- : p_approverName IN VARCHAR2 : Approver Name from lov
77
78 -- OUT : x_approvers OUT NOCOPY L_GENREF - The approver list.
79
80 PROCEDURE GET_APPROVERS(x_approvers OUT NOCOPY l_genref,
81 p_eventkey IN NUMBER,
82 p_approverName IN VARCHAR2);
83
84
85 --This procedeure would obtain all the forms based test scenario details.
86
87 -- Start of comments
88 -- API name : GET_TEST_SCENARIO_DETAILS
89 -- Type : Private Utility.
90 -- Function : Obtains the FORMS based test scenario details.
91 -- Pre-reqs : None.
92 -- Parameters :
93 -- IN : NONE
94
95 -- OUT : x_test_scenario_details OUT NOCOPY L_GENREF - The test scenario details
96
97 PROCEDURE GET_TEST_SCENARIO_DETAILS( x_test_scenario_details OUT NOCOPY l_genref);
98
99 END EDR_MSCA_UTIL;