DBA Data[Home] [Help]

PACKAGE: APPS.AMS_IBA_PS_FILTERS_PKG

Source


1 package AMS_IBA_PS_FILTERS_PKG AUTHID CURRENT_USER as
2 /* $Header: amstflts.pls 115.5 2002/01/24 22:27:13 pkm ship     $ */
3 -- ======================================================================
4 -- Start of Comments
5 -- Package name     : AMS_IBA_PS_FILTERS_PKG
6 -- Purpose          : PACKAGE SPECIFICATION FOR TABLE HANDLER
7 -- History          : 05/25/01  Avijit Saha  CREATED
8 -- End of Comments
9 -- ======================================================================
10 
11 procedure INSERT_ROW (
12   P_FILTER_ID in NUMBER,
13   P_OBJECT_VERSION_NUMBER in NUMBER,
14   P_FILTER_REF_CODE in VARCHAR2,
15   P_CONTENT_TYPE in VARCHAR2,
16   P_GROUP_NUM in NUMBER,
17   P_FILTER_NAME in VARCHAR2,
18   P_CREATION_DATE in DATE,
19   P_CREATED_BY in NUMBER,
20   P_LAST_UPDATE_DATE in DATE,
21   P_LAST_UPDATED_BY in NUMBER,
22   P_LAST_UPDATE_LOGIN in NUMBER);
23 
24 procedure LOCK_ROW (
25   X_FILTER_ID in NUMBER,
26   X_OBJECT_VERSION_NUMBER in NUMBER,
27   X_FILTER_REF_CODE in VARCHAR2,
28   X_CONTENT_TYPE in VARCHAR2,
29   X_GROUP_NUM in NUMBER,
30   X_FILTER_NAME in VARCHAR2
31 );
32 
33 procedure UPDATE_ROW (
34   P_FILTER_ID in NUMBER,
35   P_OBJECT_VERSION_NUMBER in NUMBER,
36   P_FILTER_REF_CODE in VARCHAR2,
37   P_CONTENT_TYPE in VARCHAR2,
38   P_GROUP_NUM in NUMBER,
39   P_FILTER_NAME in VARCHAR2,
40   P_LAST_UPDATE_DATE in DATE,
41   P_LAST_UPDATED_BY in NUMBER,
42   P_LAST_UPDATE_LOGIN in NUMBER
43 );
44 
45 procedure DELETE_ROW (
46   P_FILTER_ID in NUMBER
47 );
48 
49 procedure ADD_LANGUAGE;
50 
51 PROCEDURE translate_row (
52    x_filter_id IN NUMBER,
53    x_filter_name IN VARCHAR2,
54    x_owner IN VARCHAR2
55 );
56 
57 PROCEDURE load_row (
58    x_filter_id           IN NUMBER,
59    x_filter_ref_code     IN VARCHAR2,
60    x_content_type        IN VARCHAR2,
61    x_group_num           IN NUMBER,
62    x_filter_name         IN VARCHAR2,
63    x_owner               IN VARCHAR2
64 );
65 
66 end AMS_IBA_PS_FILTERS_PKG;