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_DB_SF_INTEGRATION dependencies on IGS_PE_PERSON_V

Line 403: igs_pe_person_v. This fix is done to remove

399: 3. The credit description is modified for the sponsor transaction as
400: Negative Charge Adjustment : Person Number : Full Name
401: smadathi 31-dec-2002 Bug 2620349. Modified the cursor cur_api select to fetch
402: the records from view igs_fi_parties_v instead of
403: igs_pe_person_v. This fix is done to remove
404: Non-mergablity due to igs_pe_person_v view and to reduce shared memory
405: vvutukur 13-Dec-2002 Enh#2584741.Deposits Build.Modified the call to credits api to remove p_validation_level
406: parameter and add 3 new parameters p_v_check_number,p_v_source_tran_type,p_v_source_tran_ref_number.
407: vvutukur 20-Nov-2002 Enh#2584986.Added new IN parameter p_d_gl_date.Passed p_d_gl_date to the call to

Line 404: Non-mergablity due to igs_pe_person_v view and to reduce shared memory

400: Negative Charge Adjustment : Person Number : Full Name
401: smadathi 31-dec-2002 Bug 2620349. Modified the cursor cur_api select to fetch
402: the records from view igs_fi_parties_v instead of
403: igs_pe_person_v. This fix is done to remove
404: Non-mergablity due to igs_pe_person_v view and to reduce shared memory
405: vvutukur 13-Dec-2002 Enh#2584741.Deposits Build.Modified the call to credits api to remove p_validation_level
406: parameter and add 3 new parameters p_v_check_number,p_v_source_tran_type,p_v_source_tran_ref_number.
407: vvutukur 20-Nov-2002 Enh#2584986.Added new IN parameter p_d_gl_date.Passed p_d_gl_date to the call to
408: igs_fi_credits_api_pub.create_credit.Removed references to igs_fi_cur.Instead defaulted the

Line 430: CURSOR cur_api(cp_person_id igs_pe_person_v.person_id%TYPE) IS

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
431: SELECT person_number,full_name
432: FROM igs_pe_person_base_v
433: WHERE person_id = cp_person_id;
434: l_cur_api cur_api%ROWTYPE;

Line 441: l_person_id igs_pe_person_v.person_id%TYPE;

437: l_msg_count NUMBER(2);
438: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;
439: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;
440: l_credit_num NUMBER;
441: l_person_id igs_pe_person_v.person_id%TYPE;
442: l_desc igs_fi_credits_all.description%TYPE;
443: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;
444:
445: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 614: igs_pe_person_v. This fix is done to remove

610: 3. The invoice description is modified for the sponsor transaction as
611: Person Number : Full Name
612: smadathi 31-dec-2002 Bug 2620349. Modified the cursor cur_api select to fetch
613: the records from view igs_fi_parties_v instead of
614: igs_pe_person_v. This fix is done to remove
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

Line 615: Non-mergablity due to igs_pe_person_v view and to reduce shared memory

611: Person Number : Full Name
612: smadathi 31-dec-2002 Bug 2620349. Modified the cursor cur_api select to fetch
613: the records from view igs_fi_parties_v instead of
614: igs_pe_person_v. This fix is done to remove
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.

Line 636: CURSOR cur_api(cp_person_id igs_pe_person_v.person_id%TYPE) IS

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
637: SELECT person_number,full_name
638: FROM igs_pe_person_base_v
639: WHERE person_id = cp_person_id;
640: l_cur_api cur_api%ROWTYPE;

Line 659: l_person_id igs_pe_person_v.person_id%TYPE;

655: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;
656: l_var NUMBER(5) := 0;
657: l_count NUMBER(5);
658: l_msg igf_db_awd_disb_dtl.error_desc%TYPE;
659: l_person_id igs_pe_person_v.person_id%TYPE;
660: l_fee_type igf_aw_fund_mast.fee_type%TYPE;
661: l_invoice_desc igs_fi_inv_int.invoice_desc%TYPE;
662: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;
663: l_transaction_type igs_lookups_view.lookup_code%TYPE;

Line 858: CURSOR cur_person(cp_person_id igs_pe_person_v.person_id%TYPE) IS

854: sarakshi 18-Mar-2002 Bug:2144600, added logic for refunding the excess credit amount
855: vchappid 11-Feb-2002 Enh#2191470, Un-Commented reference to Fee Cal parameters in the Charges API invoking
856: Fee Cal Parameters Derived for the Load Cal are passed for charges Creation
857: ********************************************************************************************** */
858: CURSOR cur_person(cp_person_id igs_pe_person_v.person_id%TYPE) IS
859: SELECT person_number
860: FROM igs_pe_person_base_v
861: WHERE person_id=cp_person_id;
862: l_cur_person cur_person%ROWTYPE;