DBA Data[Home] [Help]

APPS.IGF_DB_SF_INTEGRATION dependencies on IGS_FI_CR_TYPES

Line 412: and not the subaccount_id column from igs_fi_cr_types table.

408: igs_fi_credits_api_pub.create_credit.Removed references to igs_fi_cur.Instead defaulted the
409: currency that is set up in System Options Form and passed the same to the call to
410: credits api. Also exchange rate is passed as 1.
411: jbegum 21-Sep-2002 Bug #2564643 Modified the cursor cur_desc to select only description column
412: and not the subaccount_id column from igs_fi_cr_types table.
413: Also modified the call to igs_fi_credits_api_pub.create_credit.Removed the
414: parameter p_subaccount_id.
415: smadathi 10-JUL-2002 Bug 2450332. Call to igs_fi_credits_api_pub.create_credit modified to
416: pass current system date as effective date instead of disbursement date.

Line 424: CURSOR cur_desc(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS

420: ********************************************************************************************** */
421:
422: -- Bug #2564643 Modified the cursor cur_desc to select only description column
423:
424: CURSOR cur_desc(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
425: SELECT credit_class
426: FROM igs_fi_cr_types_v
427: WHERE credit_type_id = cp_credit_type_id;
428: l_cur_desc cur_desc%ROWTYPE;

Line 426: FROM igs_fi_cr_types_v

422: -- Bug #2564643 Modified the cursor cur_desc to select only description column
423:
424: CURSOR cur_desc(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
425: SELECT credit_class
426: FROM igs_fi_cr_types_v
427: WHERE credit_type_id = cp_credit_type_id;
428: l_cur_desc cur_desc%ROWTYPE;
429:
430: CURSOR cur_api(cp_person_id igs_pe_person_v.person_id%TYPE) IS

Line 619: and not the subaccount_id column from igs_fi_cr_types table.

615: Non-mergablity due to igs_pe_person_v view and to reduce shared memory
616: vvutukur 20-Nov-2002 Enh#2584986.Added new IN parameter p_d_gl_date to this procedure.Passed p_d_gl_date to
617: the call to igs_fi_charges_api_pvt.create_charge.
618: jbegum 21-Sep-2002 Bug #2564643 Modified the cursor cur_desc to select only description column
619: and not the subaccount_id column from igs_fi_cr_types table.
620: Also modified the record structure being passed to igs_fi_charges_api_pvt.create_charge.
621: Removed the field l_chg_rec.p_subaccount_id .
622: smadathi 03-Jun-2002 Bug 2349394. call to get_bill_desc function is made to get bill description
623: which is passed as parameter to charges API for all funds except sponsor.

Line 630: CURSOR cur_desc(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS

626: ********************************************************************************************** */
627:
628: -- Bug #2564643 Modified the cursor cur_desc to select only description column
629:
630: CURSOR cur_desc(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
631: SELECT description
632: FROM igs_fi_cr_types
633: WHERE credit_type_id = cp_credit_type_id;
634: l_cur_desc cur_desc%ROWTYPE;

Line 632: FROM igs_fi_cr_types

628: -- Bug #2564643 Modified the cursor cur_desc to select only description column
629:
630: CURSOR cur_desc(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
631: SELECT description
632: FROM igs_fi_cr_types
633: WHERE credit_type_id = cp_credit_type_id;
634: l_cur_desc cur_desc%ROWTYPE;
635:
636: CURSOR cur_api(cp_person_id igs_pe_person_v.person_id%TYPE) IS

Line 864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS

860: FROM igs_pe_person_base_v
861: WHERE person_id=cp_person_id;
862: l_cur_person cur_person%ROWTYPE;
863:
864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS
865: SELECT credit_type_name
866: FROM igs_fi_cr_types_all
867: WHERE credit_type_id = cp_credit_type_id;
868:

Line 866: FROM igs_fi_cr_types_all

862: l_cur_person cur_person%ROWTYPE;
863:
864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS
865: SELECT credit_type_name
866: FROM igs_fi_cr_types_all
867: WHERE credit_type_id = cp_credit_type_id;
868:
869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;
870:

Line 869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;

865: SELECT credit_type_name
866: FROM igs_fi_cr_types_all
867: WHERE credit_type_id = cp_credit_type_id;
868:
869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;
870:
871: CURSOR cur_awd(cp_award_id igf_aw_award.award_id%TYPE) IS
872: SELECT a.rowid,a.*
873: FROM igf_aw_award a

Line 924: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

920: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
921: l_message_name fnd_new_messages.message_name%TYPE;
922: -- End of Modification for Enh#2191470
923:
924: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
925: l_b_return_status BOOLEAN;
926:
927: l_v_holds_message fnd_new_messages.message_text%TYPE := NULL;
928: