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_MARK_EVENTS_PKG dependencies on CN_API

Line 1073: l_start_period_id := cn_api.get_acc_period_id(p_start_date, p_org_id);

1069: , 'Beginning of mark_notify_dates ...'
1070: );
1071: END IF;
1072:
1073: l_start_period_id := cn_api.get_acc_period_id(p_start_date, p_org_id);
1074: l_end_period_id := cn_api.get_acc_period_id(p_end_date, p_org_id);
1075:
1076: FOR l_per IN l_date_periods_csr LOOP
1077: IF l_date_periods_csr%ROWCOUNT = 1 THEN

Line 1074: l_end_period_id := cn_api.get_acc_period_id(p_end_date, p_org_id);

1070: );
1071: END IF;
1072:
1073: l_start_period_id := cn_api.get_acc_period_id(p_start_date, p_org_id);
1074: l_end_period_id := cn_api.get_acc_period_id(p_end_date, p_org_id);
1075:
1076: FOR l_per IN l_date_periods_csr LOOP
1077: IF l_date_periods_csr%ROWCOUNT = 1 THEN
1078: -- it's the last period, need to mark subsequent periods

Line 1421: l_date_range_tbl cn_api.date_range_tbl_type;

1417: , p_end_date_old IN DATE
1418: , p_org_id IN NUMBER
1419: ) IS
1420: l_event_log_id NUMBER(15);
1421: l_date_range_tbl cn_api.date_range_tbl_type;
1422: BEGIN
1423: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
1424: RETURN;
1425: END IF;

Line 1450: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

1446:
1447: IF (p_event_name = 'CHANGE_CLS_RULES') THEN
1448: mark_notify_dates(p_start_date_old, p_end_date_old, 'COL', l_event_log_id, p_org_id);
1449: ELSIF(p_event_name = 'CHANGE_CLS_RULES_DATE') THEN
1450: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
1451: , l_date_range_tbl);
1452:
1453: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
1454: mark_notify_dates(

Line 1557: l_date_range_tbl cn_api.date_range_tbl_type;

1553: , p_end_date_old IN DATE
1554: , p_org_id IN NUMBER
1555: ) IS
1556: l_event_log_id NUMBER(15);
1557: l_date_range_tbl cn_api.date_range_tbl_type;
1558: BEGIN
1559: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
1560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1561: fnd_log.STRING(

Line 1583: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

1579:
1580: IF (p_event_name = 'CHANGE_RC_HIER') OR(p_event_name = 'CHANGE_RC_HIER_DELETE') THEN
1581: mark_notify_dates(p_start_date_old, p_end_date_old, 'ROLL', l_event_log_id, p_org_id);
1582: ELSIF(p_event_name = 'CHANGE_RC_HIER_DATE') THEN
1583: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
1584: , l_date_range_tbl);
1585:
1586: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
1587: mark_notify_dates(

Line 1671: l_date_range_diff_tbl cn_api.date_range_tbl_type;

1667: FROM cn_attribute_rules_all
1668: WHERE dimension_hierarchy_id = p_head_hierarchy_id
1669: AND org_id = p_org_id);
1670:
1671: l_date_range_diff_tbl cn_api.date_range_tbl_type;
1672: l_date_range_over_tbl cn_api.date_range_tbl_type;
1673: l_date_range_null_tbl cn_api.date_range_tbl_type;
1674: BEGIN
1675: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN

Line 1672: l_date_range_over_tbl cn_api.date_range_tbl_type;

1668: WHERE dimension_hierarchy_id = p_head_hierarchy_id
1669: AND org_id = p_org_id);
1670:
1671: l_date_range_diff_tbl cn_api.date_range_tbl_type;
1672: l_date_range_over_tbl cn_api.date_range_tbl_type;
1673: l_date_range_null_tbl cn_api.date_range_tbl_type;
1674: BEGIN
1675: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1673: l_date_range_null_tbl cn_api.date_range_tbl_type;

1669: AND org_id = p_org_id);
1670:
1671: l_date_range_diff_tbl cn_api.date_range_tbl_type;
1672: l_date_range_over_tbl cn_api.date_range_tbl_type;
1673: l_date_range_null_tbl cn_api.date_range_tbl_type;
1674: BEGIN
1675: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1677: fnd_log.STRING(

Line 1698: cn_api.get_date_range_overlap(

1694: );
1695:
1696: IF (p_event_name = 'CHANGE_CLS_HIER') OR(p_event_name = 'CHANGE_CLS_HIER_DELETE') THEN
1697: FOR l_set IN l_ruleset_dates_csr LOOP
1698: cn_api.get_date_range_overlap(
1699: p_start_date_old
1700: , p_end_date_old
1701: , l_set.start_date
1702: , l_set.end_date

Line 1721: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

1717: l_date_range_over_tbl := l_date_range_null_tbl;
1718: END LOOP;
1719: ELSIF(p_event_name = 'CHANGE_CLS_HIER_DATE') THEN
1720: -- first get the date diff before comparing with rulesets date range
1721: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
1722: , l_date_range_diff_tbl);
1723:
1724: -- then get the overlap
1725: FOR l_diff_ctr IN 1 .. l_date_range_diff_tbl.COUNT LOOP

Line 1727: cn_api.get_date_range_overlap(

1723:
1724: -- then get the overlap
1725: FOR l_diff_ctr IN 1 .. l_date_range_diff_tbl.COUNT LOOP
1726: FOR l_set IN l_ruleset_dates_csr LOOP
1727: cn_api.get_date_range_overlap(
1728: l_date_range_diff_tbl(l_diff_ctr).start_date
1729: , l_date_range_diff_tbl(l_diff_ctr).end_date
1730: , l_set.start_date
1731: , l_set.end_date

Line 1829: l_date_range_rec_tbl cn_api.date_range_tbl_type;

1825: , p_end_date_old DATE
1826: , p_org_id NUMBER
1827: ) IS
1828: l_event_log_id NUMBER;
1829: l_date_range_rec_tbl cn_api.date_range_tbl_type;
1830: l_start_period_id NUMBER(15);
1831: l_end_period_id NUMBER(15);
1832: l_start_date DATE;
1833: l_end_date DATE;

Line 1930: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);

1926: OPEN l_quota_dates_csr;
1927: FETCH l_quota_dates_csr INTO l_start_date, l_end_date;
1928: CLOSE l_quota_dates_csr;
1929:
1930: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);
1931: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
1932:
1933: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
1934: , l_start_date, l_end_date) LOOP

Line 1931: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);

1927: FETCH l_quota_dates_csr INTO l_start_date, l_end_date;
1928: CLOSE l_quota_dates_csr;
1929:
1930: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);
1931: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
1932:
1933: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
1934: , l_start_date, l_end_date) LOOP
1935: -- modified by rjin 11/10/1999

Line 1974: cn_api.get_date_range_diff(

1970: END LOOP;
1971: END IF; -- If (dependent_pe_tbl.count > 0)
1972: END LOOP;
1973: ELSIF p_event_name = 'CHANGE_QUOTA_DATE' THEN
1974: cn_api.get_date_range_diff(
1975: a_start_date => p_start_date
1976: , a_end_date => p_end_date
1977: , b_start_date => p_start_date_old
1978: , b_end_date => p_end_date_old

Line 1984: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);

1980: );
1981:
1982: FOR i IN 1 .. l_date_range_rec_tbl.COUNT LOOP
1983: l_start_period_id :=
1984: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
1985: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
1986:
1987: FOR affected_period_recs IN affected_srp_period_curs(
1988: l_start_period_id

Line 1985: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);

1981:
1982: FOR i IN 1 .. l_date_range_rec_tbl.COUNT LOOP
1983: l_start_period_id :=
1984: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
1985: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
1986:
1987: FOR affected_period_recs IN affected_srp_period_curs(
1988: l_start_period_id
1989: , l_end_period_id

Line 2013: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);

2009: OPEN l_quota_dates_csr;
2010: FETCH l_quota_dates_csr INTO l_start_date, l_end_date;
2011: CLOSE l_quota_dates_csr;
2012:
2013: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);
2014: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
2015:
2016: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2017: , l_start_date, l_end_date) LOOP

Line 2014: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);

2010: FETCH l_quota_dates_csr INTO l_start_date, l_end_date;
2011: CLOSE l_quota_dates_csr;
2012:
2013: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);
2014: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
2015:
2016: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2017: , l_start_date, l_end_date) LOOP
2018: -- modified by rjin 11/10/1999

Line 2037: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

2033: ELSIF p_event_name = 'CHANGE_QUOTA_POP' THEN
2034: --
2035: -- 1. Insert/Delete in Rule Uplifts
2036: --
2037: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2038: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2039:
2040: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2041: , p_start_date_old, p_end_date_old) LOOP

Line 2038: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

2034: --
2035: -- 1. Insert/Delete in Rule Uplifts
2036: --
2037: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2038: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2039:
2040: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2041: , p_start_date_old, p_end_date_old) LOOP
2042: cn_mark_events_pkg.mark_notify(

Line 2079: cn_api.get_date_range_diff(

2075: ELSIF p_event_name = 'CHANGE_QUOTA_UPLIFT_DATE' THEN
2076: --
2077: -- Update Uplift Start Date and End Date
2078: --
2079: cn_api.get_date_range_diff(
2080: a_start_date => p_start_date
2081: , a_end_date => p_end_date
2082: , b_start_date => p_start_date_old
2083: , b_end_date => p_end_date_old

Line 2089: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);

2085: );
2086:
2087: FOR i IN 1 .. l_date_range_rec_tbl.COUNT LOOP
2088: l_start_period_id :=
2089: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
2090: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
2091:
2092: FOR affected_period_recs IN affected_srp_period_curs(
2093: l_start_period_id

Line 2090: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);

2086:
2087: FOR i IN 1 .. l_date_range_rec_tbl.COUNT LOOP
2088: l_start_period_id :=
2089: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
2090: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
2091:
2092: FOR affected_period_recs IN affected_srp_period_curs(
2093: l_start_period_id
2094: , l_end_period_id

Line 2191: l_date_range_rec_tbl cn_api.date_range_tbl_type;

2187: , p_end_date_old DATE
2188: , p_org_id NUMBER
2189: ) IS
2190: l_event_log_id NUMBER;
2191: l_date_range_rec_tbl cn_api.date_range_tbl_type;
2192: l_start_period_id NUMBER(15);
2193: l_end_period_id NUMBER(15);
2194:
2195: CURSOR affected_srp_period_curs(l_start_period_id NUMBER, l_end_period_id NUMBER) IS

Line 2273: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

2269: -- Check the Event Name
2270: --
2271: IF p_event_name = 'CHANGE_QUOTA_CALC' THEN
2272: -- 1. update cn_trx_factors.event_factor
2273: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2274: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2275:
2276: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2277: cn_mark_events_pkg.mark_notify(

Line 2274: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

2270: --
2271: IF p_event_name = 'CHANGE_QUOTA_CALC' THEN
2272: -- 1. update cn_trx_factors.event_factor
2273: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2274: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2275:
2276: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2277: cn_mark_events_pkg.mark_notify(
2278: p_salesrep_id => affected_recs.salesrep_id

Line 2314: cn_api.get_date_range_diff(

2310: ELSIF p_event_name = 'CHANGE_QUOTA_RT_DATE' THEN
2311: --
2312: -- Update rt_quota Assigns Start Date, End Date
2313: --
2314: cn_api.get_date_range_diff(
2315: a_start_date => p_start_date
2316: , a_end_date => p_end_date
2317: , b_start_date => p_start_date_old
2318: , b_end_date => p_end_date_old

Line 2324: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);

2320: );
2321:
2322: FOR i IN 1 .. l_date_range_rec_tbl.COUNT LOOP
2323: l_start_period_id :=
2324: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
2325: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
2326:
2327: FOR affected_period_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2328: cn_mark_events_pkg.mark_notify(

Line 2325: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);

2321:
2322: FOR i IN 1 .. l_date_range_rec_tbl.COUNT LOOP
2323: l_start_period_id :=
2324: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
2325: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
2326:
2327: FOR affected_period_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2328: cn_mark_events_pkg.mark_notify(
2329: p_salesrep_id => affected_period_recs.salesrep_id

Line 2500: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);

2496: OPEN l_quota_dates_csr;
2497: FETCH l_quota_dates_csr INTO l_start_date, l_end_date;
2498: CLOSE l_quota_dates_csr;
2499:
2500: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);
2501: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
2502:
2503: -- clku, move get_parent_plan_elts outside the period/salesrep loop
2504: IF (p_object_id IS NOT NULL) THEN

Line 2501: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);

2497: FETCH l_quota_dates_csr INTO l_start_date, l_end_date;
2498: CLOSE l_quota_dates_csr;
2499:
2500: l_start_period_id := cn_api.get_acc_period_id(l_start_date, p_org_id);
2501: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
2502:
2503: -- clku, move get_parent_plan_elts outside the period/salesrep loop
2504: IF (p_object_id IS NOT NULL) THEN
2505: cn_calc_sql_exps_pvt.get_parent_plan_elts(

Line 2603: l_date_range_tbl cn_api.date_range_tbl_type;

2599: l_role_id cn_role_plans.role_id%TYPE;
2600: l_event_log_id NUMBER;
2601: l_start_period_id NUMBER(15);
2602: l_end_period_id NUMBER(15);
2603: l_date_range_tbl cn_api.date_range_tbl_type;
2604:
2605: CURSOR affected_srp_period(l_s_date DATE, l_e_date DATE) IS
2606: -- for CHANGE_SRP_ROLE_PLAN
2607: -- use the start_date/end_date info to restrict the periods affected.

Line 2652: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

2648: , p_org_id
2649: );
2650:
2651: IF p_event_name = 'CHANGE_SRP_ROLE_PLAN' THEN
2652: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2653: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2654:
2655: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2656: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id

Line 2653: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

2649: );
2650:
2651: IF p_event_name = 'CHANGE_SRP_ROLE_PLAN' THEN
2652: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2653: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2654:
2655: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2656: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2657: cn_mark_events_pkg.mark_notify(

Line 2670: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

2666: , p_org_id
2667: );
2668: END LOOP;
2669: ELSIF p_event_name = 'CHANGE_SRP_ROLE_PLAN_DATE' THEN
2670: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
2671: , l_date_range_tbl);
2672:
2673: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2674: --bug fix 6890504 raj

Line 2676: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date - 1, p_org_id);

2672:
2673: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2674: --bug fix 6890504 raj
2675: l_start_period_id :=
2676: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date - 1, p_org_id);
2677: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
2678:
2679: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2680: , l_date_range_tbl(l_ctr).end_date) LOOP

Line 2677: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);

2673: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2674: --bug fix 6890504 raj
2675: l_start_period_id :=
2676: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date - 1, p_org_id);
2677: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
2678:
2679: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2680: , l_date_range_tbl(l_ctr).end_date) LOOP
2681: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id

Line 2741: l_date_range_tbl cn_api.date_range_tbl_type;

2737: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
2738: l_event_log_id NUMBER;
2739: l_start_period_id NUMBER(15);
2740: l_end_period_id NUMBER(15);
2741: l_date_range_tbl cn_api.date_range_tbl_type;
2742:
2743: CURSOR affected_srp_period(l_s_date DATE, l_e_date DATE) IS
2744: -- for CHANGE_SRP_ROLE_PLAN
2745: -- use the start_date/end_date info to restrict the periods affected.

Line 2788: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

2784: , p_org_id
2785: );
2786:
2787: IF p_event_name = 'CHANGE_SRP_PAY_GROUP' THEN
2788: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2789: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2790:
2791: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2792: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id

Line 2789: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

2785: );
2786:
2787: IF p_event_name = 'CHANGE_SRP_PAY_GROUP' THEN
2788: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2789: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2790:
2791: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2792: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2793: cn_mark_events_pkg.mark_notify(

Line 2806: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

2802: , p_org_id
2803: );
2804: END LOOP;
2805: ELSIF p_event_name = 'CHANGE_SRP_PAY_GROUP_DATE' THEN
2806: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
2807: , l_date_range_tbl);
2808:
2809: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2810: l_start_period_id :=

Line 2811: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date - 1, p_org_id);

2807: , l_date_range_tbl);
2808:
2809: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2810: l_start_period_id :=
2811: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date - 1, p_org_id);
2812: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
2813:
2814: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2815: , l_date_range_tbl(l_ctr).end_date) LOOP

Line 2812: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);

2808:
2809: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2810: l_start_period_id :=
2811: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date - 1, p_org_id);
2812: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
2813:
2814: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2815: , l_date_range_tbl(l_ctr).end_date) LOOP
2816: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id

Line 2876: l_date_range_tbl cn_api.date_range_tbl_type;

2872: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;
2873: l_event_log_id NUMBER;
2874: l_start_period_id NUMBER(15);
2875: l_end_period_id NUMBER(15);
2876: l_date_range_tbl cn_api.date_range_tbl_type;
2877:
2878: CURSOR affected_srp_period(l_s_date DATE, l_e_date DATE) IS
2879: -- for CHANGE_SRP_ROLE_PLAN
2880: -- use the start_date/end_date info to restrict the periods affected.

Line 2921: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

2917: , p_org_id
2918: );
2919:
2920: IF p_event_name = 'CHANGE_SRP_ROLE_PLAN' THEN
2921: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2922: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2923:
2924: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2925: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id

Line 2922: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

2918: );
2919:
2920: IF p_event_name = 'CHANGE_SRP_ROLE_PLAN' THEN
2921: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2922: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2923:
2924: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2925: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2926:

Line 2943: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

2939: , p_org_id => p_org_id
2940: );
2941: END LOOP;
2942: ELSIF p_event_name = 'CHANGE_SRP_ROLE_PLAN_DATE' THEN
2943: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
2944: , l_date_range_tbl);
2945:
2946: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2947: l_start_period_id :=

Line 2948: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);

2944: , l_date_range_tbl);
2945:
2946: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2947: l_start_period_id :=
2948: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);
2949: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
2950:
2951: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date
2952: , l_date_range_tbl(l_ctr).end_date) LOOP

Line 2949: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);

2945:
2946: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
2947: l_start_period_id :=
2948: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);
2949: l_end_period_id := cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
2950:
2951: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date
2952: , l_date_range_tbl(l_ctr).end_date) LOOP
2953: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id

Line 3804: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

3800: , p_end_date_old => p_end_date_old
3801: , x_event_log_id => l_event_log_id
3802: , p_org_id => p_org_id
3803: );
3804: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
3805: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
3806:
3807: IF p_event_name = 'CHANGE_COMP_PLAN' OR p_event_name = 'CHANGE_COMP_PLAN_OVERLAP' THEN
3808: FOR affected_recs IN affected_srp_curs(l_start_period_id, l_end_period_id) LOOP

Line 3805: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

3801: , x_event_log_id => l_event_log_id
3802: , p_org_id => p_org_id
3803: );
3804: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
3805: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
3806:
3807: IF p_event_name = 'CHANGE_COMP_PLAN' OR p_event_name = 'CHANGE_COMP_PLAN_OVERLAP' THEN
3808: FOR affected_recs IN affected_srp_curs(l_start_period_id, l_end_period_id) LOOP
3809: cn_mark_events_pkg.mark_notify(

Line 4079: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

4075: , p_end_date_old
4076: , l_event_log_id
4077: , p_org_id
4078: );
4079: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4080: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4081:
4082: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4083: FOR srp_quota IN affected_srp_period_quotas(

Line 4080: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

4076: , l_event_log_id
4077: , p_org_id
4078: );
4079: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4080: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4081:
4082: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4083: FOR srp_quota IN affected_srp_period_quotas(
4084: l_temp_start_period_id

Line 4241: l_srp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

4237: , p_end_date_old
4238: , l_event_log_id
4239: , p_org_id
4240: );
4241: l_srp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4242: l_srp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4243:
4244: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4245: FOR srp_quota IN affected_srp_period_quotas(l_srp_start_period_id, l_srp_end_period_id) LOOP

Line 4242: l_srp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

4238: , l_event_log_id
4239: , p_org_id
4240: );
4241: l_srp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4242: l_srp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4243:
4244: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4245: FOR srp_quota IN affected_srp_period_quotas(l_srp_start_period_id, l_srp_end_period_id) LOOP
4246: IF l_latest_quota_id <> srp_quota.quota_id THEN

Line 4638: l_date_range_tbl cn_api.date_range_tbl_type;

4634:
4635: l_event_log_id NUMBER(15);
4636: l_temp_start_period_id NUMBER(15);
4637: l_temp_end_period_id NUMBER(15);
4638: l_date_range_tbl cn_api.date_range_tbl_type;
4639:
4640: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4641: SELECT quota_id
4642: FROM cn_srp_period_quotas_all

Line 4677: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);

4673: , p_org_id
4674: );
4675:
4676: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4677: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4678: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4679:
4680: FOR srp_quota IN affected_srp_period_quotas(
4681: l_temp_start_period_id

Line 4678: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);

4674: );
4675:
4676: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4677: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4678: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4679:
4680: FOR srp_quota IN affected_srp_period_quotas(
4681: l_temp_start_period_id
4682: , l_temp_end_period_id

Line 4741: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old

4737: END LOOP;
4738: END IF; -- If (dependent_pe_tbl.count > 0)
4739: END LOOP;
4740: ELSIF p_event_name = 'CHANGE_SRP_QUOTA_PAYEE_DATE' THEN
4741: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
4742: , l_date_range_tbl);
4743:
4744: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
4745: l_temp_start_period_id :=

Line 4746: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);

4742: , l_date_range_tbl);
4743:
4744: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
4745: l_temp_start_period_id :=
4746: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);
4747: l_temp_end_period_id :=
4748: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
4749:
4750: FOR srp_quota IN affected_srp_period_quotas(

Line 4748: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);

4744: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
4745: l_temp_start_period_id :=
4746: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);
4747: l_temp_end_period_id :=
4748: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
4749:
4750: FOR srp_quota IN affected_srp_period_quotas(
4751: l_temp_start_period_id
4752: , l_temp_end_period_id