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.IGC_CBC_FUNDS_CHECKER dependencies on IGC_CC_RESULT_CODE_RANKS

Line 569: FROM igc_cc_result_code_ranks

565: l_ranked_result_code VARCHAR2(3);
566: -- 1947176, Aug 21 2001
567: CURSOR c_get_msg IS
568: SELECT DISTINCT popup_messg_code
569: FROM igc_cc_result_code_ranks
570: WHERE action = DECODE(p_mode,'F','R',p_mode)
571: AND severity_rank = p_batch_result_code;
572:
573: l_full_path VARCHAR2(255);

Line 579: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS

575: l_full_path := g_path || 'Get_Batch_Result_Code';
576: IF (g_debug_mode = 'Y') THEN
577: Put_Debug_Msg(l_full_path, 'The most severe rank is: '||p_batch_result_code);
578: END IF;
579: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
580: -- 1947176, Aug 21 2001
581: OPEN c_get_msg;
582: FETCH c_get_msg INTO l_batch_result_code;
583: CLOSE c_get_msg;

Line 636: FROM igc_cc_result_code_ranks

632: l_batch_result_code NUMBER(4);
633: -- 1947176, Aug 21 2001
634: CURSOR c_get_rank IS
635: SELECT DISTINCT severity_rank
636: FROM igc_cc_result_code_ranks
637: WHERE funds_checker_code = p_code;
638:
639: l_full_path VARCHAR2(255);
640: BEGIN

Line 643: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS

639: l_full_path VARCHAR2(255);
640: BEGIN
641: l_full_path := g_path || 'Get_Rank';
642: --Selecting the Sevirity rank for result_code
643: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
644: -- 1947176, Aug 21 2001
645: OPEN c_get_rank;
646: FETCH c_get_rank INTO l_batch_result_code;
647: CLOSE c_get_rank;

Line 663: FROM igc_cc_result_code_ranks

659: l_status_code VARCHAR2(1);
660: -- 1947176, Aug 21 2001
661: CURSOR c_get_result IS
662: SELECT DISTINCT result_status_code
663: FROM igc_cc_result_code_ranks
664: WHERE funds_checker_code = p_result_code
665: AND action = DECODE(g_mode, 'F', 'R', g_mode);
666:
667: l_full_path VARCHAR2(255);

Line 673: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS

669: l_full_path := g_path || 'Get_Status_By_Result';
670: IF p_result_code IS NULL THEN
671: RETURN '';
672: ELSE
673: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
674: -- 1947176, Aug 21 2001
675: OPEN c_get_result;
676: FETCH c_get_result INTO l_status_code;
677: CLOSE c_get_result;

Line 694: FROM igc_cc_result_code_ranks

690: l_result_code VARCHAR2(3);
691: -- 1947176, Aug 21 2001
692: CURSOR c_get_result IS
693: SELECT DISTINCT funds_checker_code
694: FROM igc_cc_result_code_ranks
695: WHERE severity_rank = p_rank;
696:
697: l_full_path VARCHAR2(255);
698: BEGIN

Line 702: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS

698: BEGIN
699: l_full_path := g_path || 'Get_Result_By_Rank';
700: --Selecting the result_code, using the Sevirity rank
701: -- Selecting the ranked result code, using result_code
702: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
703: -- 1947176, Aug 21 2001
704: OPEN c_get_result;
705: FETCH c_get_result INTO l_result_code;
706: CLOSE c_get_result;

Line 1018: FROM igc_cc_result_code_ranks

1014: Put_Debug_Msg (l_full_path, 'Status Rank: ' || l_sev_rank);
1015: END IF;
1016:
1017: SELECT result_status_code INTO l_status_flag
1018: FROM igc_cc_result_code_ranks
1019: WHERE severity_rank = l_sev_rank
1020: AND action = decode(g_mode, 'F', 'R', g_mode);
1021:
1022: IF (p_budget_dest_flag = 'S') THEN

Line 1072: FROM igc_cc_result_code_ranks

1068:
1069: BEGIN
1070:
1071: SELECT min(severity_rank) INTO l_max_sev_rank
1072: FROM igc_cc_result_code_ranks
1073: WHERE funds_checker_code IN(SELECT distinct(result_code)
1074: FROM GL_BC_PACKETS
1075: WHERE event_id IN (SELECT event_id
1076: FROM

Line 1355: l_batch_result_code igc_cc_result_code_ranks.funds_checker_code%TYPE;

1351:
1352: FUNCTION Get_Max_Result_Code(x_sev_rank OUT NOCOPY NUMBER) RETURN VARCHAR2
1353: IS
1354:
1355: l_batch_result_code igc_cc_result_code_ranks.funds_checker_code%TYPE;
1356: l_err_code NUMBER;
1357: l_err_msg VARCHAR2(200);
1358: l_full_path VARCHAR2(255);
1359:

Line 1370: FROM igc_cc_result_code_ranks

1366: Put_Debug_Msg (l_full_path, 'CC Header ID: '|| g_cc_header_id );
1367: END IF;
1368:
1369: SELECT distinct funds_checker_code, severity_rank INTO l_batch_result_code, x_sev_rank
1370: FROM igc_cc_result_code_ranks
1371: WHERE severity_rank =
1372: (
1373: SELECT min(severity_rank)
1374: FROM igc_cc_result_code_ranks

Line 1374: FROM igc_cc_result_code_ranks

1370: FROM igc_cc_result_code_ranks
1371: WHERE severity_rank =
1372: (
1373: SELECT min(severity_rank)
1374: FROM igc_cc_result_code_ranks
1375: WHERE funds_checker_code IN
1376: (
1377: SELECT TRIM(cbc_result_code)
1378: FROM igc_cc_interface