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_SYIN_RULES_PKG dependencies on CN_CLRL_API

Line 433: ruleset_name cn_clrl_api_v.ruleset_name%TYPE,

429: retcode OUT NOCOPY NUMBER) IS
430:
431: TYPE cnclrl_api_type IS RECORD
432: (clrl_api_id NUMBER,
433: ruleset_name cn_clrl_api_v.ruleset_name%TYPE,
434: start_date cn_clrl_api_v.start_date%TYPE,
435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,

Line 434: start_date cn_clrl_api_v.start_date%TYPE,

430:
431: TYPE cnclrl_api_type IS RECORD
432: (clrl_api_id NUMBER,
433: ruleset_name cn_clrl_api_v.ruleset_name%TYPE,
434: start_date cn_clrl_api_v.start_date%TYPE,
435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,

Line 435: end_date cn_clrl_api_v.end_date%TYPE,

431: TYPE cnclrl_api_type IS RECORD
432: (clrl_api_id NUMBER,
433: ruleset_name cn_clrl_api_v.ruleset_name%TYPE,
434: start_date cn_clrl_api_v.start_date%TYPE,
435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,

Line 436: rule_name cn_clrl_api_v.rule_name%TYPE,

432: (clrl_api_id NUMBER,
433: ruleset_name cn_clrl_api_v.ruleset_name%TYPE,
434: start_date cn_clrl_api_v.start_date%TYPE,
435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,

Line 437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,

433: ruleset_name cn_clrl_api_v.ruleset_name%TYPE,
434: start_date cn_clrl_api_v.start_date%TYPE,
435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,

Line 438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,

434: start_date cn_clrl_api_v.start_date%TYPE,
435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,
442: value_2 cn_clrl_api_v.value_2%TYPE,

Line 439: object_name cn_clrl_api_v.object_name%TYPE,

435: end_date cn_clrl_api_v.end_date%TYPE,
436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,
442: value_2 cn_clrl_api_v.value_2%TYPE,
443: data_flag cn_clrl_api_v.data_flag%TYPE

Line 440: not_flag cn_clrl_api_v.not_flag%TYPE,

436: rule_name cn_clrl_api_v.rule_name%TYPE,
437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,
442: value_2 cn_clrl_api_v.value_2%TYPE,
443: data_flag cn_clrl_api_v.data_flag%TYPE
444: );

Line 441: value_1 cn_clrl_api_v.value_1%TYPE,

437: parent_rule_name cn_clrl_api_v.parent_rule_name%TYPE,
438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,
442: value_2 cn_clrl_api_v.value_2%TYPE,
443: data_flag cn_clrl_api_v.data_flag%TYPE
444: );
445:

Line 442: value_2 cn_clrl_api_v.value_2%TYPE,

438: revenue_class_name cn_clrl_api_v.revenue_class_name%TYPE,
439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,
442: value_2 cn_clrl_api_v.value_2%TYPE,
443: data_flag cn_clrl_api_v.data_flag%TYPE
444: );
445:
446: TYPE cnclrl_tbl_type IS TABLE OF cnclrl_api_type INDEX BY BINARY_INTEGER;

Line 443: data_flag cn_clrl_api_v.data_flag%TYPE

439: object_name cn_clrl_api_v.object_name%TYPE,
440: not_flag cn_clrl_api_v.not_flag%TYPE,
441: value_1 cn_clrl_api_v.value_1%TYPE,
442: value_2 cn_clrl_api_v.value_2%TYPE,
443: data_flag cn_clrl_api_v.data_flag%TYPE
444: );
445:
446: TYPE cnclrl_tbl_type IS TABLE OF cnclrl_api_type INDEX BY BINARY_INTEGER;
447: cnclrl_tbl cnclrl_tbl_type;

Line 451: FROM cn_clrl_api_v;

447: cnclrl_tbl cnclrl_tbl_type;
448:
449: CURSOR cnclrl_cur IS
450: SELECT *
451: FROM cn_clrl_api_v;
452:
453: l_proc_audit_id NUMBER;
454: j NUMBER;
455: l_api_id NUMBER;

Line 475: SELECT cn_clrl_api_s.NEXTVAL

471: j := 0;
472:
473: FOR i IN cnclrl_cur
474: LOOP
475: SELECT cn_clrl_api_s.NEXTVAL
476: INTO l_api_id
477: FROM dual;
478:
479: cnclrl_tbl(j).clrl_api_id := l_api_id;

Line 495: INSERT INTO cn_clrl_api

491: j := j + 1;
492: END LOOP;
493:
494: for i IN cnclrl_tbl.first .. cnclrl_tbl.last loop
495: INSERT INTO cn_clrl_api
496: (clrl_api_id,
497: ruleset_name,
498: start_date,
499: end_date,

Line 546: FROM cn_clrl_api

542: retcode OUT NOCOPY NUMBER) IS
543:
544: CURSOR rulesets
545: IS SELECT ruleset_name, start_date, end_date
546: FROM cn_clrl_api
547: WHERE loading_status <> 'CN_INSERTED' OR loading_status IS NULL
548: GROUP BY ruleset_name, start_date, end_date;
549:
550: CURSOR top_level_rules

Line 551: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,

547: WHERE loading_status <> 'CN_INSERTED' OR loading_status IS NULL
548: GROUP BY ruleset_name, start_date, end_date;
549:
550: CURSOR top_level_rules
551: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
552: p_start_date cn_clrl_api.start_date%TYPE,
553: p_end_date cn_clrl_api.end_date%TYPE)
554: IS SELECT rule_name
555: FROM cn_clrl_api cna1

Line 552: p_start_date cn_clrl_api.start_date%TYPE,

548: GROUP BY ruleset_name, start_date, end_date;
549:
550: CURSOR top_level_rules
551: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
552: p_start_date cn_clrl_api.start_date%TYPE,
553: p_end_date cn_clrl_api.end_date%TYPE)
554: IS SELECT rule_name
555: FROM cn_clrl_api cna1
556: WHERE ruleset_name = p_ruleset_name

Line 553: p_end_date cn_clrl_api.end_date%TYPE)

549:
550: CURSOR top_level_rules
551: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
552: p_start_date cn_clrl_api.start_date%TYPE,
553: p_end_date cn_clrl_api.end_date%TYPE)
554: IS SELECT rule_name
555: FROM cn_clrl_api cna1
556: WHERE ruleset_name = p_ruleset_name
557: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL)

Line 555: FROM cn_clrl_api cna1

551: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
552: p_start_date cn_clrl_api.start_date%TYPE,
553: p_end_date cn_clrl_api.end_date%TYPE)
554: IS SELECT rule_name
555: FROM cn_clrl_api cna1
556: WHERE ruleset_name = p_ruleset_name
557: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL)
558: AND parent_rule_name NOT IN
559: (SELECT rule_name

Line 560: FROM cn_clrl_api

556: WHERE ruleset_name = p_ruleset_name
557: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL)
558: AND parent_rule_name NOT IN
559: (SELECT rule_name
560: FROM cn_clrl_api
561: WHERE ruleset_name = p_ruleset_name
562: AND start_date = p_start_date
563: AND end_date = p_end_date
564: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL) );

Line 567: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,

563: AND end_date = p_end_date
564: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL) );
565:
566: CURSOR rules
567: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
568: p_start_date cn_clrl_api.start_date%TYPE,
569: p_end_date cn_clrl_api.end_date%TYPE,
570: p_start_rule_name cn_clrl_api.rule_name%TYPE)IS
571: SELECT rule_name, parent_rule_name, revenue_class_name

Line 568: p_start_date cn_clrl_api.start_date%TYPE,

564: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL) );
565:
566: CURSOR rules
567: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
568: p_start_date cn_clrl_api.start_date%TYPE,
569: p_end_date cn_clrl_api.end_date%TYPE,
570: p_start_rule_name cn_clrl_api.rule_name%TYPE)IS
571: SELECT rule_name, parent_rule_name, revenue_class_name
572: FROM (SELECT rule_name, parent_rule_name, revenue_class_name

Line 569: p_end_date cn_clrl_api.end_date%TYPE,

565:
566: CURSOR rules
567: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
568: p_start_date cn_clrl_api.start_date%TYPE,
569: p_end_date cn_clrl_api.end_date%TYPE,
570: p_start_rule_name cn_clrl_api.rule_name%TYPE)IS
571: SELECT rule_name, parent_rule_name, revenue_class_name
572: FROM (SELECT rule_name, parent_rule_name, revenue_class_name
573: FROM cn_clrl_api

Line 570: p_start_rule_name cn_clrl_api.rule_name%TYPE)IS

566: CURSOR rules
567: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
568: p_start_date cn_clrl_api.start_date%TYPE,
569: p_end_date cn_clrl_api.end_date%TYPE,
570: p_start_rule_name cn_clrl_api.rule_name%TYPE)IS
571: SELECT rule_name, parent_rule_name, revenue_class_name
572: FROM (SELECT rule_name, parent_rule_name, revenue_class_name
573: FROM cn_clrl_api
574: WHERE ruleset_name = p_ruleset_name

Line 573: FROM cn_clrl_api

569: p_end_date cn_clrl_api.end_date%TYPE,
570: p_start_rule_name cn_clrl_api.rule_name%TYPE)IS
571: SELECT rule_name, parent_rule_name, revenue_class_name
572: FROM (SELECT rule_name, parent_rule_name, revenue_class_name
573: FROM cn_clrl_api
574: WHERE ruleset_name = p_ruleset_name
575: AND start_date = p_start_date
576: AND end_date = p_end_date
577: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL)

Line 583: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,

579: CONNECT BY PRIOR rule_name = parent_rule_name
580: START WITH rule_name = p_start_rule_name;
581:
582: CURSOR rule_attributes
583: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
584: p_start_date cn_clrl_api.start_date%TYPE,
585: p_end_date cn_clrl_api.end_date%TYPE,
586: p_rule_name cn_clrl_api.rule_name%TYPE,
587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS

Line 584: p_start_date cn_clrl_api.start_date%TYPE,

580: START WITH rule_name = p_start_rule_name;
581:
582: CURSOR rule_attributes
583: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
584: p_start_date cn_clrl_api.start_date%TYPE,
585: p_end_date cn_clrl_api.end_date%TYPE,
586: p_rule_name cn_clrl_api.rule_name%TYPE,
587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS
588: SELECT attribute_rule_name, not_flag,

Line 585: p_end_date cn_clrl_api.end_date%TYPE,

581:
582: CURSOR rule_attributes
583: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
584: p_start_date cn_clrl_api.start_date%TYPE,
585: p_end_date cn_clrl_api.end_date%TYPE,
586: p_rule_name cn_clrl_api.rule_name%TYPE,
587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS
588: SELECT attribute_rule_name, not_flag,
589: value_1, value_2, data_flag, object_name

Line 586: p_rule_name cn_clrl_api.rule_name%TYPE,

582: CURSOR rule_attributes
583: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
584: p_start_date cn_clrl_api.start_date%TYPE,
585: p_end_date cn_clrl_api.end_date%TYPE,
586: p_rule_name cn_clrl_api.rule_name%TYPE,
587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS
588: SELECT attribute_rule_name, not_flag,
589: value_1, value_2, data_flag, object_name
590: FROM cn_clrl_api

Line 587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS

583: (p_ruleset_name cn_clrl_api.ruleset_name%TYPE,
584: p_start_date cn_clrl_api.start_date%TYPE,
585: p_end_date cn_clrl_api.end_date%TYPE,
586: p_rule_name cn_clrl_api.rule_name%TYPE,
587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS
588: SELECT attribute_rule_name, not_flag,
589: value_1, value_2, data_flag, object_name
590: FROM cn_clrl_api
591: WHERE loading_status <> 'CN_INSERTED' OR loading_status IS NULL

Line 590: FROM cn_clrl_api

586: p_rule_name cn_clrl_api.rule_name%TYPE,
587: p_parent_rule_name cn_clrl_api.parent_rule_name%TYPE) IS
588: SELECT attribute_rule_name, not_flag,
589: value_1, value_2, data_flag, object_name
590: FROM cn_clrl_api
591: WHERE loading_status <> 'CN_INSERTED' OR loading_status IS NULL
592: AND ruleset_name = p_ruleset_name
593: AND rule_name = p_rule_name
594: AND parent_rule_name = p_parent_rule_name;

Line 656: UPDATE cn_clrl_api

652:
653:
654: IF(l_return_status = FND_API.g_ret_sts_success) THEN
655:
656: UPDATE cn_clrl_api
657: SET loading_status = 'CN_RULESET_INSERTED'
658: WHERE ruleset_name = i.ruleset_name
659: AND start_date = i.start_date
660: AND end_date = i.end_date

Line 668: UPDATE cn_clrl_api

664: -- retcode 0 = success, 1 = warning, 2 = error
665: retcode := 2;
666: cn_message_pkg.debug('Error for rulesets '||i.ruleset_name);
667: cn_api.get_fnd_message(l_msg_count, l_msg_data);
668: UPDATE cn_clrl_api
669: SET loading_status = l_loading_status,
670: message_text = l_msg_data,
671: return_status = l_return_status
672: WHERE ruleset_name = i.ruleset_name

Line 679: UPDATE cn_clrl_api

675: AND (loading_status <> 'CN_INSERTED' OR loading_status IS NULL);
676:
677: END IF;
678: ELSE
679: UPDATE cn_clrl_api
680: SET loading_status = 'CN_ALREADY_EXISTS',
681: message_text = l_msg_data,
682: return_status = l_return_status
683: WHERE ruleset_name = i.ruleset_name

Line 717: UPDATE cn_clrl_api

713:
714:
715: IF(l_return_status = FND_API.g_ret_sts_success) THEN
716:
717: UPDATE cn_clrl_api
718: SET loading_status = 'CN_RULE_INSERTED'
719: WHERE ruleset_name = i.ruleset_name
720: AND start_date = i.start_date
721: AND end_date = i.end_date

Line 729: FROM cn_clrl_api

725:
726: ELSE
727: SELECT COUNT(1)
728: INTO l_count
729: FROM cn_clrl_api
730: WHERE ruleset_name = i.ruleset_name
731: AND start_date = i.start_date
732: AND end_date = i.end_date
733: AND rule_name = k.rule_name

Line 741: UPDATE cn_clrl_api

737:
738:
739: IF l_count <> 0 AND l_loading_status <> 'CN_INVALID_RULE_NAME'
740: THEN
741: UPDATE cn_clrl_api
742: SET loading_status = l_loading_status,
743: return_status = l_return_status,
744: message_text = l_msg_data
745: WHERE ruleset_name = i.ruleset_name

Line 797: UPDATE cn_clrl_api

793:
794:
795: IF(l_return_status = FND_API.g_ret_sts_success) THEN
796:
797: UPDATE cn_clrl_api
798: SET loading_status = 'CN_INSERTED'
799: WHERE ruleset_name = i.ruleset_name
800: AND start_date = i.start_date
801: AND end_date = i.end_date

Line 809: UPDATE cn_clrl_api

805: AND (loading_status <> 'CN_INSERTED'
806: OR loading_status IS NULL);
807:
808: ELSE
809: UPDATE cn_clrl_api
810: SET loading_status = l_loading_status,
811: return_status = l_return_status,
812: message_text = l_msg_data
813: WHERE ruleset_name = i.ruleset_name