APPS.IGC_CBC_FUNDS_CHECKER dependencies on IGC_CC_RESULT_CODE_RANKS

Line 579: FROM igc_cc_result_code_ranks

575: l_ranked_result_code VARCHAR2(3);
576: -- 1947176, Aug 21 2001
577: CURSOR c_get_msg IS
578: SELECT DISTINCT popup_messg_code
579: FROM igc_cc_result_code_ranks
580: WHERE action = DECODE(p_mode,'F','R',p_mode)
581: AND severity_rank = p_batch_result_code;
582:
583: l_full_path VARCHAR2(255);

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

585: l_full_path := g_path || 'Get_Batch_Result_Code';
586: IF (g_debug_mode = 'Y') THEN
587: Put_Debug_Msg(l_full_path, 'The most severe rank is: '||p_batch_result_code);
588: END IF;
589: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
590: -- 1947176, Aug 21 2001
591: OPEN c_get_msg;
592: FETCH c_get_msg INTO l_batch_result_code;
593: CLOSE c_get_msg;

Line 646: FROM igc_cc_result_code_ranks

642: l_batch_result_code NUMBER(4);
643: -- 1947176, Aug 21 2001
644: CURSOR c_get_rank IS
645: SELECT DISTINCT severity_rank
646: FROM igc_cc_result_code_ranks
647: WHERE funds_checker_code = p_code;
648:
649: l_full_path VARCHAR2(255);
650: BEGIN

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

649: l_full_path VARCHAR2(255);
650: BEGIN
651: l_full_path := g_path || 'Get_Rank';
652: --Selecting the Sevirity rank for result_code
653: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
654: -- 1947176, Aug 21 2001
655: OPEN c_get_rank;
656: FETCH c_get_rank INTO l_batch_result_code;
657: CLOSE c_get_rank;

Line 673: FROM igc_cc_result_code_ranks

669: l_status_code VARCHAR2(1);
670: -- 1947176, Aug 21 2001
671: CURSOR c_get_result IS
672: SELECT DISTINCT result_status_code
673: FROM igc_cc_result_code_ranks
674: WHERE funds_checker_code = p_result_code
675: AND action = DECODE(g_mode, 'F', 'R', g_mode);
676:
677: l_full_path VARCHAR2(255);

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

679: l_full_path := g_path || 'Get_Status_By_Result';
680: IF p_result_code IS NULL THEN
681: RETURN '';
682: ELSE
683: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
684: -- 1947176, Aug 21 2001
685: OPEN c_get_result;
686: FETCH c_get_result INTO l_status_code;
687: CLOSE c_get_result;

Line 704: FROM igc_cc_result_code_ranks

700: l_result_code VARCHAR2(3);
701: -- 1947176, Aug 21 2001
702: CURSOR c_get_result IS
703: SELECT DISTINCT funds_checker_code
704: FROM igc_cc_result_code_ranks
705: WHERE severity_rank = p_rank;
706:
707: l_full_path VARCHAR2(255);
708: BEGIN

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

708: BEGIN
709: l_full_path := g_path || 'Get_Result_By_Rank';
710: --Selecting the result_code, using the Sevirity rank
711: -- Selecting the ranked result code, using result_code
712: -- The values now stored in table IGC_CC_RESULT_CODE_RANKS
713: -- 1947176, Aug 21 2001
714: OPEN c_get_result;
715: FETCH c_get_result INTO l_result_code;
716: CLOSE c_get_result;

Line 1028: FROM igc_cc_result_code_ranks

1024: Put_Debug_Msg (l_full_path, 'Status Rank: ' || l_sev_rank);
1025: END IF;
1026:
1027: SELECT result_status_code INTO l_status_flag
1028: FROM igc_cc_result_code_ranks
1029: WHERE severity_rank = l_sev_rank
1030: AND action = decode(g_mode, 'F', 'R', g_mode);
1031:
1032: IF (p_budget_dest_flag = 'S') THEN

Line 1082: FROM igc_cc_result_code_ranks

1078:
1079: BEGIN
1080:
1081: SELECT min(severity_rank) INTO l_max_sev_rank
1082: FROM igc_cc_result_code_ranks
1083: WHERE funds_checker_code IN(SELECT distinct(result_code)
1084: FROM GL_BC_PACKETS
1085: WHERE event_id IN (SELECT event_id
1086: FROM

Line 1372: l_batch_result_code igc_cc_result_code_ranks.funds_checker_code%TYPE;

1368:
1369: FUNCTION Get_Max_Result_Code(x_sev_rank OUT NOCOPY NUMBER) RETURN VARCHAR2
1370: IS
1371:
1372: l_batch_result_code igc_cc_result_code_ranks.funds_checker_code%TYPE;
1373: l_err_code NUMBER;
1374: l_err_msg VARCHAR2(200);
1375: l_full_path VARCHAR2(255);
1376:

Line 1387: FROM igc_cc_result_code_ranks

1383: Put_Debug_Msg (l_full_path, 'CC Header ID: '|| g_cc_header_id );
1384: END IF;
1385:
1386: SELECT distinct funds_checker_code, severity_rank INTO l_batch_result_code, x_sev_rank
1387: FROM igc_cc_result_code_ranks
1388: WHERE severity_rank =
1389: (
1390: SELECT min(severity_rank)
1391: FROM igc_cc_result_code_ranks

Line 1391: FROM igc_cc_result_code_ranks

1387: FROM igc_cc_result_code_ranks
1388: WHERE severity_rank =
1389: (
1390: SELECT min(severity_rank)
1391: FROM igc_cc_result_code_ranks
1392: WHERE funds_checker_code IN
1393: (
1394: SELECT TRIM(cbc_result_code)
1395: FROM igc_cc_interface