PACKAGE: APPS.ASG_ITEM_INDEX_PKG

Source

1 PACKAGE ASG_ITEM_INDEX_PKG as
2 /* $Header: asgpinds.pls 120.1 2005/08/12 02:52:04 saradhak noship $ */
3 
4 --
5 --    Table handler for ASG_PUB_ITEM_INDEX table.
6 --
7 -- HISTORY
8 -- MAR. 11, 2002   ytian Created.
9 --
10 
11 procedure insert_row (
12   x_INDEX_ID in VARCHAR2,
13   x_ITEM_ID  in VARCHAR2,
14   x_INDEX_NAME in VARCHAR2,
15   x_ENABLED  in VARCHAR2,
16   x_PMOD     in VARCHAR2,
17   x_INDEX_COLUMNS  in VARCHAR2,
18   x_LAST_RELEASE_VERSION in NUMBER,
19   x_CURRENT_RELEASE_VERSION in NUMBER,
20   x_CREATION_DATE in DATE,
21   x_CREATED_BY in NUMBER,
22   x_LAST_UPDATE_DATE in DATE,
23   x_LAST_UPDATED_BY in NUMBER);
24 
25 
26 procedure update_row (
27   x_INDEX_ID in VARCHAR2,
28   x_ITEM_ID  in VARCHAR2,
29   x_INDEX_NAME in VARCHAR2,
30   x_ENABLED  in VARCHAR2,
31   x_PMOD     in VARCHAR2,
32   x_INDEX_COLUMNS  in VARCHAR2,
33   x_LAST_RELEASE_VERSION in NUMBER,
34   x_CURRENT_RELEASE_VERSION in NUMBER,
35   x_CREATION_DATE in DATE,
36   x_CREATED_BY in NUMBER,
37   x_LAST_UPDATE_DATE in DATE,
38   x_LAST_UPDATED_BY in NUMBER);
39 
40 
41 procedure load_row (
42   x_INDEX_ID in VARCHAR2,
43   x_ITEM_ID  in VARCHAR2,
44   x_INDEX_NAME in VARCHAR2,
45   x_ENABLED  in VARCHAR2,
46   x_PMOD     in VARCHAR2,
47   x_INDEX_COLUMNS  in VARCHAR2,
48   x_LAST_RELEASE_VERSION in NUMBER,
49   x_CURRENT_RELEASE_VERSION in NUMBER,
50   x_CREATION_DATE in DATE,
51   x_CREATED_BY in NUMBER,
52   x_LAST_UPDATE_DATE in DATE,
53   x_LAST_UPDATED_BY in NUMBER,
54   p_owner in VARCHAR2);
55 
56 END ASG_ITEM_INDEX_PKG;