eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PERIODS_PVT dependencies on CN_SRP_PERIODS_ALL

Line 121: FROM cn_srp_periods_all sp, cn_period_statuses_all p

117: balance4_ctd, balance4_dtd,
118: balance4_bbc, balance4_bbd,
119: balance5_ctd, balance5_dtd,
120: balance5_bbc, balance5_bbd
121: FROM cn_srp_periods_all sp, cn_period_statuses_all p
122: WHERE role_id = p_role_id
123: AND salesrep_id = p_salesrep_id
124: AND sp.org_id = p_org_id
125: AND credit_type_id = p_credit_type_id

Line 156: from cn_srp_periods_all p1, cn_srp_periods_all p2,

152: nvl(sum(p2.balance4_bbd),0) balance4_bbd,
153: nvl(sum(p2.balance5_bbc),0) balance5_bbc,
154: nvl(sum(p2.balance5_bbd),0) balance5_bbd,
155: p.period_year
156: from cn_srp_periods_all p1, cn_srp_periods_all p2,
157: cn_period_statuses_all p
158: where p1.salesrep_id = p_salesrep_id
159: and p1.credit_type_id = p_credit_type_id
160: AND p1.org_id = p_org_id

Line 179: FROM cn_srp_periods_all sp

175: balance2_bbd, balance2_bbc,
176: balance3_bbd, balance3_bbc,
177: balance4_bbd, balance4_bbc,
178: balance5_bbd, balance5_bbc
179: FROM cn_srp_periods_all sp
180: WHERE role_id = -1
181: AND salesrep_id = p_salesrep_id
182: AND org_id = p_org_id
183: AND credit_type_id = p_credit_type_id

Line 215: update cn_srp_periods_all

211: end if;
212:
213: -- no need to update periods before start period
214: if b.period_id >= p_start_period_id then
215: update cn_srp_periods_all
216: set balance1_bbc = l_cache_bal1_bbc,
217: balance1_bbd = l_cache_bal1_bbd,
218: balance2_bbc = l_cache_bal2_bbc,
219: balance2_bbd = l_cache_bal2_bbd,

Line 259: update cn_srp_periods_all

255: l_cache_bal5_bbc := 0;
256: l_cache_bal5_bbd := 0;
257: for p in get_summ_srp_periods loop
258: if p.period_id >= p_start_period_id then
259: update cn_srp_periods_all
260: set balance1_ctd = p.balance1_ctd,
261: balance1_dtd = p.balance1_dtd,
262: balance2_ctd = p.balance2_ctd,
263: balance2_dtd = p.balance2_dtd,

Line 291: update cn_srp_periods_all

287: -- ***************************************
288: -- Bug5707688 is fixed by changing > to >=
289: -- ***************************************
290: if p.period_id >= p_start_period_id then
291: update cn_srp_periods_all
292: SET balance1_bbc = l_cache_bal1_bbc,
293: balance1_bbd = l_cache_bal1_bbd,
294: balance2_bbc = l_cache_bal2_bbc,
295: balance2_bbd = l_cache_bal2_bbd,

Line 313: update cn_srp_periods_all

309: open get_carry_bal(p.period_id);
310: fetch get_carry_bal into cb;
311: close get_carry_bal;
312:
313: update cn_srp_periods_all
314: SET balance1_bbc=l_cache_bal1_bbc - p.balance1_bbc + cb.balance1_bbc,
315: balance1_bbd=l_cache_bal1_bbd - p.balance1_bbd + cb.balance1_bbd,
316: balance2_bbc=l_cache_bal2_bbc - p.balance2_bbc + cb.balance2_bbc,
317: balance2_bbd=l_cache_bal2_bbd - p.balance2_bbd + cb.balance2_bbd,

Line 465: and not exists (select 1 from cn_srp_periods_all

461: and r.period_type_id = p.period_type_id
462: and r.period_set_id = p.period_set_id
463: AND p.org_id = l_org_id
464: AND r.org_id = l_org_id
465: and not exists (select 1 from cn_srp_periods_all
466: where salesrep_id = p_salesrep_id and period_id = p.period_id
467: and role_id is null and quota_id is NULL
468: AND org_id = l_org_id
469: AND credit_type_id = c_credit_type_id)

Line 481: and not exists (select 1 from cn_srp_periods_all

477: and r.period_type_id = p.period_type_id
478: and r.period_set_id = p.period_set_id
479: AND p.org_id = l_org_id
480: AND r.org_id = l_org_id
481: and not exists (select 1 from cn_srp_periods_all
482: where salesrep_id = p_salesrep_id and period_id = p.period_id
483: and role_id = -1 and quota_id = -1000
484: AND org_id = l_org_id
485: AND credit_type_id = c_credit_type_id)

Line 491: from cn_srp_periods_all

487:
488:
489: CURSOR get_srp_cts IS
490: select distinct credit_type_id
491: from cn_srp_periods_all
492: where salesrep_id = p_salesrep_id
493: AND org_id = l_org_id
494: and quota_id is not null
495: and credit_type_id is not null;

Line 567: FROM cn_srp_periods_all

563: EXIT WHEN c_quota_csr%NOTFOUND;
564:
565: FOR i IN 1 .. l_pay_period_rec_tbl.COUNT LOOP
566: SELECT count(1) INTO l_dummy
567: FROM cn_srp_periods_all
568: WHERE salesrep_id = p_salesrep_id
569: AND org_id = l_org_id
570: AND period_id = l_pay_period_rec_tbl(i).period_id
571: AND role_id = p_role_id

Line 601: update cn_srp_periods_all

597: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
598: );
599: ELSE
600: -- records exist - update plan assign ID
601: update cn_srp_periods_all
602: set srp_plan_assign_id = l_srp_plan_assign_id,
603: start_date = l_pay_period_rec_tbl(i).start_date,
604: end_date = l_pay_period_rec_tbl(i).end_date
605: where salesrep_id = p_salesrep_id

Line 633: from cn_srp_periods_all

629: -- credit types
630: -- get min srp period ID
631: for ct in get_srp_cts loop
632: select min(period_id) into l_min_period_id
633: from cn_srp_periods_all
634: where salesrep_id = p_salesrep_id
635: AND org_id = l_org_id
636: and quota_id is not null
637: and credit_type_id = ct.credit_type_id;

Line 801: UPDATE cn_srp_periods_all

797: x_loading_status := 'CN_UPDATED';
798: -- API body
799:
800: -- Update record's ctd and dtd
801: UPDATE cn_srp_periods_all
802: SET
803: balance1_ctd = (Nvl(balance1_ctd,0) +
804: Nvl(p_del_srp_prd_rec.del_balance1_ctd,0)),
805: balance1_dtd = (Nvl(balance1_dtd,0) +

Line 921: FROM cn_srp_periods_all

917: -- populate header info of delta srp period rec
918: BEGIN
919: SELECT salesrep_id, credit_type_id, role_id, org_id
920: INTO l_salesrep_id, l_credit_type_id, l_role_id, l_org_id
921: FROM cn_srp_periods_all
922: WHERE srp_period_id = p_del_srp_prd_rec.srp_period_id;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)