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_PLAN_ELEMENT_PUB dependencies on CN_CHK_PLAN_ELEMENT_PKG

Line 280: RETURN cn_chk_plan_element_pkg.pe_rec_type

276: x_return_status OUT NOCOPY VARCHAR2,
277: p_loading_status IN VARCHAR2,
278: x_loading_status OUT NOCOPY VARCHAR2
279: )
280: RETURN cn_chk_plan_element_pkg.pe_rec_type
281: IS
282: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;
283: BEGIN
284: -- Set the Status

Line 282: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;

278: x_loading_status OUT NOCOPY VARCHAR2
279: )
280: RETURN cn_chk_plan_element_pkg.pe_rec_type
281: IS
282: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;
283: BEGIN
284: -- Set the Status
285: x_return_status := fnd_api.g_ret_sts_success;
286: x_loading_status := p_loading_status;

Line 410: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,

406: -- Can Not Missing/Null and quota_type_code
407: -- -------------------------------------------------------------------------+-+
408: PROCEDURE chk_pe_required (
409: x_return_status OUT NOCOPY VARCHAR2,
410: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,
411: p_loading_status IN VARCHAR2,
412: x_loading_status OUT NOCOPY VARCHAR2
413: )
414: IS

Line 423: p_para_name => cn_chk_plan_element_pkg.g_pe_name,

419: x_loading_status := p_loading_status;
420:
421: -- Check if plan element name is missing or null
422: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.NAME,
423: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
424: p_loading_status => x_loading_status,
425: x_loading_status => l_loading_status
426: )
427: ) = fnd_api.g_true

Line 432: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,

428: )
429: THEN
430: RAISE fnd_api.g_exc_error;
431: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.NAME,
432: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
433: p_loading_status => x_loading_status,
434: x_loading_status => l_loading_status
435: )
436: ) = fnd_api.g_true

Line 444: p_para_name => cn_chk_plan_element_pkg.g_element_type,

440: END IF;
441:
442: -- Check quota_type_code can not be missing or NULL
443: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.quota_type_code,
444: p_para_name => cn_chk_plan_element_pkg.g_element_type,
445: p_loading_status => x_loading_status,
446: x_loading_status => l_loading_status
447: )
448: ) = fnd_api.g_true

Line 453: p_obj_name => cn_chk_plan_element_pkg.g_element_type,

449: )
450: THEN
451: RAISE fnd_api.g_exc_error;
452: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.quota_type_code,
453: p_obj_name => cn_chk_plan_element_pkg.g_element_type,
454: p_loading_status => x_loading_status,
455: x_loading_status => l_loading_status
456: )
457: ) = fnd_api.g_true

Line 465: p_para_name => cn_chk_plan_element_pkg.g_credit_type_name,

461: END IF;
462:
463: -- Check credit_type can not be missing or NULL
464: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.credit_type,
465: p_para_name => cn_chk_plan_element_pkg.g_credit_type_name,
466: p_loading_status => x_loading_status,
467: x_loading_status => l_loading_status
468: )
469: ) = fnd_api.g_true

Line 474: p_obj_name => cn_chk_plan_element_pkg.g_credit_type_name,

470: )
471: THEN
472: RAISE fnd_api.g_exc_error;
473: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.credit_type,
474: p_obj_name => cn_chk_plan_element_pkg.g_credit_type_name,
475: p_loading_status => x_loading_status,
476: x_loading_status => l_loading_status
477: )
478: ) = fnd_api.g_true

Line 514: p_para_name => cn_chk_plan_element_pkg.g_incentive_type_code,

510: END IF;
511:
512: -- Check incentive_type_code can not be missing or NULL
513: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.incentive_type_code,
514: p_para_name => cn_chk_plan_element_pkg.g_incentive_type_code,
515: p_loading_status => x_loading_status,
516: x_loading_status => l_loading_status
517: )
518: ) = fnd_api.g_true

Line 523: p_obj_name => cn_chk_plan_element_pkg.g_incentive_type_code,

519: )
520: THEN
521: RAISE fnd_api.g_exc_error;
522: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.incentive_type_code,
523: p_obj_name => cn_chk_plan_element_pkg.g_incentive_type_code,
524: p_loading_status => x_loading_status,
525: x_loading_status => l_loading_status
526: )
527: ) = fnd_api.g_true

Line 534: IF ((cn_chk_plan_element_pkg.chk_miss_date_para (p_date_para => p_pe_rec.start_date,

530: RAISE fnd_api.g_exc_error;
531: END IF;
532:
533: -- Check Start Date can not be missing or NULL
534: IF ((cn_chk_plan_element_pkg.chk_miss_date_para (p_date_para => p_pe_rec.start_date,
535: p_para_name => cn_chk_plan_element_pkg.g_start_date,
536: p_loading_status => x_loading_status,
537: x_loading_status => l_loading_status
538: )

Line 535: p_para_name => cn_chk_plan_element_pkg.g_start_date,

531: END IF;
532:
533: -- Check Start Date can not be missing or NULL
534: IF ((cn_chk_plan_element_pkg.chk_miss_date_para (p_date_para => p_pe_rec.start_date,
535: p_para_name => cn_chk_plan_element_pkg.g_start_date,
536: p_loading_status => x_loading_status,
537: x_loading_status => l_loading_status
538: )
539: ) = fnd_api.g_true

Line 543: ELSIF ((cn_chk_plan_element_pkg.chk_null_date_para (p_date_para => p_pe_rec.start_date,

539: ) = fnd_api.g_true
540: )
541: THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF ((cn_chk_plan_element_pkg.chk_null_date_para (p_date_para => p_pe_rec.start_date,
544: p_obj_name => cn_chk_plan_element_pkg.g_start_date,
545: p_loading_status => x_loading_status,
546: x_loading_status => l_loading_status
547: )

Line 544: p_obj_name => cn_chk_plan_element_pkg.g_start_date,

540: )
541: THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF ((cn_chk_plan_element_pkg.chk_null_date_para (p_date_para => p_pe_rec.start_date,
544: p_obj_name => cn_chk_plan_element_pkg.g_start_date,
545: p_loading_status => x_loading_status,
546: x_loading_status => l_loading_status
547: )
548: ) = fnd_api.g_true

Line 556: p_para_name => cn_chk_plan_element_pkg.g_interval_name,

552: END IF;
553:
554: -- Check interval name can not be missing or NULL
555: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.interval_name,
556: p_para_name => cn_chk_plan_element_pkg.g_interval_name,
557: p_loading_status => x_loading_status,
558: x_loading_status => l_loading_status
559: )
560: ) = fnd_api.g_true

Line 565: p_obj_name => cn_chk_plan_element_pkg.g_interval_name,

561: )
562: THEN
563: RAISE fnd_api.g_exc_error;
564: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.interval_name,
565: p_obj_name => cn_chk_plan_element_pkg.g_interval_name,
566: p_loading_status => x_loading_status,
567: x_loading_status => l_loading_status
568: )
569: ) = fnd_api.g_true

Line 602: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,

598: -- the same as those exists in the database
599: -- -------------------------------------------------------------------------+-+
600: PROCEDURE chk_pe_consistent (
601: x_return_status OUT NOCOPY VARCHAR2,
602: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,
603: p_loading_status IN VARCHAR2,
604: x_loading_status OUT NOCOPY VARCHAR2
605: )
606: IS

Line 642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);

638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
639: THEN
640: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
641: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);
643: fnd_msg_pub.ADD;
644: END IF;
645:
646: x_loading_status := 'CN_PLN_NOT_CONSISTENT';

Line 659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);

655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
658: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
660: fnd_msg_pub.ADD;
661: END IF;
662:
663: x_loading_status := 'CN_PLN_NOT_CONSISTENT';

Line 676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);

672: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
673: THEN
674: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
675: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);
677: fnd_msg_pub.ADD;
678: END IF;
679:
680: x_loading_status := 'CN_PLN_NOT_CONSISTENT';

Line 787: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,

783: --| correct setting for different plan element type
784: -- -------------------------------------------------------------------------+-+
785: PROCEDURE valid_lookup_code (
786: x_return_status OUT NOCOPY VARCHAR2,
787: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,
788: p_loading_status IN VARCHAR2,
789: x_loading_status OUT NOCOPY VARCHAR2
790: )
791: IS

Line 810: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);

806: THEN
807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
808: THEN
809: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
810: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
811: fnd_msg_pub.ADD;
812: END IF;
813:
814: x_loading_status := 'CN_INVALID_DATA';

Line 829: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);

825: THEN
826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
827: THEN
828: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
829: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
830: fnd_msg_pub.ADD;
831: END IF;
832:
833: x_loading_status := 'CN_INVALID_DATA';

Line 873: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,

869: p_validation_level IN NUMBER,
870: x_return_status OUT NOCOPY VARCHAR2,
871: x_msg_count OUT NOCOPY NUMBER,
872: x_msg_data OUT NOCOPY VARCHAR2,
873: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,
874: p_pe_rec_old IN cn_chk_plan_element_pkg.pe_rec_type,
875: p_rt_quota_asgns_rec_tbl IN rt_quota_asgns_rec_tbl_type := g_miss_rt_quota_asgns_rec_tbl,
876: p_quota_name IN VARCHAR2,
877: p_loading_status IN VARCHAR2,

Line 874: p_pe_rec_old IN cn_chk_plan_element_pkg.pe_rec_type,

870: x_return_status OUT NOCOPY VARCHAR2,
871: x_msg_count OUT NOCOPY NUMBER,
872: x_msg_data OUT NOCOPY VARCHAR2,
873: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,
874: p_pe_rec_old IN cn_chk_plan_element_pkg.pe_rec_type,
875: p_rt_quota_asgns_rec_tbl IN rt_quota_asgns_rec_tbl_type := g_miss_rt_quota_asgns_rec_tbl,
876: p_quota_name IN VARCHAR2,
877: p_loading_status IN VARCHAR2,
878: x_loading_status OUT NOCOPY VARCHAR2

Line 907: /*cn_chk_plan_element_pkg.chk_formula_rate_date

903: THEN
904: -- check all the formula rate start date fall under the quota date
905: -- clku, we do not check the date range of the formula rates against the PE date range anymore,
906: -- bug 1949943
907: /*cn_chk_plan_element_pkg.chk_formula_rate_date
908: (
909: x_return_status => x_return_status,
910: p_start_date => p_pe_rec.start_date,
911: p_end_date => p_pe_rec.end_date,

Line 926: /*cn_chk_plan_element_pkg.chk_formula_rate_date

922: THEN
923: -- check all the formula rate start date fall under the quota date
924: -- clku, we do not check the date range of the formula rates against the PE date range anymore,
925: -- bug 1949943
926: /*cn_chk_plan_element_pkg.chk_formula_rate_date
927: (
928: x_return_status => x_return_status,
929: p_start_date => p_pe_rec.start_date,
930: p_end_date => p_pe_rec.end_date,

Line 1020: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,

1016: p_validation_level IN NUMBER,
1017: x_return_status OUT NOCOPY VARCHAR2,
1018: x_msg_count OUT NOCOPY NUMBER,
1019: x_msg_data OUT NOCOPY VARCHAR2,
1020: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,
1021: p_rt_quota_asgns_rec_tbl IN rt_quota_asgns_rec_tbl_type := g_miss_rt_quota_asgns_rec_tbl,
1022: p_quota_name IN VARCHAR2,
1023: p_loading_status IN VARCHAR2,
1024: x_loading_status OUT NOCOPY VARCHAR2

Line 1051: /*cn_chk_plan_element_pkg.chk_formula_rate_date

1047: THEN
1048: -- check all the formula rate start date fall under the quota date
1049: -- clku, we do not check the date range of the formula rates against the PE date range anymore,
1050: -- bug 1949943
1051: /*cn_chk_plan_element_pkg.chk_formula_rate_date
1052: (
1053: x_return_status => x_return_status,
1054: p_start_date => p_pe_rec.start_date,
1055: p_end_date => p_pe_rec.end_date,

Line 1141: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,

1137: p_validation_level IN NUMBER,
1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,
1142: p_pe_rec_old IN cn_chk_plan_element_pkg.pe_rec_type,
1143: p_period_quotas_rec_tbl IN period_quotas_rec_tbl_type := g_miss_period_quotas_rec_tbl,
1144: p_quota_name IN VARCHAR2,
1145: p_loading_status IN VARCHAR2,

Line 1142: p_pe_rec_old IN cn_chk_plan_element_pkg.pe_rec_type,

1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,
1142: p_pe_rec_old IN cn_chk_plan_element_pkg.pe_rec_type,
1143: p_period_quotas_rec_tbl IN period_quotas_rec_tbl_type := g_miss_period_quotas_rec_tbl,
1144: p_quota_name IN VARCHAR2,
1145: p_loading_status IN VARCHAR2,
1146: x_loading_status OUT NOCOPY VARCHAR2

Line 1255: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,

1251: p_validation_level IN NUMBER,
1252: x_return_status OUT NOCOPY VARCHAR2,
1253: x_msg_count OUT NOCOPY NUMBER,
1254: x_msg_data OUT NOCOPY VARCHAR2,
1255: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type,
1256: p_period_quotas_rec_tbl IN period_quotas_rec_tbl_type := g_miss_period_quotas_rec_tbl,
1257: p_quota_name IN VARCHAR2,
1258: p_loading_status IN VARCHAR2,
1259: x_loading_status OUT NOCOPY VARCHAR2,

Line 1431: l_quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => p_quota_id, p_rev_class_id => l_rev_class_id);

1427: RAISE fnd_api.g_exc_error;
1428: END IF;
1429:
1430: -- get the quota rule id using the quota id and revenue class id
1431: l_quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => p_quota_id, p_rev_class_id => l_rev_class_id);
1432:
1433: -- Quota rule_id is null raise an error
1434: IF l_quota_rule_id IS NULL
1435: THEN

Line 1478: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,

1474: -- validate Rule :
1475: -- Check TRX_FACTORS
1476: -- 1. Key Factor's total = 100
1477: -- 2. Must have Trx_Factors
1478: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,
1479: p_quota_rule_id => l_quota_rule_id,
1480: p_rev_class_name => l_trx_factor_rec_tbl (OUTER).rev_class_name,
1481: p_loading_status => x_loading_status,
1482: x_loading_status => l_loading_status

Line 1547: p_para_name => cn_chk_plan_element_pkg.g_pe_name,

1543: -- Get the Old record quota id and Formula id to update and
1544: -- delete the rate Quota assigns, in the table handler
1545: -- Check if old plan element name is missing or null
1546: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name_old,
1547: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
1548: p_loading_status => x_loading_status,
1549: x_loading_status => l_loading_status
1550: )
1551: ) = fnd_api.g_true

Line 1556: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,

1552: )
1553: THEN
1554: RAISE fnd_api.g_exc_error;
1555: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name_old,
1556: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
1557: p_loading_status => x_loading_status,
1558: x_loading_status => l_loading_status
1559: )
1560: ) = fnd_api.g_true

Line 1627: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,

1623: PROCEDURE valid_plan_element (
1624: x_return_status OUT NOCOPY VARCHAR2,
1625: x_msg_count OUT NOCOPY NUMBER,
1626: x_msg_data OUT NOCOPY VARCHAR2,
1627: p_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,
1628: p_quota_name_old IN VARCHAR2,
1629: p_loading_status IN VARCHAR2,
1630: x_loading_status OUT NOCOPY VARCHAR2
1631: )

Line 1722: cn_chk_plan_element_pkg.chk_formula_quota_pe (x_return_status => x_return_status,

1718: IF (p_pe_rec.quota_type_code = 'FORMULA')
1719: THEN
1720: -- if Quota type is Formula, then Formula is Mandatory and
1721: -- Package name must be null
1722: cn_chk_plan_element_pkg.chk_formula_quota_pe (x_return_status => x_return_status,
1723: p_pe_rec => p_pe_rec,
1724: p_loading_status => x_loading_status,
1725: x_loading_status => l_loading_status
1726: );

Line 1738: cn_chk_plan_element_pkg.chk_external_quota_pe (x_return_status => x_return_status,

1734: ELSIF (p_pe_rec.quota_type_code = 'EXTERNAL')
1735: THEN
1736: -- if Quota type is External Package name is Mandatory and
1737: -- formula must be null
1738: cn_chk_plan_element_pkg.chk_external_quota_pe (x_return_status => x_return_status,
1739: p_pe_rec => p_pe_rec,
1740: p_loading_status => x_loading_status,
1741: x_loading_status => l_loading_status
1742: );

Line 1753: cn_chk_plan_element_pkg.chk_other_quota_pe (x_return_status => x_return_status,

1749: END IF;
1750: ELSIF (p_pe_rec.quota_type_code = 'NONE')
1751: THEN
1752: -- If quota type is NONE, both Formula and package must be null
1753: cn_chk_plan_element_pkg.chk_other_quota_pe (x_return_status => x_return_status,
1754: p_pe_rec => p_pe_rec,
1755: p_loading_status => x_loading_status,
1756: x_loading_status => l_loading_status
1757: );

Line 1810: p_new_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,

1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2,
1809: p_quota_name_old IN VARCHAR2,
1810: p_new_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,
1811: x_old_pe_rec OUT NOCOPY cn_chk_plan_element_pkg.pe_rec_type,
1812: p_loading_status IN VARCHAR2,
1813: x_loading_status OUT NOCOPY VARCHAR2
1814: )

Line 1811: x_old_pe_rec OUT NOCOPY cn_chk_plan_element_pkg.pe_rec_type,

1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2,
1809: p_quota_name_old IN VARCHAR2,
1810: p_new_pe_rec IN cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec,
1811: x_old_pe_rec OUT NOCOPY cn_chk_plan_element_pkg.pe_rec_type,
1812: p_loading_status IN VARCHAR2,
1813: x_loading_status OUT NOCOPY VARCHAR2
1814: )
1815: IS

Line 1826: cn_chk_plan_element_pkg.get_calc_formula_name (q.calc_formula_id),

1822: )
1823: IS
1824: SELECT q.quota_id,
1825: q.calc_formula_id,
1826: cn_chk_plan_element_pkg.get_calc_formula_name (q.calc_formula_id),
1827: -- clku, 5/9/2002
1828: q.quota_type_code,
1829: q.start_date,
1830: q.end_date

Line 1898: cn_chk_plan_element_pkg.chk_comp_plan_date (x_return_status => x_return_status,

1894: -- Assiged quota to comp plan check if the start date and the end date changes.
1895: IF TRUNC (p_new_pe_rec.start_date) <> TRUNC (x_old_pe_rec.start_date)
1896: OR TRUNC (NVL (p_new_pe_rec.end_date, fnd_api.g_miss_date)) <> TRUNC (NVL (x_old_pe_rec.end_date, fnd_api.g_miss_date))
1897: THEN
1898: cn_chk_plan_element_pkg.chk_comp_plan_date (x_return_status => x_return_status,
1899: p_start_date => p_new_pe_rec.start_date,
1900: p_end_date => p_new_pe_rec.end_date,
1901: p_quota_id => x_old_pe_rec.quota_id,
1902: p_quota_name => p_quota_name_old,

Line 1918: cn_chk_plan_element_pkg.chk_rate_quota_date (x_return_status => x_return_status,

1914: IF p_new_pe_rec.calc_formula_id IS NOT NULL
1915: THEN
1916: IF p_new_pe_rec.calc_formula_id = x_old_pe_rec.calc_formula_id
1917: THEN
1918: cn_chk_plan_element_pkg.chk_rate_quota_date (x_return_status => x_return_status,
1919: p_start_date => p_new_pe_rec.start_date,
1920: p_end_date => p_new_pe_rec.end_date,
1921: p_quota_name => p_new_pe_rec.NAME,
1922: p_quota_id => p_new_pe_rec.quota_id,

Line 1940: cn_chk_plan_element_pkg.chk_uplift_date (x_return_status => x_return_status,

1936: -- Check the Plan Element start date and end date fall with in the uplift start date
1937: -- and end date
1938: IF p_new_pe_rec.quota_id IS NOT NULL
1939: THEN
1940: cn_chk_plan_element_pkg.chk_uplift_date (x_return_status => x_return_status,
1941: p_start_date => p_new_pe_rec.start_date,
1942: p_end_date => p_new_pe_rec.end_date,
1943: p_quota_name => p_new_pe_rec.NAME,
1944: p_quota_id => p_new_pe_rec.quota_id,

Line 2026: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;

2022: )
2023: IS
2024: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element';
2025: l_api_version CONSTANT NUMBER := 1.0;
2026: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
2027: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2028: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2029: l_per_quota_id cn_period_quotas.period_quota_id%TYPE;
2030: l_tmp NUMBER;

Line 2770: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;

2766: )
2767: IS
2768: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Plan_Element';
2769: l_api_version CONSTANT NUMBER := 1.0;
2770: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
2771: l_pe_rec_old cn_chk_plan_element_pkg.pe_rec_type;
2772: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2773: l_quota_rule_id NUMBER;
2774: l_quota_id NUMBER;

Line 2771: l_pe_rec_old cn_chk_plan_element_pkg.pe_rec_type;

2767: IS
2768: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Plan_Element';
2769: l_api_version CONSTANT NUMBER := 1.0;
2770: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
2771: l_pe_rec_old cn_chk_plan_element_pkg.pe_rec_type;
2772: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2773: l_quota_rule_id NUMBER;
2774: l_quota_id NUMBER;
2775: l_rev_class_id NUMBER;

Line 3258: cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => NVL (l_pe_rec.quota_id, l_pe_rec_old.quota_id),

3254: -- Get revenue Class ID
3255: l_rev_class_id := cn_api.get_rev_class_id (RTRIM (LTRIM (l_trx_factor_rec_tbl (i).rev_class_name)),l_trx_factor_rec_tbl (i).org_id);
3256: -- Get Quota Rule ID, you need it to update the Trx Factors
3257: l_quota_rule_id :=
3258: cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => NVL (l_pe_rec.quota_id, l_pe_rec_old.quota_id),
3259: p_rev_class_id => l_rev_class_id
3260: );
3261:
3262: -- Loop through each record and update the mached one only

Line 3282: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,

3278: -- validate Rule :
3279: -- Check TRX_FACTORS
3280: -- 1. Key Factor's total = 100
3281: -- 2. Must have Trx_Factors
3282: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,
3283: p_quota_rule_id => l_quota_rule_id,
3284: p_rev_class_name => l_trx_factor_rec_tbl (i).rev_class_name,
3285: p_loading_status => x_loading_status,
3286: x_loading_status => l_loading_status

Line 3636: p_para_name => cn_chk_plan_element_pkg.g_pe_name,

3632:
3633: /* Resolve the quota_id and quota_name from */
3634: /* 1. If checks if quota_name passed is g_miss_char */
3635: IF ((cn_api.chk_miss_char_para (p_char_para => l_p_quota_name,
3636: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
3637: p_loading_status => x_loading_status,
3638: x_loading_status => l_loading_status
3639: )
3640: ) = fnd_api.g_true

Line 3648: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,

3644: END IF;
3645:
3646: /* 2. if it is null character */
3647: IF ((cn_api.chk_null_char_para (p_char_para => l_p_quota_name,
3648: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
3649: p_loading_status => x_loading_status,
3650: x_loading_status => l_loading_status
3651: )
3652: ) = fnd_api.g_true

Line 3672: l_quota_id := cn_chk_plan_element_pkg.get_quota_id (LTRIM (RTRIM (l_p_quota_name)), l_org_id);

3668: check_org_id (l_org_id);
3669: -- Set the Plan Element Record Type to have the org_id
3670: p_quota_rec.org_id := l_org_id;
3671: /* 4. Get the Quota ID */
3672: l_quota_id := cn_chk_plan_element_pkg.get_quota_id (LTRIM (RTRIM (l_p_quota_name)), l_org_id);
3673:
3674: -- check the Quota id if the Quota ID is Null and the Quota name is Not null
3675: -- Raise an Error
3676: IF l_quota_id IS NULL AND l_p_quota_name IS NOT NULL

Line 4314: cn_chk_plan_element_pkg.get_calc_formula_name (calc_formula_id) calc_formula_name,

4310: pe_id cn_quotas.quota_id%TYPE
4311: )
4312: IS
4313: SELECT cn_api.get_rate_table_name (rate_schedule_id) rate_schedule_name,
4314: cn_chk_plan_element_pkg.get_calc_formula_name (calc_formula_id) calc_formula_name,
4315: start_date,
4316: end_date,
4317: attribute_category,
4318: attribute1,

Line 4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;

4635: l_api_version CONSTANT NUMBER := 1.0;
4636: l_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
4637: l_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
4638: l_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
4639: l_pe_rec_tbl cn_chk_plan_element_pkg.pe_rec_tbl_type;
4640: l_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
4641: l_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
4642: l_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
4643: l_length INTEGER := 30 - LENGTHB ('_2');

Line 4810: IF cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name,p_org_id) IS NOT NULL

4806:
4807: l_plan_element_rec.NAME := l_x_plan_element_name;
4808:
4809: -- Check The Created Plan Element Already Exists in Database
4810: IF cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name,p_org_id) IS NOT NULL
4811: THEN
4812: -- IF Plan Element Exists Raise an Error
4813: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4814: THEN

Line 4906: x_plan_element_name := cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name, p_org_id);

4902: END IF;
4903: END IF;
4904:
4905: -- x_plan_element_name := l_x_plan_element_name;
4906: x_plan_element_name := cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name, p_org_id);
4907:
4908: /* Following code is for message generation */
4909: IF jtf_usr_hks.ok_to_execute ('CN_PLAN_ELEMENT_PUB', 'DUPLICATE_PLAN_ELEMENT', 'M', 'M')
4910: THEN