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_IMP_RULE_PVT dependencies on CN_RULES_IMP_V

Line 64: FROM CN_RULES_IMP_V

60:
61: -- Cursor to get start date, end_date, ruleset type for the specified ruleset name
62: CURSOR c_ruleset_details_csr IS
63: SELECT ruleset_name, start_date, end_date, ruleset_type
64: FROM CN_RULES_IMP_V
65: WHERE imp_header_id = p_imp_header_id
66: AND status_code = l_stage_status
67: GROUP BY ruleset_name, start_date, end_date, ruleset_type
68: ORDER BY start_date;

Line 371: -- This procedure will set error in cn_imp_lines(cn_rules_imp_v)

367:
368: -- --------------------------------------------------------+
369: -- seterr_imp_rules
370: --
371: -- This procedure will set error in cn_imp_lines(cn_rules_imp_v)
372: -- with passed in status and error code
373: -- --------------------------------------------------------+
374: PROCEDURE seterr_imp_rules
375: (p_status IN VARCHAR2,

Line 393: UPDATE cn_rules_imp_v

389: x_failed_row IN OUT NOCOPY NUMBER,
390: x_processed_row IN OUT NOCOPY NUMBER)
391: IS PRAGMA AUTONOMOUS_TRANSACTION;
392: BEGIN
393: UPDATE cn_rules_imp_v
394: SET status_code=p_status, error_code=p_error_code, error_msg=p_error_mssg
395: WHERE nvl(ruleset_name,FND_API.g_miss_char) = nvl(p_ruleset_name ,FND_API.g_miss_char)
396: AND nvl(start_date ,FND_API.g_miss_char) = nvl(p_ruleset_start_date, FND_API.g_miss_char)
397: AND nvl(end_date,FND_API.g_miss_char) = nvl(p_ruleset_end_date, FND_API.g_miss_char)

Line 477: FROM CN_RULES_IMP_V

473:
474: -- cursor to get the number of entries that have no rule name
475: CURSOR c_null_rule_name_csr IS
476: SELECT count(*)
477: FROM CN_RULES_IMP_V
478: WHERE imp_header_id = p_imp_header.imp_header_id
479: AND status_code = l_stage_status
480: AND ruleset_name = p_ruleset_name
481: AND start_date = p_ruleset_start_date

Line 488: FROM CN_RULES_IMP_V

484: AND rule_name IS NULL;
485:
486: CURSOR c_null_level_num_csr IS
487: SELECT count(*)
488: FROM CN_RULES_IMP_V
489: WHERE imp_header_id = p_imp_header.imp_header_id
490: AND status_code = l_stage_status
491: AND ruleset_name = p_ruleset_name
492: AND start_date = p_ruleset_start_date

Line 500: FROM CN_RULES_IMP_V

496:
497: -- Cursor to get rules of the ruleset
498: CURSOR c_rule_name_csr IS
499: SELECT distinct(rule_name) rule_name, parent_rule_name, level_num
500: FROM CN_RULES_IMP_V
501: WHERE imp_header_id = p_imp_header.imp_header_id
502: AND status_code = l_stage_status
503: AND ruleset_name = p_ruleset_name
504: AND start_date = p_ruleset_start_date

Line 512: CURSOR c_rules_dtl_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS

508: ORDER BY level_num;
509:
510: -- Cursor to check unique of revenue_class_name, expense_code,
511: -- liability_code
512: CURSOR c_rules_dtl_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
513: SELECT COUNT(1) FROM
514: (SELECT revenue_class_name, expense_code, liability_code
515: FROM CN_RULES_IMP_V
516: WHERE imp_header_id = p_imp_header.imp_header_id

Line 515: FROM CN_RULES_IMP_V

511: -- liability_code
512: CURSOR c_rules_dtl_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
513: SELECT COUNT(1) FROM
514: (SELECT revenue_class_name, expense_code, liability_code
515: FROM CN_RULES_IMP_V
516: WHERE imp_header_id = p_imp_header.imp_header_id
517: AND status_code = l_stage_status
518: AND ruleset_name = p_ruleset_name
519: AND start_date = p_ruleset_start_date

Line 528: CURSOR c_rules_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS

524: AND nvl(parent_rule_name,FND_API.g_miss_char) = nvl(l_parent_rule_name,FND_API.g_miss_char)
525: GROUP BY revenue_class_name, expense_code, liability_code) v1;
526:
527: -- Cursor to get rules details of the ruleset
528: CURSOR c_rules_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
529: SELECT revenue_class_name, expense_code, liability_code
530: FROM CN_RULES_IMP_V
531: WHERE imp_header_id = p_imp_header.imp_header_id
532: AND status_code = l_stage_status

Line 530: FROM CN_RULES_IMP_V

526:
527: -- Cursor to get rules details of the ruleset
528: CURSOR c_rules_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
529: SELECT revenue_class_name, expense_code, liability_code
530: FROM CN_RULES_IMP_V
531: WHERE imp_header_id = p_imp_header.imp_header_id
532: AND status_code = l_stage_status
533: AND ruleset_name = p_ruleset_name
534: AND start_date = p_ruleset_start_date

Line 1011: FROM CN_RULES_IMP_V

1007: -- cursor to get attribute details, given ruleset name, rule name and parent rule name
1008: -- IMP parent rule name is required because we can have 2 rules with the same name but at different levels
1009: CURSOR c_rule_attrb_csr IS
1010: SELECT imp_line_id, record_num, rule_attribute, rule_value, not_flag, rule_hierarchy, rule_low_value, rule_high_value
1011: FROM CN_RULES_IMP_V
1012: WHERE imp_header_id = p_imp_header.imp_header_id
1013: AND status_code = l_stage_status
1014: AND ruleset_name = p_ruleset_name
1015: AND start_date = p_ruleset_start_date

Line 1254: FROM cn_rules_imp_v

1250: x_processed_row IN OUT NOCOPY NUMBER) IS
1251:
1252: CURSOR c_check_imp_line_id_csr IS
1253: SELECT count(*)
1254: FROM cn_rules_imp_v
1255: WHERE nvl(ruleset_name,FND_API.g_miss_char) = nvl(p_ruleset_name ,FND_API.g_miss_char)
1256: AND nvl(start_date ,FND_API.g_miss_char) = nvl(p_start_date, FND_API.g_miss_char)
1257: AND nvl(end_date,FND_API.g_miss_char) = nvl(p_end_date, FND_API.g_miss_char)
1258: AND nvl(ruleset_type,FND_API.g_miss_char) = nvl(p_ruleset_type, FND_API.g_miss_char)

Line 1267: cn_message_pkg.debug('Updating cn_rules_imp_v with status:' || p_status);

1263: l_temp NUMBER := 0;
1264:
1265: PRAGMA AUTONOMOUS_TRANSACTION;
1266: BEGIN
1267: cn_message_pkg.debug('Updating cn_rules_imp_v with status:' || p_status);
1268: cn_message_pkg.debug('p_ruleset_name:' || p_ruleset_name);
1269: cn_message_pkg.debug('p_start_date:' || p_start_date);
1270: cn_message_pkg.debug('p_end_date:' || p_end_date);
1271: cn_message_pkg.debug('p_ruleset_type:' || p_ruleset_type);

Line 1288: UPDATE cn_rules_imp_v

1284: END IF;
1285:
1286: cn_message_pkg.debug('l_temp:' || l_temp);
1287:
1288: UPDATE cn_rules_imp_v
1289: SET status_code=p_status, error_code=p_error_code, error_msg=p_error_mssg
1290: WHERE nvl(ruleset_name,FND_API.g_miss_char) = nvl(p_ruleset_name ,FND_API.g_miss_char)
1291: AND nvl(start_date ,FND_API.g_miss_char) = nvl(p_start_date, FND_API.g_miss_char)
1292: AND nvl(end_date,FND_API.g_miss_char) = nvl(p_end_date, FND_API.g_miss_char)