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.

[Home] [Help]

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

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 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 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 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 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 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: