PACKAGE BODY: APPS.CSM_DASHBOARD_SEARCH_COL_PKG

Source

1 PACKAGE BODY csm_dashboard_search_col_pkg as
2 /* $Header: csmldscb.pls 120.2 2005/12/05 23:15:38 utekumal noship $ */
3 
4 
5 --HISTORY
6 --   Jul 10, 2005  yazhang created.
7 --   Dec 6 , 2005  SARADHAK updated as table definition is modified.
8 
9 procedure insert_row (
10   x_column_name in varchar2,
11   x_NAME      in VARCHAR2,
12   x_lov_vo_name in varchar2,
13   x_INPUT_TYPE in varchar2,
14   x_display    in varchar2 )
15 IS
16 
17 begin
18 
19   insert into csm_dashboard_search_cols(
20                             column_name,
21                             name,
22                             lov_vo_name,
23                             input_type,
24                             display,
25                             CREATION_DATE,
26                             CREATED_BY,
27                             LAST_UPDATE_DATE,
28                             LAST_UPDATED_BY)
29                           values (
30                             X_column_name,
31                             X_name,
32                             decode(x_lov_vo_name,FND_API.G_MISS_CHAR, NULL,x_lov_vo_name),
33                             decode(x_input_type,FND_API.G_MISS_CHAR, NULL, x_input_type),
34                             decode(x_display,FND_API.G_MISS_CHAR, NULL, x_display),
35                             SYSDATE,
36                             1,
37                             SYSDATE,
38                             1 );
39 
40 end insert_row;
41 
42 procedure update_row (
43   x_column_name in varchar2,
44   x_NAME      in VARCHAR2,
45   x_lov_vo_name in varchar2,
46   x_INPUT_TYPE in varchar2,
47   x_display    in varchar2)
48 IS
49 begin
50 
51   update csm_dashboard_search_cols set
52     INPUT_TYPE = x_input_type,
53     display = x_display,
54     name = x_name,
55     lov_vo_name = x_lov_vo_name,
56     LAST_UPDATE_DATE=SYSDATE,
57     LAST_UPDATED_BY=1
58    where COLUMN_NAME = X_COLUMN_NAME;
59 
60 END UPDATE_ROW;
61 
62 
63 procedure load_row (
64   x_column_name in varchar2,
65   x_NAME      in VARCHAR2,
66   x_lov_vo_name in varchar2,
67   x_INPUT_TYPE in varchar2,
68   x_display    in varchar2,
69   x_owner in VARCHAR2)
70 IS
71 CURSOR c_exists IS
72  SELECT 1
73  FROM  CSM_DASHBOARD_SEARCH_COLS
74  WHERE COLUMN_NAME=X_COLUMN_NAME;
75 
76 l_exists NUMBER;
77 
78 BEGIN
79 
80  OPEN c_exists;
81  FETCH c_exists INTO l_exists;
82  CLOSE c_exists;
83 
84  IF l_exists IS NULL THEN
85    insert_row (
86     x_column_NAME =>x_column_NAME,
87     x_name =>x_name,
88     x_lov_vo_name =>x_lov_vo_name,
89     x_input_type =>x_input_type,
90     x_display =>x_display
91    );
92 
93  ELSE
94   UPDATE_ROW (
95     x_column_NAME =>x_column_NAME,
96     x_name =>x_name,
97     x_lov_vo_name =>x_lov_vo_name,
98     x_input_type =>x_input_type,
99     x_display =>x_display
100   );
101  END IF;
102 
103 END load_row;
104 
105 END csm_dashboard_search_col_pkg;