PACKAGE: APPS.FUN_RULE_UTILITY_PKG

Source

1 PACKAGE FUN_RULE_UTILITY_PKG AUTHID CURRENT_USER AS
2 /*$Header: FUNXTMRULGENUTS.pls 120.1 2006/02/22 10:51:10 ammishra noship $ */
3 
4 --------------------------------------
5 -- public procedures and functions
6 --------------------------------------
7 
8 /**
9  * FUNCTION get_session_process_id
10  *
11  * DESCRIPTION
12  *     Return OS process id of current session.
13  *
14  * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15  *
16  * ARGUMENTS
17  *   IN:
18  *
19  * NOTES
20  *
21  * MODIFICATION HISTORY
22  *
23  *   10-Sep-2004    Amulya Mishra      Created.
24  *
25  */
26 
27 FUNCTION get_session_process_id RETURN VARCHAR2;
28 PRAGMA RESTRICT_REFERENCES ( get_session_process_id, WNDS, WNPS, RNPS );
29 
30 /**
31  * FUNCTION
32  *     created_by
33  *     creation_date
34  *     last_updated_by
35  *     last_update_date
36  *     last_update_login
37  *     request_id
38  *     program_id
39  *     program_application_id
40  *     program_update_date
41  *     user_id
42  *
43  * DESCRIPTION
44  *     Return standard who value.
45  *
46  * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
47  *
48  * ARGUMENTS
49  *   IN:
50  *
51  * NOTES
52  *
53  * MODIFICATION HISTORY
54  *
55  *   10-Sep-2004    Amulya Mishra      Created.
56  *
57  */
58 
59 FUNCTION created_by RETURN NUMBER;
60 
61 FUNCTION creation_date RETURN DATE;
62 
63 FUNCTION last_updated_by RETURN NUMBER;
64 
65 FUNCTION last_update_date RETURN DATE;
66 
67 FUNCTION last_update_login RETURN NUMBER;
68 
69 FUNCTION request_id RETURN NUMBER;
70 
71 FUNCTION program_id RETURN NUMBER;
72 
73 FUNCTION program_application_id RETURN NUMBER;
74 
75 FUNCTION application_id RETURN NUMBER;
76 
77 FUNCTION program_update_date RETURN DATE;
78 
79 FUNCTION user_id RETURN NUMBER;
80 
81 FUNCTION Get_SchemaName (
82     p_app_short_name             IN     VARCHAR2
83 ) RETURN VARCHAR2;
84 
85 FUNCTION Get_AppsSchemaName RETURN VARCHAR2;
86 
87 FUNCTION Get_LookupMeaning (
88     p_lookup_table                          IN     VARCHAR2 DEFAULT 'AR_LOOKUPS',
89     p_lookup_type                           IN     VARCHAR2,
90     p_lookup_code                           IN     VARCHAR2
91 ) RETURN VARCHAR2;
92 
93 /*
94 PROCEDURE CREATE_DUPLICATE_RULE(
95           P_RULE_DETAIL_ID IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
96           P_RULE_OBJECT_ID IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
97           );
98 */
99 
100 FUNCTION GET_MAX_SEQ (
101     P_RULE_OBJECT_ID IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
102 )RETURN NUMBER;
103 
104 FUNCTION getApplicationID(p_AppShortName IN VARCHAR2)
105                           RETURN  NUMBER;
106 
107 FUNCTION getApplicationShortName(p_ApplicationId IN NUMBER)
108                           RETURN VARCHAR2;
109 
110 FUNCTION getValueSetDataType(p_ValueSetId  IN NUMBER)
111                           RETURN VARCHAR2;
112 
113 FUNCTION get_rule_dff_result_value(p_FlexFieldAppShortName	IN VARCHAR2,
114                                    p_FlexFieldName		IN VARCHAR2,
115 				   p_AttributeCategory		IN VARCHAR2,
116 				   p_Attribute1			IN VARCHAR2,
117 				   p_Attribute2			IN VARCHAR2,
118 				   p_Attribute3			IN VARCHAR2,
119 				   p_Attribute4			IN VARCHAR2,
120 				   p_Attribute5			IN VARCHAR2,
121 				   p_Attribute6			IN VARCHAR2,
122 				   p_Attribute7			IN VARCHAR2,
123 				   p_Attribute8			IN VARCHAR2,
124 				   p_Attribute9			IN VARCHAR2,
125 				   p_Attribute10		IN VARCHAR2,
126 				   p_Attribute11		IN VARCHAR2,
127 				   p_Attribute12		IN VARCHAR2,
128 				   p_Attribute13		IN VARCHAR2,
129 				   p_Attribute14		IN VARCHAR2,
130 				   p_Attribute15		IN VARCHAR2
131 				   )RETURN VARCHAR2;
132 
133 PROCEDURE print_debug(p_indent IN NUMBER,p_text IN VARCHAR2 );
134 
135 FUNCTION get_moac_org_id RETURN NUMBER;
136 
137 /* Rule Object Instance Enhancement for MULTIVALUE:
138  * This function returns TRU if the RULE_OBJECT_ID passed is an instance or not.
139  */
140 
141 FUNCTION IS_USE_INSTANCE(p_rule_object_id IN NUMBER) RETURN BOOLEAN;
142 
143 END FUN_RULE_UTILITY_PKG;