APPS.CN_CLRL_API_PKG dependencies on CN_CLRL_API

Line 1: PACKAGE BODY cn_clrl_api_pkg AS

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: -------------------------------------------------------------------------------

Line 17: SELECT cn_clrl_api_s.NEXTVAL

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:

Line 60: INSERT INTO cn_clrl_api

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,

Line 87: DELETE FROM cn_clrl_api

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: -------------------------------------------------------------------------------

Line 109: UPDATE cn_clrl_api

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;

Line 116: END cn_clrl_api_pkg;

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: