APPS.CN_QUOTA_RULE_UPLIFTS_GRP dependencies on CN_QUOTA_RULE_UPLIFTS

Line 1: PACKAGE BODY cn_quota_rule_uplifts_grp AS

1: PACKAGE BODY cn_quota_rule_uplifts_grp AS
2: /* $Header: cnxgqrub.pls 120.5.12020000.2 2012/08/27 09:02:39 nbombili ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (50) := 'CN_QUOTA_RULES_UPLIFTS_GRP';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnxgqrub.pls';
5: g_program_type VARCHAR2 (30);

Line 112: FROM cn_quota_rule_uplifts

108: p_quota_rule_id NUMBER
109: )
110: IS
111: SELECT end_date
112: FROM cn_quota_rule_uplifts
113: WHERE quota_rule_id = p_quota_rule_id
114: ORDER BY start_date DESC;
115:
116: l_date_msg VARCHAR2 (100);

Line 298: FROM cn_quota_rule_uplifts qru

294: IF p_rev_class_name_old IS NULL AND p_start_date_old IS NULL
295: THEN
296: SELECT COUNT (*)
297: INTO l_same_pe
298: FROM cn_quota_rule_uplifts qru
299: WHERE qru.quota_rule_id = p_pe_rec.quota_rule_id
300: AND TRUNC (qru.start_date) = TRUNC (p_pe_rec.rev_uplift_start_date)
301: AND qru.quota_rule_uplift_id <> NVL (p_quota_rule_uplift_id, 0);
302:

Line 669: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'INSERT',

665: THEN
666: RAISE fnd_api.g_exc_error;
667: ELSIF x_loading_status <> 'QUOTA_UPLIFT_EXISTS'
668: THEN
669: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'INSERT',
670: x_org_id => l_pe_rec.org_id,
671: x_quota_rule_uplift_id => p_rev_uplift_rec_tbl (i).quota_rule_uplift_id,
672: x_quota_rule_id => l_pe_rec.quota_rule_id,
673: x_quota_rule_id_old => l_pe_rec.quota_rule_id,

Line 896: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'UPDATE',

892: THEN
893: RAISE fnd_api.g_exc_error;
894: ELSIF x_loading_status = 'CN_UPDATED'
895: THEN
896: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'UPDATE',
897: x_org_id => l_pe_rec.org_id,
898: x_quota_rule_uplift_id => p_rev_uplift_rec_tbl (i).quota_rule_uplift_id,
899: x_quota_rule_id => l_pe_rec.quota_rule_id,
900: x_quota_rule_id_old => l_pe_rec.quota_rule_id,

Line 1129: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'DELETE',

1125: THEN
1126: RAISE fnd_api.g_exc_error;
1127: ELSIF x_loading_status = 'CN_DELETED'
1128: THEN
1129: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'DELETE',
1130: x_org_id => l_pe_rec.org_id,
1131: x_quota_rule_uplift_id => l_quota_rule_uplift_id,
1132: x_quota_rule_id => NULL,
1133: x_quota_rule_id_old => NULL,

Line 1194: END cn_quota_rule_uplifts_grp;

1190: END IF;
1191:
1192: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1193: END delete_quota_rule_uplift;
1194: END cn_quota_rule_uplifts_grp;