APPS.CN_RT_QUOTA_ASGN_PVT dependencies on CN_RT_QUOTA_ASGNS

Line 107: SELECT cn_rt_quota_asgns_s.NEXTVAL,

103: -- we only insert if there are overlap
104: -- clku, fix the date not overlap issue
105: IF ((l_start_date IS NOT NULL) AND (TRUNC (l_start_date) <= TRUNC (NVL (l_end_date, l_start_date))))
106: THEN
107: SELECT cn_rt_quota_asgns_s.NEXTVAL,
108: p_calc_formula_id,
109: p_quota_id,
110: l_start_date,
111: l_end_date,

Line 142: p_old_rt_quota_asgn IN cn_rt_quota_asgns%ROWTYPE,

138: --| Delete_quota_rule
139: -- -------------------------------------------------------------------------+-+
140: PROCEDURE add_system_note(
141: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
142: p_old_rt_quota_asgn IN cn_rt_quota_asgns%ROWTYPE,
143: p_operation IN VARCHAR2,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2

Line 354: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,

350: THEN
351: RAISE fnd_api.g_exc_error;
352: END IF;
353:
354: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,
355: x_operation => 'INSERT',
356: x_rowid => g_rowid,
357: x_rt_quota_asgn_id => p_rt_quota_asgn.rt_quota_asgn_id,
358: x_calc_formula_id => p_rt_quota_asgn.calc_formula_id,

Line 477: FROM cn_rt_quota_asgns

473:
474: CURSOR l_old_rt_quota_asgn_cr
475: IS
476: SELECT *
477: FROM cn_rt_quota_asgns
478: WHERE rt_quota_asgn_id = p_rt_quota_asgn.rt_quota_asgn_id;
479:
480: l_old_rt_quota_asgn l_old_rt_quota_asgn_cr%ROWTYPE;
481: l_rt_quota_asgn rt_quota_asgn_rec_type;

Line 628: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,

624: fnd_msg_pub.ADD;
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,
629: x_operation => 'UPDATE',
630: x_rowid => g_rowid,
631: x_rt_quota_asgn_id => p_rt_quota_asgn.rt_quota_asgn_id,
632: x_calc_formula_id => p_rt_quota_asgn.calc_formula_id,

Line 779: FROM cn_rt_quota_asgns

775: p_object_version_number NUMBER;
776: /* CURSOR rt_quota_asgns_cr(l_rt_quota_asgn_id NUMBER) IS
777: SELECT rate_schedule_id,
778: quota_id
779: FROM cn_rt_quota_asgns
780: WHERE rt_quota_asgn_id = l_rt_quota_asgn_id;
781:
782: l_rt_quota_asgn rt_quota_asgns_cr%ROWTYPE;*/
783: BEGIN

Line 884: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,

880: x_rate_schedule_id => p_rate_schedule_id,
881: x_status_code => 'INCOMPLETE',
882: x_event => NULL
883: );
884: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,
885: x_operation => 'DELETE',
886: x_rowid => g_rowid,
887: x_rt_quota_asgn_id => p_rt_quota_asgn.rt_quota_asgn_id,
888: x_calc_formula_id => p_calc_formula_id,

Line 1035: FROM cn_rt_quota_asgns

1031: l_quota_id NUMBER
1032: )
1033: IS
1034: SELECT rt_quota_asgn_id
1035: FROM cn_rt_quota_asgns
1036: WHERE quota_id = l_quota_id AND calc_formula_id = l_calc_formula_id;
1037:
1038: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
1039: BEGIN

Line 1038: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;

1034: SELECT rt_quota_asgn_id
1035: FROM cn_rt_quota_asgns
1036: WHERE quota_id = l_quota_id AND calc_formula_id = l_calc_formula_id;
1037:
1038: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
1039: BEGIN
1040: -- Standard Start of API savepoint
1041: SAVEPOINT get_formula_rate_tables;
1042:

Line 1346: FROM cn_rt_quota_asgns rta

1342:
1343: -- check that you dont have any rate table in the same date range
1344: SELECT COUNT (*)
1345: INTO l_counter
1346: FROM cn_rt_quota_asgns rta
1347: WHERE rta.quota_id = p_rt_quota_asgn.quota_id
1348: AND rta.rt_quota_asgn_id <> NVL (p_rt_quota_asgn.rt_quota_asgn_id, 0)
1349: AND NVL(rta.calc_formula_id,-1) = NVL(p_rt_quota_asgn.calc_formula_id,-1)
1350: AND rta.start_date <= NVL (p_rt_quota_asgn.end_date, rta.start_date)