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: -- modified for bug 15897219
2039: l_start_period_id := cn_general_utils.get_acc_fromperiod_id(l_start_date, p_org_id);
2040: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2041:

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

2036: --
2037: -- l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2038: -- modified for bug 15897219
2039: l_start_period_id := cn_general_utils.get_acc_fromperiod_id(l_start_date, p_org_id);
2040: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2041:
2042: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2043: , p_start_date_old, p_end_date_old) LOOP
2044: cn_mark_events_pkg.mark_notify(

Line 2081: cn_api.get_date_range_diff(

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

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

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

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

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

Line 2193: l_date_range_rec_tbl cn_api.date_range_tbl_type;

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

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

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

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

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

Line 2316: cn_api.get_date_range_diff(

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

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

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

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

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

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

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

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

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

Line 2605: l_date_range_tbl cn_api.date_range_tbl_type;

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

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

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

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

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

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

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

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

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

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

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

Line 2743: l_date_range_tbl cn_api.date_range_tbl_type;

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

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

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

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

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

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

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

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

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

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

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

Line 2878: l_date_range_tbl cn_api.date_range_tbl_type;

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

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

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

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

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

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

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

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

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

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

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

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

3802: , p_end_date_old => p_end_date_old
3803: , x_event_log_id => l_event_log_id
3804: , p_org_id => p_org_id
3805: );
3806: -- l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
3807: l_start_period_id := cn_general_utils.get_acc_fromperiod_id(p_start_date_old, p_org_id);
3808: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
3809:
3810: IF p_event_name = 'CHANGE_COMP_PLAN' OR p_event_name = 'CHANGE_COMP_PLAN_OVERLAP' THEN

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

3804: , p_org_id => p_org_id
3805: );
3806: -- l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
3807: l_start_period_id := cn_general_utils.get_acc_fromperiod_id(p_start_date_old, p_org_id);
3808: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
3809:
3810: IF p_event_name = 'CHANGE_COMP_PLAN' OR p_event_name = 'CHANGE_COMP_PLAN_OVERLAP' THEN
3811: FOR affected_recs IN affected_srp_curs(l_start_period_id, l_end_period_id) LOOP
3812: cn_mark_events_pkg.mark_notify(

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

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

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

4080: , l_event_log_id
4081: , p_org_id
4082: );
4083: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4084: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4085:
4086: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4087: FOR srp_quota IN affected_srp_period_quotas(
4088: l_temp_start_period_id

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

4241: , p_end_date_old
4242: , l_event_log_id
4243: , p_org_id
4244: );
4245: l_srp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4246: l_srp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4247:
4248: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4249: FOR srp_quota IN affected_srp_period_quotas(l_srp_start_period_id, l_srp_end_period_id) LOOP

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

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

Line 4643: l_date_range_tbl cn_api.date_range_tbl_type;

4639:
4640: l_event_log_id NUMBER(15);
4641: l_temp_start_period_id NUMBER(15);
4642: l_temp_end_period_id NUMBER(15);
4643: l_date_range_tbl cn_api.date_range_tbl_type;
4644:
4645: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4646: SELECT quota_id
4647: FROM cn_srp_period_quotas_all

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

4678: , p_org_id
4679: );
4680:
4681: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4682: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4683: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4684:
4685: FOR srp_quota IN affected_srp_period_quotas(
4686: l_temp_start_period_id

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

4679: );
4680:
4681: IF p_event_name = 'CHANGE_SRP_QUOTA_POP' THEN
4682: l_temp_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
4683: l_temp_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
4684:
4685: FOR srp_quota IN affected_srp_period_quotas(
4686: l_temp_start_period_id
4687: , l_temp_end_period_id

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

4742: END LOOP;
4743: END IF; -- If (dependent_pe_tbl.count > 0)
4744: END LOOP;
4745: ELSIF p_event_name = 'CHANGE_SRP_QUOTA_PAYEE_DATE' THEN
4746: cn_api.get_date_range_diff(p_start_date, p_end_date, p_start_date_old, p_end_date_old
4747: , l_date_range_tbl);
4748:
4749: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
4750: l_temp_start_period_id :=

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

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

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

4749: FOR l_ctr IN 1 .. l_date_range_tbl.COUNT LOOP
4750: l_temp_start_period_id :=
4751: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).start_date, p_org_id);
4752: l_temp_end_period_id :=
4753: cn_api.get_acc_period_id(l_date_range_tbl(l_ctr).end_date, p_org_id);
4754:
4755: FOR srp_quota IN affected_srp_period_quotas(
4756: l_temp_start_period_id
4757: , l_temp_end_period_id