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_SS_PKG dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 5: p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,

1: PACKAGE BODY IGF_AP_SS_PKG AS
2: /* $Header: IGFAP30B.pls 120.4 2006/04/19 04:22:53 azmohamm ship $ */
3:
4: PROCEDURE set_internal_isir (
5: p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,
6: p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE
7: )IS
8: /*
9: || Created By : cdcruz

Line 6: p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE

2: /* $Header: IGFAP30B.pls 120.4 2006/04/19 04:22:53 azmohamm ship $ */
3:
4: PROCEDURE set_internal_isir (
5: p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,
6: p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE
7: )IS
8: /*
9: || Created By : cdcruz
10: || Created On : 27-NOV-2002

Line 29: CURSOR c_isir (l_isir_id igf_ap_isir_matched_all.isir_id%type)

25: || modified signature of igf_ap_isir_matched_pkg
26: || (reverse chronological order - newest change first)
27: */
28:
29: CURSOR c_isir (l_isir_id igf_ap_isir_matched_all.isir_id%type)
30: IS
31: SELECT ISIR.*
32: FROM IGF_AP_ISIR_MATCHED ISIR
33: WHERE ISIR.ISIR_ID = l_isir_id ;

Line 37: CURSOR chk_internal (l_base_id igf_ap_isir_matched_all.base_id%type)

33: WHERE ISIR.ISIR_ID = l_isir_id ;
34:
35: lv_isir c_isir%rowtype ;
36:
37: CURSOR chk_internal (l_base_id igf_ap_isir_matched_all.base_id%type)
38: IS
39: SELECT isir.rowid row_id,isir.isir_id FROM IGF_AP_ISIR_MATCHED_ALL ISIR
40: WHERE
41: ISIR.BASE_ID = l_base_id AND

Line 39: SELECT isir.rowid row_id,isir.isir_id FROM IGF_AP_ISIR_MATCHED_ALL ISIR

35: lv_isir c_isir%rowtype ;
36:
37: CURSOR chk_internal (l_base_id igf_ap_isir_matched_all.base_id%type)
38: IS
39: SELECT isir.rowid row_id,isir.isir_id FROM IGF_AP_ISIR_MATCHED_ALL ISIR
40: WHERE
41: ISIR.BASE_ID = l_base_id AND
42: NVL(ISIR.SYSTEM_RECORD_TYPE,'X') = 'INTERNAL'
43: FOR UPDATE NOWAIT;

Line 51: FROM IGF_AP_ISIR_MATCHED_ALL ISIR

47:
48: CURSOR chk_row_id
49: IS
50: SELECT isir.rowid row_id
51: FROM IGF_AP_ISIR_MATCHED_ALL ISIR
52: WHERE
53: ISIR.rowid = lv_rowid
54: FOR UPDATE NOWAIT;
55:

Line 76: pn_isir_id igf_ap_isir_matched_all.isir_id%type ;

72: AND NVL(verf.waive_flag,'N') = 'N'
73: AND ((verf.item_value IS NOT NULL) OR (verf.item_value IS NULL AND verf.use_blank_flag = 'Y'))
74: AND verf.base_id = pn_base_id ;
75:
76: pn_isir_id igf_ap_isir_matched_all.isir_id%type ;
77: pn_base_id igf_ap_isir_matched_all.base_id%type;
78:
79: l_get_ver_data_rec cur_get_ver_data%ROWTYPE;
80:

Line 77: pn_base_id igf_ap_isir_matched_all.base_id%type;

73: AND ((verf.item_value IS NOT NULL) OR (verf.item_value IS NULL AND verf.use_blank_flag = 'Y'))
74: AND verf.base_id = pn_base_id ;
75:
76: pn_isir_id igf_ap_isir_matched_all.isir_id%type ;
77: pn_base_id igf_ap_isir_matched_all.base_id%type;
78:
79: l_get_ver_data_rec cur_get_ver_data%ROWTYPE;
80:
81: BEGIN

Line 1125: p_org_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

1121: END update_isir;
1122:
1123:
1124: PROCEDURE save_as_correction_isir(
1125: p_org_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1126: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1127: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1128: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1129: p_corr_status IN VARCHAR2 ,

Line 1126: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

1122:
1123:
1124: PROCEDURE save_as_correction_isir(
1125: p_org_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1126: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1127: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1128: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1129: p_corr_status IN VARCHAR2 ,
1130: x_msg_count OUT NOCOPY NUMBER,

Line 1151: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE

1147: -------------------------------------------------------------------
1148:
1149: -- Get the details of ISIR Record from isir_matched table
1150: CURSOR c_isir_detials(
1151: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE
1152: ) IS
1153: SELECT *
1154: FROM igf_ap_isir_matched
1155: WHERE isir_id = p_isir_id;

Line 1179: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

1175:
1176:
1177: isir_detials_rec igf_ap_isir_matched%ROWTYPE;
1178: corr_detials_rec igf_ap_isir_matched%ROWTYPE;
1179: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
1180: isir_row_id ROWID;
1181: l_message VARCHAR2(50);
1182: l_old_active_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
1183: l_anticip_status VARCHAR2(30);

Line 1182: l_old_active_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

1178: corr_detials_rec igf_ap_isir_matched%ROWTYPE;
1179: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
1180: isir_row_id ROWID;
1181: l_message VARCHAR2(50);
1182: l_old_active_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
1183: l_anticip_status VARCHAR2(30);
1184: l_awd_prc_status VARCHAR2(30);
1185:
1186:

Line 1307: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

1303: END save_as_correction_isir;
1304:
1305:
1306: PROCEDURE create_simulation_isir(
1307: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1308: x_msg_count OUT NOCOPY NUMBER,
1309: x_msg_data OUT NOCOPY VARCHAR2,
1310: x_return_status OUT NOCOPY VARCHAR2
1311: ) IS

Line 1327: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE

1323: -------------------------------------------------------------------
1324:
1325: -- Get the details of ISIR Record from isir_matched table
1326: CURSOR c_isir_detials(
1327: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE
1328: ) IS
1329: SELECT *
1330: FROM igf_ap_isir_matched
1331: WHERE isir_id = p_isir_id;

Line 1399: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

1395: END create_simulation_isir;
1396:
1397:
1398: PROCEDURE compute_efc(
1399: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1400: p_system_award_year IN VARCHAR2,
1401: p_ignore_warnings IN VARCHAR2,
1402: x_msg_count OUT NOCOPY NUMBER,
1403: x_msg_data OUT NOCOPY VARCHAR2,

Line 1418: CURSOR cur_isir_rec ( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

1414: || Success ( "S" ) and Warning ( "W" )
1415: || (reverse chronological order - newest change first)
1416: */
1417:
1418: CURSOR cur_isir_rec ( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
1419: SELECT isir.*
1420: FROM igf_ap_isir_matched isir
1421: WHERE isir_id = cp_isir_id ;
1422:

Line 1948: p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,

1944:
1945: END get_dynamic_dates;
1946:
1947: PROCEDURE get_internal_isir_id (
1948: p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,
1949: p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE
1950: )IS
1951: /*
1952: || Created By : hkodali

Line 1949: p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE

1945: END get_dynamic_dates;
1946:
1947: PROCEDURE get_internal_isir_id (
1948: p_isir_id IN IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE,
1949: p_ret_isir_id IN OUT NOCOPY IGF_AP_ISIR_MATCHED_ALL.ISIR_ID%TYPE
1950: )IS
1951: /*
1952: || Created By : hkodali
1953: || Created On : 07-01-2005

Line 1964: CURSOR c_isir (l_isir_id igf_ap_isir_matched_all.isir_id%type)

1960: || Who When What
1961: || (reverse chronological order - newest change first)
1962: */
1963:
1964: CURSOR c_isir (l_isir_id igf_ap_isir_matched_all.isir_id%type)
1965: IS
1966: SELECT ISIR.rowid row_id,ISIR.*
1967: FROM IGF_AP_ISIR_MATCHED_ALL ISIR
1968: WHERE ISIR.ISIR_ID = l_isir_id ;

Line 1967: FROM IGF_AP_ISIR_MATCHED_ALL ISIR

1963:
1964: CURSOR c_isir (l_isir_id igf_ap_isir_matched_all.isir_id%type)
1965: IS
1966: SELECT ISIR.rowid row_id,ISIR.*
1967: FROM IGF_AP_ISIR_MATCHED_ALL ISIR
1968: WHERE ISIR.ISIR_ID = l_isir_id ;
1969:
1970: lv_isir c_isir%rowtype ;
1971:

Line 1972: CURSOR chk_internal (l_base_id igf_ap_isir_matched_all.base_id%type)

1968: WHERE ISIR.ISIR_ID = l_isir_id ;
1969:
1970: lv_isir c_isir%rowtype ;
1971:
1972: CURSOR chk_internal (l_base_id igf_ap_isir_matched_all.base_id%type)
1973: IS
1974: SELECT isir.rowid row_id,isir.isir_id FROM IGF_AP_ISIR_MATCHED_ALL ISIR
1975: WHERE
1976: ISIR.BASE_ID = l_base_id AND

Line 1974: SELECT isir.rowid row_id,isir.isir_id FROM IGF_AP_ISIR_MATCHED_ALL ISIR

1970: lv_isir c_isir%rowtype ;
1971:
1972: CURSOR chk_internal (l_base_id igf_ap_isir_matched_all.base_id%type)
1973: IS
1974: SELECT isir.rowid row_id,isir.isir_id FROM IGF_AP_ISIR_MATCHED_ALL ISIR
1975: WHERE
1976: ISIR.BASE_ID = l_base_id AND
1977: NVL(ISIR.SYSTEM_RECORD_TYPE,'X') = 'INTERNAL'
1978: FOR UPDATE NOWAIT;

Line 1982: pn_isir_id igf_ap_isir_matched_all.isir_id%type ;

1978: FOR UPDATE NOWAIT;
1979:
1980: lv_chk_internal chk_internal%rowtype ;
1981: lv_rowid VARCHAR2(30) ;
1982: pn_isir_id igf_ap_isir_matched_all.isir_id%type ;
1983:
1984: BEGIN
1985:
1986: OPEN c_isir(p_isir_id) ;