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.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_FA_BASE_REC

Line 36: | to TBH call igf_ap_fa_base_rec_pkg |

32: | Corrected the issue for creating correction ISIR
33: | |
34: | rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05 |
35: | added parameter award_fmly_contribution_type |
36: | to TBH call igf_ap_fa_base_rec_pkg |
37: | Added TBH impact of igf_ap_isir_matched |
38: | |
39: | cdcruz 26-SEP-2003 FA 121 - Verification Worksheet. |
40: | Changes per the TD have been incoporated |

Line 45: | igf_ap_fa_base_rec_pkg.update_row w.r.t. FA126|

41: | EFC Computation is added while creating |
42: | correction records |
43: | ugummall 26-SEP-2003 FA 126 - Multiple FA Offices. |
44: | added new parameter assoc_org_num to TBH call |
45: | igf_ap_fa_base_rec_pkg.update_row w.r.t. FA126|
46: | |
47: | bkkumar 27-Aug-2003 Bug# 3071157 Added explicit date format mask |
48: | to the to_date() function. |
49: | gmuralid 10-03-2003 BUG# 2829487 .In procedure update process |

Line 69: | update of igf_ap_fa_base_rec. |

65: | |
66: | Bug 2637505 - DEV LINE Fix of Bugs on MNT Line. |
67: | Please look in the bug for details of the fix. |
68: | update_fa_status - pv_verification_status passed to |
69: | update of igf_ap_fa_base_rec. |
70: | l_chk_dup_corr - Another cursor added to check if any record is already
71: | present with the new correction status evaluated. |
72: | main: Logic to derive verification status modified. |
73: | Bug 2606001,2613546 |

Line 76: | Added x_pell_alt_expense in igf_ap_fa_base_rec_pkg |

72: | main: Logic to derive verification status modified. |
73: | Bug 2606001,2613546 |
74: | sjadhav Oct.28.2002 |
75: | Added l_pell_mat to igf_gr_pell.pell_calc routine |
76: | Added x_pell_alt_expense in igf_ap_fa_base_rec_pkg |
77: | Modified get_gr_ver_code to read mapping from igf_aw_int_ext_map table|
78: |-----------------------------------------------------------------------|
79: | 12-Jun-2002 Bug ID: 2402371/ 2403886. |
80: |The initialization of cursor variable dbms_sql.open_cursor removed from|

Line 118: | IGF_AP_FA_BASE_RECORD_PKG. |

114: | gvarapra 14-sep-2004 FA138 - ISIR Enhancements |
115: | Added arguments in call to |
116: | IGF_AP_ISIR_MATCHED_PKG. |
117: | Added arguments in call to |
118: | IGF_AP_FA_BASE_RECORD_PKG. |
119: *=======================================================================*/
120:
121: l_new_corr_status igf_ap_isir_corr.correction_status%TYPE;
122: ln_corr_count NUMBER;

Line 248: pn_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

244: END l_chk_dup_corr;
245:
246:
247: PROCEDURE l_update_base_rec(
248: pn_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
249: pv_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ,
250: pv_tol NUMBER,
251: pv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE
252: ) IS

Line 249: pv_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ,

245:
246:
247: PROCEDURE l_update_base_rec(
248: pn_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
249: pv_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ,
250: pv_tol NUMBER,
251: pv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE
252: ) IS
253:

Line 251: pv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE

247: PROCEDURE l_update_base_rec(
248: pn_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
249: pv_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ,
250: pv_tol NUMBER,
251: pv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE
252: ) IS
253:
254: CURSOR cur_fa_base (pn_base_id NUMBER) IS
255: SELECT fbr.*

Line 256: FROM igf_ap_fa_base_rec fbr

252: ) IS
253:
254: CURSOR cur_fa_base (pn_base_id NUMBER) IS
255: SELECT fbr.*
256: FROM igf_ap_fa_base_rec fbr
257: WHERE base_id = pn_base_id FOR UPDATE NOWAIT;
258:
259: BEGIN
260:

Line 264: igf_ap_fa_base_rec_pkg.update_row (

260:
261: FOR cur_fbr_rec IN cur_fa_base (pn_base_id) LOOP
262:
263: -- Update necessary fields in FA_Base_Record table.
264: igf_ap_fa_base_rec_pkg.update_row (
265: x_Mode => 'R',
266: x_rowid => cur_fbr_rec.row_id,
267: x_base_id => cur_fbr_rec.base_id,
268: x_ci_cal_type => cur_fbr_rec.ci_cal_type,

Line 380: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_fa_base_rec_pkg.update_row successfull');

376: x_lock_awd_flag => cur_fbr_rec.lock_awd_flag,
377: x_lock_coa_flag => cur_fbr_rec.lock_coa_flag
378: );
379: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
380: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_fa_base_rec_pkg.update_row successfull');
381: END IF;
382: END LOOP;
383:
384: EXCEPTION

Line 440: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

436: p_datatype := 'C';
437: END check_data_type;
438:
439: PROCEDURE create_correction_isir(
440: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
441: pn_isir_id OUT NOCOPY NUMBER
442: ) IS
443: /*
444: || Created By : skoppula

Line 790: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,

786: END create_correction_isir;
787:
788:
789: PROCEDURE update_correction_isir (
790: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,
791: p_isir_rec IGF_AP_ISIR_MATCHED%ROWTYPE ,
792: p_update_ssn VARCHAR2
793: ) IS
794: /*

Line 1151: FUNCTION l_incomplete(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) RETURN BOOLEAN IS

1147: APP_EXCEPTION.RAISE_EXCEPTION;
1148: END update_correction_isir;
1149:
1150:
1151: FUNCTION l_incomplete(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) RETURN BOOLEAN IS
1152:
1153: /*
1154: || Created By : rasingh
1155: || Created On : 06-July-2001

Line 1172: lv_ver_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

1168: AND ( ivi.item_value IS NULL AND NVL(USE_BLANK_FLAG,'N') <> 'Y' )
1169: AND rownum = 1;
1170:
1171: lv_flag NUMBER := 0;
1172: lv_ver_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1173: lb_return_status BOOLEAN;
1174:
1175: BEGIN
1176:

Line 1207: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,

1203: END l_incomplete;
1204:
1205:
1206: PROCEDURE l_create_corr_record(
1207: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,
1208: pn_isir_id igf_ap_isir_matched.isir_id%TYPE ,
1209: pv_isir_map_column igf_ap_inst_ver_item.isir_map_col%TYPE,
1210: pv_cal_type igs_ca_inst.cal_type%TYPE,
1211: pn_sequence_number igs_ca_inst.sequence_number%TYPE,

Line 1286: PROCEDURE l_validate_data ( pn_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

1282: RETURN;
1283: END l_create_corr_record;
1284:
1285:
1286: PROCEDURE l_validate_data ( pn_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1287: pv_isir_id IN igf_ap_isir_matched.isir_id%TYPE,
1288: pv_item_value IN igf_ap_inst_ver_item.item_value%TYPE,
1289: pv_column_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE, --gets the SAR Field name
1290: pv_isir_map_column IN igf_ap_inst_ver_item.isir_map_col%TYPE,

Line 1291: pv_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,

1287: pv_isir_id IN igf_ap_isir_matched.isir_id%TYPE,
1288: pv_item_value IN igf_ap_inst_ver_item.item_value%TYPE,
1289: pv_column_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE, --gets the SAR Field name
1290: pv_isir_map_column IN igf_ap_inst_ver_item.isir_map_col%TYPE,
1291: pv_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
1292: pv_ci_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
1293: pv_update_ssn IN OUT NOCOPY VARCHAR2
1294: ) IS
1295: /*

Line 1292: pv_ci_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE ,

1288: pv_item_value IN igf_ap_inst_ver_item.item_value%TYPE,
1289: pv_column_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE, --gets the SAR Field name
1290: pv_isir_map_column IN igf_ap_inst_ver_item.isir_map_col%TYPE,
1291: pv_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
1292: pv_ci_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
1293: pv_update_ssn IN OUT NOCOPY VARCHAR2
1294: ) IS
1295: /*
1296: || Created By : rasingh

Line 1431: FROM igf_ap_fa_base_rec_all far,

1427: pe.party_number person_number,
1428: pe.person_first_name given_names,
1429: pe.person_last_name surname,
1430: im.isir_id
1431: FROM igf_ap_fa_base_rec_all far,
1432: igf_ap_isir_matched_all im,
1433: hz_parties pe
1434: WHERE far.person_id = pe.party_id
1435: AND far.ci_cal_type = NVL(lv_ci_cal_type,far.ci_cal_type)

Line 1460: igf_ap_fa_base_rec_all fabase,

1456: CURSOR cur_get_ver_data ( pn_base_id NUMBER ) IS
1457: SELECT ivi.base_id, ivi.udf_vern_item_seq_num, ivi.item_value, ivi.isir_map_col,
1458: ivi.incl_in_tolerance, sar.sar_field_name column_name
1459: FROM igf_ap_batch_aw_map map,
1460: igf_ap_fa_base_rec_all fabase,
1461: igf_ap_inst_ver_item ivi,
1462: Igf_fc_sar_cd_mst sar
1463: WHERE fabase.base_id = pn_base_id
1464: AND map.ci_cal_type = fabase.ci_cal_type

Line 1475: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1471: (ivi.item_value IS NULL AND NVL(USE_BLANK_FLAG,'N') = 'Y' )
1472: );
1473:
1474: CURSOR cur_get_ver_item_count(
1475: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1476: ) IS
1477: SELECT ivi.base_id
1478: FROM igf_ap_inst_ver_item ivi
1479: WHERE ivi.base_id = cp_base_id

Line 1488: CURSOR c_correction_isir ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

1484: AND rownum = 1;
1485:
1486: lc_get_ver_item_count cur_get_ver_item_count%ROWTYPE;
1487:
1488: CURSOR c_correction_isir ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
1489: SELECT *
1490: FROM igf_ap_isir_matched
1491: WHERE BASE_ID = cp_base_id
1492: AND SYSTEM_RECORD_TYPE = 'CORRECTION';

Line 1783: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1779: END main;
1780:
1781:
1782: PROCEDURE update_process_status(
1783: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1784: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE
1785: ) IS
1786:
1787: CURSOR cur_todo(

Line 1784: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE

1780:
1781:
1782: PROCEDURE update_process_status(
1783: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1784: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE
1785: ) IS
1786:
1787: CURSOR cur_todo(
1788: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 1788: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1784: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE
1785: ) IS
1786:
1787: CURSOR cur_todo(
1788: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1789: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1790: ) IS
1791: SELECT 1
1792: FROM igf_ap_td_item_inst_all tdinst,

Line 1789: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE

1785: ) IS
1786:
1787: CURSOR cur_todo(
1788: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1789: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1790: ) IS
1791: SELECT 1
1792: FROM igf_ap_td_item_inst_all tdinst,
1793: igf_ap_td_item_mst_all tdmst

Line 1805: igf_ap_fa_base_rec_all fa

1801: UNION
1802: SELECT 1
1803: FROM igf_ap_td_item_inst_all tdinst,
1804: igf_ap_td_item_mst_all tdmst,
1805: igf_ap_fa_base_rec_all fa
1806: WHERE tdinst.base_id = fa.base_id
1807: AND tdinst.status IN ('INC','REQ','REC')
1808: AND tdinst.required_for_application = 'Y'
1809: AND NVL(tdinst.inactive_flag,'N') <> 'Y'

Line 1815: CURSOR cur_ver_status ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

1811: AND tdmst.career_item = 'Y'
1812: AND fa.person_id = p_person_id
1813: AND ROWNUM < 2;
1814:
1815: CURSOR cur_ver_status ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1816: SELECT fed_verif_status, NVL(fa_process_status,'RECEIVED') fa_process_status
1817: FROM igf_ap_fa_base_rec
1818: WHERE base_id = p_base_id;
1819:

Line 1817: FROM igf_ap_fa_base_rec

1813: AND ROWNUM < 2;
1814:
1815: CURSOR cur_ver_status ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1816: SELECT fed_verif_status, NVL(fa_process_status,'RECEIVED') fa_process_status
1817: FROM igf_ap_fa_base_rec
1818: WHERE base_id = p_base_id;
1819:
1820: ln_count_open_items NUMBER;
1821: l_person_id hz_parties.party_id%TYPE;

Line 1822: lv_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

1818: WHERE base_id = p_base_id;
1819:
1820: ln_count_open_items NUMBER;
1821: l_person_id hz_parties.party_id%TYPE;
1822: lv_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1823: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;
1824: ln_auto_na_complete VARCHAR2(80);
1825:
1826: -- Get person_id

Line 1823: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;

1819:
1820: ln_count_open_items NUMBER;
1821: l_person_id hz_parties.party_id%TYPE;
1822: lv_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1823: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;
1824: ln_auto_na_complete VARCHAR2(80);
1825:
1826: -- Get person_id
1827: CURSOR c_person_id(

Line 1828: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1824: ln_auto_na_complete VARCHAR2(80);
1825:
1826: -- Get person_id
1827: CURSOR c_person_id(
1828: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1829: ) IS
1830: SELECT person_id
1831: FROM igf_ap_fa_base_rec_all
1832: WHERE base_id = cp_base_id;

Line 1831: FROM igf_ap_fa_base_rec_all

1827: CURSOR c_person_id(
1828: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1829: ) IS
1830: SELECT person_id
1831: FROM igf_ap_fa_base_rec_all
1832: WHERE base_id = cp_base_id;
1833:
1834: BEGIN
1835:

Line 1897: PROCEDURE update_fed_verif_status ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

1893: APP_EXCEPTION.RAISE_EXCEPTION;
1894:
1895: END update_process_status;
1896:
1897: PROCEDURE update_fed_verif_status ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1898: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE
1899: ) IS
1900: /**********************************************************
1901: Created By : bkkumar

Line 1898: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE

1894:
1895: END update_process_status;
1896:
1897: PROCEDURE update_fed_verif_status ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1898: p_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE
1899: ) IS
1900: /**********************************************************
1901: Created By : bkkumar
1902: Date Created By : 10-Dec-2003

Line 1912: CURSOR get_fed_verif_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1908: Change History
1909: Who When What
1910: (reverse chronological order - newest change first)
1911: ***************************************************************/
1912: CURSOR get_fed_verif_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1913: IS
1914: SELECT fed_verif_status
1915: FROM igf_ap_fa_base_rec_all
1916: WHERE base_id = cp_base_id;

Line 1915: FROM igf_ap_fa_base_rec_all

1911: ***************************************************************/
1912: CURSOR get_fed_verif_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1913: IS
1914: SELECT fed_verif_status
1915: FROM igf_ap_fa_base_rec_all
1916: WHERE base_id = cp_base_id;
1917:
1918: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1919:

Line 1918: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

1914: SELECT fed_verif_status
1915: FROM igf_ap_fa_base_rec_all
1916: WHERE base_id = cp_base_id;
1917:
1918: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1919:
1920: BEGIN
1921: l_fed_verif_status := NULL;
1922: