DBA Data[Home] [Help]

PACKAGE: APPS.PER_CAGR_ENTITLEMENT_ITEMS_PKG

Source


1 package PER_CAGR_ENTITLEMENT_ITEMS_PKG as
2 /* $Header: pepcilct.pkh 120.2 2006/06/27 11:14:13 bshukla noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_CAGR_ENTITLEMENT_ITEM_ID in NUMBER,
6   X_BUSINESS_GROUP_ID in NUMBER,
7   X_ELEMENT_TYPE_ID in NUMBER,
8   X_INPUT_VALUE_ID in VARCHAR2,
9   X_COLUMN_TYPE in VARCHAR2,
10   X_COLUMN_SIZE in NUMBER,
11   X_LEGISLATION_CODE in VARCHAR2,
12   X_BENEFICIAL_RULE in VARCHAR2,
13   X_CAGR_API_ID in NUMBER,
14   X_CAGR_API_PARAM_ID in NUMBER,
15   X_CATEGORY_NAME in VARCHAR2,
16   X_UOM in VARCHAR2,
17   X_BENEFICIAL_FORMULA_ID in NUMBER,
18   X_FLEX_VALUE_SET_ID in NUMBER,
19   X_BENEFICIAL_RULE_VALUE_SET_ID in NUMBER,
20   X_OBJECT_VERSION_NUMBER in NUMBER,
21   X_ITEM_NAME in VARCHAR2,
22   X_MULTI_ENTRIES_ALLOWED_FLAG in VARCHAR2,
23   X_AUTO_CREATE_ENTRIES_FLAG in VARCHAR2,
24   X_CREATION_DATE in DATE,
25   X_CREATED_BY in NUMBER,
26   X_LAST_UPDATE_DATE in DATE,
27   X_LAST_UPDATED_BY in NUMBER,
28   X_LAST_UPDATE_LOGIN in NUMBER);
29 
30 procedure TRANSLATE_ROW (
31   X_ITEM_NAME1                 in VARCHAR2 default null,
32   X_ITEM_NAME                  in VARCHAR2,
33   X_BUSINESS_GROUP_NAME        in VARCHAR2,
34   X_LEGISLATION_CODE           in VARCHAR2,
35   X_OWNER                      in VARCHAR2,
36   X_LAST_UPDATE_DATE IN VARCHAR2 default sysdate,
37   X_CUSTOM_MODE IN VARCHAR2 default null);
38 
39 procedure LOAD_ROW (
40   X_ITEM_NAME 				in  VARCHAR2,
41   X_OWNER                       	in  VARCHAR2,
42   X_LEGISLATION_CODE 			in  VARCHAR2,
43   X_BUSINESS_GROUP_NAME			in VARCHAR2,
44   X_ELEMENT_TYPE 			in VARCHAR2,
45   X_INPUT_VALUE 			in VARCHAR2,
46   X_COLUMN_TYPE 			in VARCHAR2,
47   X_COLUMN_SIZE 			in NUMBER,
48   X_BENEFICIAL_RULE 			in VARCHAR2,
49   X_CAGR_API 				in VARCHAR2,
50   X_CAGR_API_PARAM 			in VARCHAR2,
51   X_CATEGORY_NAME 			in VARCHAR2,
52   X_UOM 				in VARCHAR2,
53   X_BENEFICIAL_FORMULA_ID 		in NUMBER,
54   X_FLEX_VALUE_SET 			in VARCHAR2,
55   X_BENEFICIAL_VALUE_SET	 	in VARCHAR2,
56   X_MULTI_ENTRIES_ALLOWED_FLAG          in VARCHAR2,
57   X_AUTO_CREATE_ENTRIES_FLAG            in VARCHAR2,
58   X_OBJECT_VERSION_NUMBER 		in NUMBER,
59   X_LAST_UPDATE_DATE IN VARCHAR2 default sysdate,
60   X_CUSTOM_MODE IN VARCHAR2 default null);
61 
62 procedure LOCK_ROW (
63   X_CAGR_ENTITLEMENT_ITEM_ID in NUMBER,
64   X_BUSINESS_GROUP_ID in NUMBER,
65   X_ELEMENT_TYPE_ID in NUMBER,
66   X_INPUT_VALUE_ID in VARCHAR2,
67   X_COLUMN_TYPE in VARCHAR2,
68   X_COLUMN_SIZE in NUMBER,
69   X_LEGISLATION_CODE in VARCHAR2,
70   X_BENEFICIAL_RULE in VARCHAR2,
71   X_CAGR_API_ID in NUMBER,
72   X_CAGR_API_PARAM_ID in NUMBER,
73   X_CATEGORY_NAME in VARCHAR2,
74   X_UOM in VARCHAR2,
75   X_BENEFICIAL_FORMULA_ID in NUMBER,
76   X_FLEX_VALUE_SET_ID in NUMBER,
77   X_BENEFICIAL_RULE_VALUE_SET_ID in NUMBER,
78   X_OBJECT_VERSION_NUMBER in NUMBER,
79   X_MULTI_ENTRIES_ALLOWED_FLAG in VARCHAR2,
80   X_AUTO_CREATE_ENTRIES_FLAG in VARCHAR2,
81   X_ITEM_NAME in VARCHAR2);
82 
83 procedure UPDATE_ROW (
84   X_CAGR_ENTITLEMENT_ITEM_ID in NUMBER,
85   X_BUSINESS_GROUP_ID in NUMBER,
86   X_ELEMENT_TYPE_ID in NUMBER,
87   X_INPUT_VALUE_ID in VARCHAR2,
88   X_COLUMN_TYPE in VARCHAR2,
89   X_COLUMN_SIZE in NUMBER,
90   X_LEGISLATION_CODE in VARCHAR2,
91   X_BENEFICIAL_RULE in VARCHAR2,
92   X_CAGR_API_ID in NUMBER,
93   X_CAGR_API_PARAM_ID in NUMBER,
94   X_CATEGORY_NAME in VARCHAR2,
95   X_UOM in VARCHAR2,
96   X_BENEFICIAL_FORMULA_ID in NUMBER,
97   X_FLEX_VALUE_SET_ID in NUMBER,
98   X_BENEFICIAL_RULE_VALUE_SET_ID in NUMBER,
99   X_OBJECT_VERSION_NUMBER in NUMBER,
100   X_MULTI_ENTRIES_ALLOWED_FLAG in VARCHAR2,
101   X_AUTO_CREATE_ENTRIES_FLAG in VARCHAR2,
102   X_ITEM_NAME in VARCHAR2,
103   X_LAST_UPDATE_DATE in DATE,
104   X_LAST_UPDATED_BY in NUMBER,
105   X_LAST_UPDATE_LOGIN in NUMBER);
106 
107 procedure DELETE_ROW (
108   X_CAGR_ENTITLEMENT_ITEM_ID in NUMBER);
109 
110 procedure ADD_LANGUAGE;
111 
112 end PER_CAGR_ENTITLEMENT_ITEMS_PKG;