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_V

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;