[Home] [Help]
PACKAGE: APPS.CN_CLRL_API_PKG
Source
1 PACKAGE cn_clrl_api_pkg AUTHID CURRENT_USER AS
2 -- $Header: cncrapis.pls 115.3 99/07/16 07:05:52 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
16 -------------------------------------------------------------------------------
17 -- Function Name : Insert_Row --
18 -- Purpose : Insert a row into the table --
19 -- Parameters : --
20 -- IN : p_api_id IN NUMBER Required --
21 -- p_ruleset_name IN VARCHAR2 Required --
22 -- p_parent_rule_name IN VARCHAR2 Required --
23 -- p_rule_name IN VARCHAR2 Required --
24 -- p_revenue_class_name IN VARCHAR2 Required --
25 -- p_attribute_rule_name IN VARCHAR2 Required --
26 -- p_not_flag IN VARCHAR2 Required --
27 -- p_value_1 IN VARCHAR2 Required --
28 -- p_value_2 IN VARCHAR2 Required --
29 -- p_data_flag IN VARCHAR2 Required --
30 -- p_loading_status IN VARCHAR2 Required --
31 -- p_object_name IN VARCHAR2 Required --
32 -- p_message_text IN VARCHAR2 Required --
33 -- p_return_status IN VARCHAR2 Required --
34 -- OUT : --
35 -- History --
36 -- 26-AUG-98 Ram Kalyanasundaram Created
37 -------------------------------------------------------------------------------
38 PROCEDURE Insert_Row(p_api_id IN NUMBER,
39 p_ruleset_name IN VARCHAR2,
40 p_parent_rule_name IN VARCHAR2,
41 p_rule_name IN VARCHAR2,
42 p_revenue_class_name IN VARCHAR2,
43 p_attribute_rule_name IN VARCHAR2,
44 p_not_flag IN VARCHAR2,
45 p_value_1 IN VARCHAR2,
46 p_value_2 IN VARCHAR2,
47 p_data_flag IN VARCHAR2,
48 p_loading_status IN VARCHAR2,
49 p_object_name IN VARCHAR2,
50 p_message_text IN VARCHAR2,
51 p_return_status IN VARCHAR2);
52
53 -------------------------------------------------------------------------------
54 -- Function Name : Delete_Row --
55 -- Purpose : Delete a row if the given primary key exists --
56 -- Parameters : --
57 -- IN : p_api_id IN NUMBER Required --
58 -- OUT : --
59 -- History --
60 -- 26-AUG-98 Ram Kalyanasundaram Created
61 -------------------------------------------------------------------------------
62 PROCEDURE Delete_Row(p_api_id IN NUMBER);
63
64 -------------------------------------------------------------------------------
65 -- Function Name : Update_Row --
66 -- Purpose : Update a row if the given primary key exists --
67 -- Parameters : --
68 -- IN : p_api_id IN NUMBER Required --
69 -- p_loading_status IN VARCHAR2 Required --
70 -- p_message_text IN VARCHAR2 Required --
71 -- p_return_status IN VARCHAR2 Required --
72 -- OUT : --
73 -- History --
74 -- 26-AUG-98 Ram Kalyanasundaram Created
75 -------------------------------------------------------------------------------
76 PROCEDURE Update_Row(p_api_id IN NUMBER,
77 p_loading_status IN VARCHAR2,
78 p_message_text IN VARCHAR2,
79 p_return_status IN VARCHAR2);
80
81 END cn_clrl_api_pkg;
82