PACKAGE: APPS.AR_BPA_URL_PARAMS_PKG

Source

1 package AR_BPA_URL_PARAMS_PKG as
2 /* $Header: ARBPURPS.pls 120.1 2004/12/03 01:45:28 orashid noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_URL_PARAM_ID in NUMBER,
6   X_URL_ID in NUMBER,
7   X_PARAM_TYPE in VARCHAR2,
8   X_PARAM_NAME in VARCHAR2,
9   X_PARAM_VALUE in VARCHAR2,
10   X_ITEM_ID in NUMBER,
11   X_ENCRYPTED_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 
18 procedure LOCK_ROW (
19   X_URL_PARAM_ID in NUMBER,
20   X_URL_ID in NUMBER,
21   X_PARAM_TYPE in VARCHAR2,
22   X_PARAM_NAME in VARCHAR2,
23   X_PARAM_VALUE in VARCHAR2,
24   X_ITEM_ID in NUMBER,
25   X_ENCRYPTED_FLAG in VARCHAR2
26 );
27 
28 procedure UPDATE_ROW (
29   X_URL_PARAM_ID in NUMBER,
30   X_URL_ID in NUMBER,
31   X_PARAM_TYPE in VARCHAR2,
32   X_PARAM_NAME in VARCHAR2,
33   X_PARAM_VALUE in VARCHAR2,
34   X_ITEM_ID in NUMBER,
35   X_ENCRYPTED_FLAG in VARCHAR2,
36   X_LAST_UPDATE_DATE in DATE,
37   X_LAST_UPDATED_BY in NUMBER,
38   X_LAST_UPDATE_LOGIN in NUMBER);
39 
40 procedure DELETE_ROW (
41   X_URL_PARAM_ID in NUMBER
42 );
43 
44 -- no need for translate_row as this table has no translations
45 
46 -- load row used by lct
47 procedure LOAD_ROW (
48 		  X_URL_PARAM_ID in NUMBER,
49 		  X_URL_ID in NUMBER,
50 		  X_PARAM_TYPE in VARCHAR2,
51 		  X_PARAM_NAME in VARCHAR2,
52 		  X_PARAM_VALUE in VARCHAR2,
53 		  X_ITEM_ID in NUMBER,
54 		  X_ENCRYPTED_FLAG in VARCHAR2,
55           X_OWNER IN VARCHAR2);
56 
57 end AR_BPA_URL_PARAMS_PKG;