58: l_loading_status VARCHAR2(4000);
59: l_error_status NUMBER;
60: l_error_parameter VARCHAR2(30);
61: l_count NUMBER;
62: --SK l_ruleset_rec cn_ruleset_pvt.ruleset_rec_type;
63: l_ruleset_rec_pvt cn_ruleset_pvt.ruleset_rec_type;
64:
65: --
66: -- Declaration for user hooks
59: l_error_status NUMBER;
60: l_error_parameter VARCHAR2(30);
61: l_count NUMBER;
62: --SK l_ruleset_rec cn_ruleset_pvt.ruleset_rec_type;
63: l_ruleset_rec_pvt cn_ruleset_pvt.ruleset_rec_type;
64:
65: --
66: -- Declaration for user hooks
67: --
117: 'CREATE_RULESET',
118: 'B',
119: 'C')
120: THEN
121: --SK cn_ruleset_pvt.create_ruleset
122: cn_ruleset_pub_cuhk.create_ruleset_pre
123: (p_api_version => p_api_version,
124: p_init_msg_list => p_init_msg_list,
125: p_commit => p_commit,
144: 'CREATE_RULESET',
145: 'B',
146: 'V')
147: THEN
148: --SK cn_ruleset_pvt.create_ruleset
149: cn_ruleset_pub_vuhk.create_ruleset_pre
150: (p_api_version => p_api_version,
151: p_init_msg_list => p_init_msg_list,
152: p_commit => p_commit,
245: FROM cn_lookups
246: WHERE lookup_type = 'MODULE_TYPE'
247: AND meaning = l_ruleset_rec.module_type;
248:
249: cn_ruleset_pvt.create_ruleset
250: (p_api_version => p_api_version,
251: p_init_msg_list => p_init_msg_list,
252: p_commit => p_commit,
253: p_validation_level => p_validation_level,
281: 'CREATE_RULESET',
282: 'A',
283: 'V')
284: THEN
285: --SK cn_ruleset_pvt.create_ruleset
286: cn_ruleset_pub_vuhk.create_ruleset_post
287: (p_api_version => p_api_version,
288: p_init_msg_list => p_init_msg_list,
289: p_commit => p_commit,
308: 'CREATE_RULESET',
309: 'A',
310: 'C')
311: THEN
312: --SK cn_ruleset_pvt.create_ruleset
313: cn_ruleset_pub_cuhk.create_ruleset_post
314: (p_api_version => p_api_version,
315: p_init_msg_list => p_init_msg_list,
316: p_commit => p_commit,
499: l_api_name CONSTANT VARCHAR2(30) := 'Update_Ruleset';
500: l_api_version CONSTANT NUMBER := 1.0;
501: l_loading_status VARCHAR2(4000);
502: l_count NUMBER;
503: l_old_ruleset_rec_pvt cn_ruleset_pvt.ruleset_rec_type;
504: l_ruleset_rec_pvt cn_ruleset_pvt.ruleset_rec_type;
505:
506: --
507: --Declaration for user hooks
500: l_api_version CONSTANT NUMBER := 1.0;
501: l_loading_status VARCHAR2(4000);
502: l_count NUMBER;
503: l_old_ruleset_rec_pvt cn_ruleset_pvt.ruleset_rec_type;
504: l_ruleset_rec_pvt cn_ruleset_pvt.ruleset_rec_type;
505:
506: --
507: --Declaration for user hooks
508: --
726: FROM cn_lookups
727: WHERE lookup_type = 'MODULE_TYPE'
728: AND meaning = p_old_ruleset_rec.module_type;
729:
730: cn_ruleset_pvt.update_ruleset
731: (p_api_version => p_api_version,
732: p_init_msg_list => p_init_msg_list,
733: p_commit => p_commit,
734: p_validation_level => p_validation_level,