APPS.CN_QUOTA_RULES_GRP dependencies on CN_QUOTA_RULES

Line 1: PACKAGE BODY CN_QUOTA_RULES_GRP AS

1: PACKAGE BODY CN_QUOTA_RULES_GRP AS
2: /* $Header: cnxgqrb.pls 120.4 2005/10/18 07:26:19 chanthon noship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_QUOTA_RULES_GRP';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnxgqrb.pls';
5: g_last_update_date DATE := SYSDATE;

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_QUOTA_RULES_GRP';

1: PACKAGE BODY CN_QUOTA_RULES_GRP AS
2: /* $Header: cnxgqrb.pls 120.4 2005/10/18 07:26:19 chanthon noship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_QUOTA_RULES_GRP';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnxgqrb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;

Line 184: FROM cn_quota_rules qr

180: IF p_rev_class_name_old IS NULL
181: THEN
182: SELECT COUNT (*)
183: INTO l_same_pe
184: FROM cn_quota_rules qr
185: WHERE qr.revenue_class_id = (SELECT revenue_class_id
186: FROM cn_revenue_classes
187: WHERE NAME = p_pe_rec.rev_class_name
188: AND org_id = p_pe_rec.org_id) AND qr.quota_id = p_pe_rec.quota_id;

Line 282: FROM cn_quota_rules qr

278: END IF;
279:
280: SELECT COUNT (*)
281: INTO l_same_pe
282: FROM cn_quota_rules qr
283: WHERE qr.revenue_class_id = (SELECT revenue_class_id
284: FROM cn_revenue_classes
285: WHERE revenue_class_id = x_rev_class_id_old) AND qr.quota_id = p_new_pe_rec.quota_id;
286:

Line 303: FROM cn_quota_rules qr

299: IF p_new_pe_rec.rev_class_id <> NVL (x_rev_class_id_old, 0)
300: THEN
301: SELECT COUNT (*)
302: INTO l_same_pe
303: FROM cn_quota_rules qr
304: WHERE qr.revenue_class_id = (SELECT revenue_class_id
305: FROM cn_revenue_classes
306: WHERE revenue_class_id = p_new_pe_rec.rev_class_id) AND qr.quota_id = p_new_pe_rec.quota_id;
307:

Line 505: cn_quota_rules_pkg.begin_record (x_operation => 'INSERT',

501: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_INSERTED')
502: THEN
503: IF l_pe_rec.incentive_type_code IN ('COMMISSION', 'BONUS')
504: THEN
505: cn_quota_rules_pkg.begin_record (x_operation => 'INSERT',
506: x_object_version_number => l_pe_rec.object_version_number,
507: x_org_id => l_pe_rec.org_id,
508: x_quota_rule_id => l_pe_rec.quota_rule_id,
509: x_quota_id => l_pe_rec.quota_id,

Line 760: cn_quota_rules_pkg.begin_record (x_operation => 'UPDATE',

756: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_UPDATED')
757: THEN
758: IF l_pe_rec.incentive_type_code IN ('COMMISSION', 'BONUS')
759: THEN
760: cn_quota_rules_pkg.begin_record (x_operation => 'UPDATE',
761: x_quota_rule_id => l_quota_rule_id,
762: x_object_version_number => l_pe_rec.object_version_number,
763: x_org_id => l_pe_rec.org_id,
764: x_quota_id => l_pe_rec.quota_id,

Line 890: l_rev_rec cn_quota_rules%ROWTYPE;

886: )
887: IS
888: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Plan_Element';
889: l_api_version CONSTANT NUMBER := 1.0;
890: l_rev_rec cn_quota_rules%ROWTYPE;
891: l_loading_status VARCHAR2 (80);
892: BEGIN
893: -- Standard Start of API savepoint
894: SAVEPOINT delete_plan_element;

Line 998: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => l_rev_rec.quota_id,

994: RAISE fnd_api.g_exc_error;
995: ELSIF (x_return_status = fnd_api.g_ret_sts_success AND x_loading_status = 'CN_DELETED')
996: THEN
997: -- Delete Record;
998: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => l_rev_rec.quota_id,
999: x_quota_rule_id => l_rev_rec.quota_rule_id,
1000: x_revenue_class_id => l_rev_rec.revenue_class_id
1001: );
1002: END IF;

Line 1041: END cn_quota_rules_grp;

1037: END IF;
1038:
1039: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1040: END delete_quota_rules;
1041: END cn_quota_rules_grp;