DBA Data[Home] [Help]

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_ISIR_CORR_PKG

Line 1230: igf_ap_isir_corr_pkg.insert_row

1226: BEGIN
1227:
1228: IF pv_mode = 'INSERT' THEN
1229:
1230: igf_ap_isir_corr_pkg.insert_row
1231: (
1232: X_ROWID => lv_rowid,
1233: X_ISIRC_ID => ln_isirc_id,
1234: X_ISIR_ID => pn_isir_id,

Line 1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');

1241: X_CORRECTION_STATUS => NVL(l_new_corr_status,'READY'),
1242: X_MODE => 'R'
1243: );
1244: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');
1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);
1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN

Line 1251: igf_ap_isir_corr_pkg.update_row

1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN
1250: FOR corr_upd_rec IN upd_Corr_cur LOOP
1251: igf_ap_isir_corr_pkg.update_row
1252: (
1253: X_ROWID => corr_upd_rec.rowid,
1254: X_ISIRC_ID => corr_upd_rec.isirc_id,
1255: X_ISIR_ID => corr_upd_rec.isir_id,

Line 1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');

1262: X_CORRECTION_STATUS => l_new_corr_status,
1263: X_MODE => 'R'
1264: );
1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);