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 2007/08/10 20:40:34 rnagired 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 878: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'UPDATE',

874: THEN
875: RAISE fnd_api.g_exc_error;
876: ELSIF x_loading_status = 'CN_UPDATED'
877: THEN
878: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'UPDATE',
879: x_org_id => l_pe_rec.org_id,
880: x_quota_rule_uplift_id => p_rev_uplift_rec_tbl (i).quota_rule_uplift_id,
881: x_quota_rule_id => l_pe_rec.quota_rule_id,
882: x_quota_rule_id_old => l_pe_rec.quota_rule_id,

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

1107: THEN
1108: RAISE fnd_api.g_exc_error;
1109: ELSIF x_loading_status = 'CN_DELETED'
1110: THEN
1111: cn_quota_rule_uplifts_pkg.begin_record (x_operation => 'DELETE',
1112: x_org_id => l_pe_rec.org_id,
1113: x_quota_rule_uplift_id => l_quota_rule_uplift_id,
1114: x_quota_rule_id => NULL,
1115: x_quota_rule_id_old => NULL,

Line 1176: END cn_quota_rule_uplifts_grp;

1172: END IF;
1173:
1174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1175: END delete_quota_rule_uplift;
1176: END cn_quota_rule_uplifts_grp;