PACKAGE: APPS.ITA_SETUP_REC_VALUES_PKG

Source

1 package ITA_SETUP_REC_VALUES_PKG as
2 /* $Header: itatrevs.pls 120.6.12000000.1 2007/01/18 08:50:36 appldev ship $ */
3 
4 
5 procedure INSERT_ROW (
6   X_REC_VALUE_ID in NUMBER,
7   X_PARAMETER_CODE in VARCHAR2,
8   X_CONTEXT_ORG_ID in NUMBER,
9   X_CONTEXT_ORG_NAME in VARCHAR2,
10   X_RECOMMENDED_VALUE in VARCHAR2,
11   X_DEFAULT_FLAG in VARCHAR2,
12   X_CREATION_DATE in DATE,
13   X_CREATED_BY in NUMBER,
14   X_LAST_UPDATE_DATE in DATE,
15   X_LAST_UPDATED_BY in NUMBER,
16   X_LAST_UPDATE_LOGIN in NUMBER,
17   X_SECURITY_GROUP_ID in NUMBER,
18   X_OBJECT_VERSION_NUMBER in NUMBER,
19   X_PK1_VALUE in VARCHAR2,
20   X_PK2_VALUE in VARCHAR2,
21   X_REC_INTERFACE_ID NUMBER
22 );
23 
24 
25 procedure UPDATE_ROW (
26   X_REC_VALUE_ID in NUMBER,
27   X_PARAMETER_CODE in VARCHAR2,
28   X_CONTEXT_ORG_ID in NUMBER,
29   X_CONTEXT_ORG_NAME in VARCHAR2,
30   X_RECOMMENDED_VALUE in VARCHAR2,
31   X_DEFAULT_FLAG in VARCHAR2,
32   X_LAST_UPDATE_DATE in DATE,
33   X_LAST_UPDATED_BY in NUMBER,
34   X_LAST_UPDATE_LOGIN in NUMBER,
35   X_SECURITY_GROUP_ID in NUMBER,
36   X_OBJECT_VERSION_NUMBER in NUMBER,
37   X_PK1_VALUE in VARCHAR2,
38   X_PK2_VALUE in VARCHAR2,
39   X_REC_INTERFACE_ID NUMBER
40 );
41 
42 
43 procedure LOAD_ROW (
44   X_REC_VALUE_ID in NUMBER,
45   X_PARAMETER_CODE in VARCHAR2,
46   X_CONTEXT_ORG_ID in NUMBER,
47   X_CONTEXT_ORG_NAME in VARCHAR2,
48   X_RECOMMENDED_VALUE in VARCHAR2,
49   X_DEFAULT_FLAG in VARCHAR2,
50   X_LAST_UPDATE_DATE in VARCHAR2,
51   X_PK1_VALUE in VARCHAR2,
52   X_PK2_VALUE in VARCHAR2,
53   X_REC_INTERFACE_ID NUMBER,
54   X_OWNER in VARCHAR2,
55   X_CUSTOM_MODE in VARCHAR2
56 );
57 
58 
59 procedure LOAD_ROW_FOR_IMPORT (
60   X_REC_VALUE_ID in NUMBER,
61   X_PARAMETER_CODE in VARCHAR2,
62   X_CONTEXT_ORG_ID in NUMBER,
63   X_CONTEXT_ORG_NAME in VARCHAR2,
64   X_RECOMMENDED_VALUE in VARCHAR2,
65   X_DEFAULT_FLAG in VARCHAR2,
66   X_CREATION_DATE in DATE,
67   X_CREATED_BY in NUMBER,
68   X_LAST_UPDATE_DATE in DATE,
69   X_LAST_UPDATED_BY in NUMBER,
70   X_LAST_UPDATE_LOGIN in NUMBER,
71   X_SECURITY_GROUP_ID in NUMBER,
72   X_OBJECT_VERSION_NUMBER in NUMBER,
73   X_PK1_VALUE in VARCHAR2,
74   X_PK2_VALUE in VARCHAR2,
75   X_REC_INTERFACE_ID NUMBER
76 );
77 
78 
79 procedure ADD_LANGUAGE;
80 
81 
82 procedure GetParameterCode  (p_parameter_name    IN VARCHAR2,
83 		             p_setup_group_code IN VARCHAR2,
84 			     X_PARAMETER_CODE OUT NOCOPY VARCHAR2);
85 
86 procedure IMPORT (
87   BATCH_ID in NUMBER,
88   CREATED_BY in NUMBER
89 );
90 
91 procedure getContextInfo(
92 			X_CONTEXT_ID OUT NOCOPY NUMBER,
93 			P_CONTEXT_NAME IN VARCHAR2,
94 			P_SETUP_GROUP_NAME IN VARCHAR2
95 );
96 
97 
98 -- *****************************************
99 -- FUNCTION
100 --   getRecValueCode
101 -- Input Parameters
102 --   context_org_id
103 --   parameter_code
104 -- Return Values
105 --   varchar2   recommended_value for
106 --              the org and parameter code
107 -- *****************************************
108 FUNCTION getRecValueCode(
109    p_context_org_id     IN   VARCHAR2,
110    p_parameter_code     IN   VARCHAR2
111 )
112 return VARCHAR2;
113 
114 -- *****************************************
115 -- FUNCTION
116 --   getRecValueMeaning
117 -- Input Parameters
118 --   context_org_id
119 --   parameter_code
120 -- Return Values
121 --   varchar2   recommended_value meaning for
122 --              the org and parameter code
123 -- *****************************************
124 FUNCTION getRecValueMeaning(
125    p_context_org_id     IN   VARCHAR2,
126    p_parameter_code     IN   VARCHAR2
127 )
128 return VARCHAR2;
129 
130 
131 end ITA_SETUP_REC_VALUES_PKG;