DBA Data[Home] [Help]

APPS.IGF_AP_SS_PKG dependencies on IGF_AP_BATCH_VER_PRC_PKG

Line 89: igf_ap_batch_ver_prc_pkg.lp_isir_rec := lv_isir;

85: OPEN c_isir(p_isir_id) ;
86: FETCH c_isir INTO lv_isir ;
87: IF c_isir%FOUND THEN
88: -- Initialize the package variable with the isir rec values
89: igf_ap_batch_ver_prc_pkg.lp_isir_rec := lv_isir;
90: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||lv_isir.isir_id);
92: END IF;
93:

Line 103: EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'

99: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);
101: END IF;
102:
103: EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'
104: || l_get_ver_data_rec.col_name || ' := ' || '''' || l_get_ver_data_rec.col_val || '''' || ' ; END;' ;
105: END LOOP;
106: CLOSE cur_get_ver_data ;
107:

Line 108: lv_isir := igf_ap_batch_ver_prc_pkg.lp_isir_rec;

104: || l_get_ver_data_rec.col_name || ' := ' || '''' || l_get_ver_data_rec.col_val || '''' || ' ; END;' ;
105: END LOOP;
106: CLOSE cur_get_ver_data ;
107:
108: lv_isir := igf_ap_batch_ver_prc_pkg.lp_isir_rec;
109:
110: -- Check if the student has an Internal ISIR
111:
112: OPEN chk_internal(lv_isir.base_id);

Line 1466: --igf_ap_batch_ver_prc_pkg.lp_isir_rec := isir_rec;

1462: CLOSE cur_isir_rec ;
1463:
1464: -- Bug 4752938: Moved the follwing commented code to set_internal_isir procedure
1465: -- Initialize the package variable with the isir rec values
1466: --igf_ap_batch_ver_prc_pkg.lp_isir_rec := isir_rec;
1467: --IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||isir_rec.isir_id);
1469: --END IF;
1470:

Line 1480: -- EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'

1476: -- IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1477: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);
1478: -- END IF;
1479:
1480: -- EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'
1481: -- || l_get_ver_data_rec.col_name || ' := ' || '''' || l_get_ver_data_rec.col_val || '''' || ' ; END;' ;
1482: --END LOOP;
1483: --CLOSE cur_get_ver_data ;
1484:

Line 1485: --isir_rec := igf_ap_batch_ver_prc_pkg.lp_isir_rec;

1481: -- || l_get_ver_data_rec.col_name || ' := ' || '''' || l_get_ver_data_rec.col_val || '''' || ' ; END;' ;
1482: --END LOOP;
1483: --CLOSE cur_get_ver_data ;
1484:
1485: --isir_rec := igf_ap_batch_ver_prc_pkg.lp_isir_rec;
1486:
1487: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Before calling main Calculate EFC routine with Ignore Warnings:'||p_ignore_warnings);
1489: END IF;