[Home] [Help]
PACKAGE BODY: APPS.CN_CLRL_API_PKG
Source
1 PACKAGE BODY cn_clrl_api_pkg AS
2 -- $Header: cncrapib.pls 115.4 99/07/16 07:05:48 porting ship $
3
4
5 -------------------------------------------------------------------------------
6 -- Function Name : Default_Row --
7 -- Purpose : Generate a primary key value uing the sequence --
8 -- Parameters : --
9 -- IN : --
10 -- OUT : x_api_id IN NUMBER Required --
11 -- History --
12 -- 26-AUG-98 Ram Kalyanasundaram Created
13 -------------------------------------------------------------------------------
14 PROCEDURE Default_Row(x_api_id OUT NUMBER)
15 IS
16 BEGIN
17 SELECT cn_clrl_api_s.NEXTVAL
18 INTO x_api_id
19 FROM dual;
20 END Default_Row;
21
22 -------------------------------------------------------------------------------
23 -- Function Name : Insert_Row --
24 -- Purpose : Insert a row into the table --
25 -- Parameters : --
26 -- IN : p_api_id IN NUMBER Required --
27 -- p_ruleset_name IN VARCHAR2 Required --
28 -- p_parent_rule_name IN VARCHAR2 Required --
29 -- p_rule_name IN VARCHAR2 Required --
30 -- p_revenue_class_name IN VARCHAR2 Required --
31 -- p_attribute_rule_name IN VARCHAR2 Required --
32 -- p_not_flag IN VARCHAR2 Required --
33 -- p_value_1 IN VARCHAR2 Required --
34 -- p_value_2 IN VARCHAR2 Required --
35 -- p_data_flag IN VARCHAR2 Required --
36 -- p_loading_status IN VARCHAR2 Required --
37 -- p_object_name IN VARCHAR2 Required --
38 -- p_message_text IN VARCHAR2 Required --
39 -- p_return_status IN VARCHAR2 Required --
40 -- OUT : --
41 -- History --
42 -- 26-AUG-98 Ram Kalyanasundaram Created
43 -------------------------------------------------------------------------------
44 PROCEDURE Insert_Row(p_api_id IN NUMBER,
45 p_ruleset_name IN VARCHAR2,
46 p_parent_rule_name IN VARCHAR2,
47 p_rule_name IN VARCHAR2,
48 p_revenue_class_name IN VARCHAR2,
49 p_attribute_rule_name IN VARCHAR2,
50 p_not_flag IN VARCHAR2,
51 p_value_1 IN VARCHAR2,
52 p_value_2 IN VARCHAR2,
53 p_data_flag IN VARCHAR2,
54 p_loading_status IN VARCHAR2,
55 p_object_name IN VARCHAR2,
56 p_message_text IN VARCHAR2,
57 p_return_status IN VARCHAR2)
58 IS
59 BEGIN
60 INSERT INTO cn_clrl_api
61 (clrl_api_id,
62 ruleset_name, parent_rule_name,
63 rule_name, revenue_class_name,
64 attribute_rule_name, not_flag, value_1,
65 value_2, data_flag, loading_status, object_name,
66 message_text, return_status)
67 VALUES(p_api_id, p_ruleset_name, p_parent_rule_name,
68 p_rule_name, p_revenue_class_name,
69 p_attribute_rule_name, p_not_flag, p_value_1,
70 p_value_2, p_data_flag, p_loading_status, p_object_name,
71 p_message_text, p_return_status);
72
73 END Insert_Row;
74
75 -------------------------------------------------------------------------------
76 -- Function Name : Delete_Row --
77 -- Purpose : Delete a row if the given primary key exists --
78 -- Parameters : --
79 -- IN : p_api_id IN NUMBER Required --
80 -- OUT : --
81 -- History --
82 -- 26-AUG-98 Ram Kalyanasundaram Created
83 -------------------------------------------------------------------------------
84 PROCEDURE Delete_Row(p_api_id IN NUMBER)
85 IS
86 BEGIN
87 DELETE FROM cn_clrl_api
88 WHERE clrl_api_id = p_api_id;
89 END Delete_Row;
90
91 -------------------------------------------------------------------------------
92 -- Function Name : Update_Row --
93 -- Purpose : Update a row if the given primary key exists --
94 -- Parameters : --
95 -- IN : p_api_id IN NUMBER Required --
96 -- p_loading_status IN VARCHAR2 Required --
97 -- p_message_text IN VARCHAR2 Required --
98 -- p_return_status IN VARCHAR2 Required --
99 -- OUT : --
100 -- History --
101 -- 26-AUG-98 Ram Kalyanasundaram Created
102 -------------------------------------------------------------------------------
103 PROCEDURE Update_Row(p_api_id IN NUMBER,
104 p_loading_status IN VARCHAR2,
105 p_message_text IN VARCHAR2,
106 p_return_status IN VARCHAR2)
107 IS
108 BEGIN
109 UPDATE cn_clrl_api
110 SET loading_status = p_loading_status,
111 message_text = p_message_text,
112 return_status = p_return_status
113 WHERE clrl_api_id = p_api_id;
114 END Update_Row;
115
116 END cn_clrl_api_pkg;
117