[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;