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.IGS_FI_CRDAPI_UTIL dependencies on IGS_FI_CR_TYPES

Line 326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

322: vvutukur 18-Jun-2003 Enh#2831582.Lockbox Build. Removed call to function validate_lockbox as the same has been removed.
323: schodava 11-Jun-03 Enh # 2831587. Credit Card Fund Transfer Build
324: Added validations for Credit Card status and credit card payee
325: ********************************************************************************************** */
326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
327: l_n_pay_cr_type_id igs_fi_cr_types.payment_credit_type_id%TYPE;
328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;
330: l_b_return_status BOOLEAN;

Line 327: l_n_pay_cr_type_id igs_fi_cr_types.payment_credit_type_id%TYPE;

323: schodava 11-Jun-03 Enh # 2831587. Credit Card Fund Transfer Build
324: Added validations for Credit Card status and credit card payee
325: ********************************************************************************************** */
326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
327: l_n_pay_cr_type_id igs_fi_cr_types.payment_credit_type_id%TYPE;
328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;
330: l_b_return_status BOOLEAN;
331: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 334: FUNCTION get_cr_type(p_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) RETURN VARCHAR2 AS

330: l_b_return_status BOOLEAN;
331: l_v_message_name fnd_new_messages.message_name%TYPE;
332: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
333:
334: FUNCTION get_cr_type(p_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) RETURN VARCHAR2 AS
335: /***********************************************************************************************
336: Created By: shtatiko
337: Date Created By: 03-APR-2003
338: Purpose: This function returns credit type name for the specified credit type id.

Line 349: FROM igs_fi_cr_types

345: if the combination of party_id and credit_number already exists in the system.
346: ********************************************************************************************** */
347: CURSOR cur_cr IS
348: SELECT credit_type_name
349: FROM igs_fi_cr_types
350: WHERE credit_type_id = p_credit_type_id;
351: l_cr_type igs_fi_cr_types.credit_type_name%TYPE;
352: BEGIN
353: OPEN cur_cr;

Line 351: l_cr_type igs_fi_cr_types.credit_type_name%TYPE;

347: CURSOR cur_cr IS
348: SELECT credit_type_name
349: FROM igs_fi_cr_types
350: WHERE credit_type_id = p_credit_type_id;
351: l_cr_type igs_fi_cr_types.credit_type_name%TYPE;
352: BEGIN
353: OPEN cur_cr;
354: FETCH cur_cr INTO l_cr_type;
355: CLOSE cur_cr;

Line 920: CURSOR cur_cr_typ (cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE)

916: Known limitations,enhancements,remarks:
917: Change History
918: Who When What
919: ********************************************************************************************** */
920: CURSOR cur_cr_typ (cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE)
921: IS
922: SELECT credit_class
923: FROM igs_fi_cr_types_all
924: WHERE credit_type_id = cp_credit_type_id

Line 923: FROM igs_fi_cr_types_all

919: ********************************************************************************************** */
920: CURSOR cur_cr_typ (cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE)
921: IS
922: SELECT credit_class
923: FROM igs_fi_cr_types_all
924: WHERE credit_type_id = cp_credit_type_id
925: AND TRUNC(SYSDATE) BETWEEN TRUNC(effective_start_date) AND TRUNC(NVL(effective_end_date,SYSDATE));
926:
927: BEGIN

Line 1139: CURSOR c_check_cr_typ_id (cp_cr_typ_id igs_fi_cr_types.credit_type_id%TYPE)

1135: Known limitations,enhancements,remarks:
1136: Change History
1137: Who When What
1138: ***********************************************************************************************/
1139: CURSOR c_check_cr_typ_id (cp_cr_typ_id igs_fi_cr_types.credit_type_id%TYPE)
1140: IS
1141: SELECT c.payment_credit_type_id
1142: FROM igs_fi_cr_types c
1143: WHERE c.credit_type_id = cp_cr_typ_id

Line 1142: FROM igs_fi_cr_types c

1138: ***********************************************************************************************/
1139: CURSOR c_check_cr_typ_id (cp_cr_typ_id igs_fi_cr_types.credit_type_id%TYPE)
1140: IS
1141: SELECT c.payment_credit_type_id
1142: FROM igs_fi_cr_types c
1143: WHERE c.credit_type_id = cp_cr_typ_id
1144: AND TRUNC(SYSDATE) BETWEEN TRUNC(c.effective_start_date) AND TRUNC(NVL(c.effective_end_date,SYSDATE))
1145: AND EXISTS (SELECT 'x'
1146: FROM igs_fi_cr_types p

Line 1146: FROM igs_fi_cr_types p

1142: FROM igs_fi_cr_types c
1143: WHERE c.credit_type_id = cp_cr_typ_id
1144: AND TRUNC(SYSDATE) BETWEEN TRUNC(c.effective_start_date) AND TRUNC(NVL(c.effective_end_date,SYSDATE))
1145: AND EXISTS (SELECT 'x'
1146: FROM igs_fi_cr_types p
1147: WHERE p.credit_type_id = c.payment_credit_type_id
1148: AND TRUNC(SYSDATE) BETWEEN TRUNC(p.effective_start_date) AND TRUNC(NVL(p.effective_end_date,SYSDATE)));
1149:
1150: BEGIN