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_SL_GEN dependencies on IGF_SL_CL_SETUP_ALL

Line 449: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,

445:
446:
447:
448:
449: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
450: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
451: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
452: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
453: RETURN VARCHAR2

Line 450: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,

446:
447:
448:
449: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
450: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
451: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
452: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
453: RETURN VARCHAR2
454: AS

Line 451: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,

447:
448:
449: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
450: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
451: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
452: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
453: RETURN VARCHAR2
454: AS
455: /*************************************************************

Line 477: CURSOR cur_cl_version (p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,

473: bkkumar 30-sep-2003 FA 122 Loans Enhancements
474: Changed the entire code
475: (reverse chronological order - newest change first)
476: ***************************************************************/
477: CURSOR cur_cl_version (p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
478: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
479: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
480: p_party_id hz_parties.party_id%TYPE
481: ) IS

Line 478: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,

474: Changed the entire code
475: (reverse chronological order - newest change first)
476: ***************************************************************/
477: CURSOR cur_cl_version (p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
478: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
479: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
480: p_party_id hz_parties.party_id%TYPE
481: ) IS
482: SELECT cl_version

Line 479: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,

475: (reverse chronological order - newest change first)
476: ***************************************************************/
477: CURSOR cur_cl_version (p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
478: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
479: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
480: p_party_id hz_parties.party_id%TYPE
481: ) IS
482: SELECT cl_version
483: FROM igf_sl_cl_setup_all

Line 483: FROM igf_sl_cl_setup_all

479: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
480: p_party_id hz_parties.party_id%TYPE
481: ) IS
482: SELECT cl_version
483: FROM igf_sl_cl_setup_all
484: WHERE ci_cal_type = p_ci_cal_type
485: AND ci_sequence_number = p_ci_seq_num
486: AND relationship_cd = p_relationship_cd
487: AND NVL(PARTY_ID, -99) = NVL(p_party_id, -99);

Line 489: lv_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

485: AND ci_sequence_number = p_ci_seq_num
486: AND relationship_cd = p_relationship_cd
487: AND NVL(PARTY_ID, -99) = NVL(p_party_id, -99);
488:
489: lv_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
490: l_v_party_number hz_parties.party_number%TYPE;
491: l_v_org_party_id hz_parties.party_id%TYPE;
492: l_v_module VARCHAR2(1024);
493: l_v_return_status VARCHAR2(1024);

Line 1183: p_rel_code IN igf_sl_cl_setup_all.relationship_cd%TYPE,

1179:
1180: END get_person_details;
1181:
1182: PROCEDURE check_rel (
1183: p_rel_code IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1184: p_flag OUT NOCOPY VARCHAR2
1185: )
1186: AS
1187: /*************************************************************

Line 1201: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE

1197: (reverse chronological order - newest change first)
1198: **************************************************************/
1199:
1200: CURSOR c_chk_rel_code1 (
1201: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE
1202: )
1203: IS
1204: SELECT relationship_cd
1205: FROM igf_sl_cl_setup_all

Line 1205: FROM igf_sl_cl_setup_all

1201: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE
1202: )
1203: IS
1204: SELECT relationship_cd
1205: FROM igf_sl_cl_setup_all
1206: WHERE relationship_cd = cp_rel_code
1207: AND ROWNUM = 1;
1208:
1209: l_chk_rel_code1 c_chk_rel_code1%ROWTYPE;

Line 1212: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE

1208:
1209: l_chk_rel_code1 c_chk_rel_code1%ROWTYPE;
1210:
1211: CURSOR c_chk_rel_code2 (
1212: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE
1213: )
1214: IS
1215: SELECT relationship_cd
1216: FROM igf_sl_cl_pref_lenders

Line 1222: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE

1218: AND ROWNUM = 1;
1219:
1220: l_chk_rel_code2 c_chk_rel_code2%ROWTYPE;
1221: CURSOR c_chk_rel_code3 (
1222: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE
1223: )
1224: IS
1225: SELECT alt_rel_code
1226: FROM igf_aw_fund_cat_all

Line 1667: FUNCTION check_prc_chg (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,

1663: app_exception.raise_exception;
1664:
1665: END get_fed_fund_code;
1666:
1667: FUNCTION check_prc_chg (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1668: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
1669: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
1670: )
1671: RETURN BOOLEAN AS

Line 1689: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,

1685: --
1686: --Change History:
1687: --Who When What
1688: ------------------------------------------------------------------
1689: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
1690: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
1691: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1692: ) IS
1693: SELECT loans.loan_number

Line 1734: FUNCTION check_prc_chgm (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,

1730: igs_ge_msg_stack.add;
1731: app_exception.raise_exception;
1732: END check_prc_chg;
1733:
1734: FUNCTION check_prc_chgm (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1735: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
1736: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
1737: )
1738: RETURN BOOLEAN AS

Line 1756: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,

1752: --
1753: --Change History:
1754: --Who When What
1755: ------------------------------------------------------------------
1756: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
1757: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
1758: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1759: ) IS
1760: SELECT loans.loan_number