DBA Data[Home] [Help]

APPS.IGF_DB_SF_INTEGRATION dependencies on IGS_FI_CREDITS

Line 360: p_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,

356:
357: PROCEDURE call_credits_api(p_cur_disb IN cur_disb%ROWTYPE,
358: p_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
359: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
360: p_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
361: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
362: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
363: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
364: p_n_source_invoice_id IN igs_fi_credits_all.source_invoice_id%TYPE

Line 363: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

359: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
360: p_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
361: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
362: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
363: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
364: p_n_source_invoice_id IN igs_fi_credits_all.source_invoice_id%TYPE
365: )AS
366: /***********************************************************************************************
367: Created by : Sarakshi,

Line 364: p_n_source_invoice_id IN igs_fi_credits_all.source_invoice_id%TYPE

360: p_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
361: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
362: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
363: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
364: p_n_source_invoice_id IN igs_fi_credits_all.source_invoice_id%TYPE
365: )AS
366: /***********************************************************************************************
367: Created by : Sarakshi,
368: Date created: 24-Dec-2001

Line 408: igs_fi_credits_api_pub.create_credit.Removed references to igs_fi_cur.Instead defaulted the

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
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.

Line 413: Also modified the call to igs_fi_credits_api_pub.create_credit.Removed 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.
417: smadathi 03-Jun-2002 Bug 2349394. call to get_bill_desc function is made to get bill description

Line 415: smadathi 10-JUL-2002 Bug 2450332. Call to igs_fi_credits_api_pub.create_credit modified to

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.
417: smadathi 03-Jun-2002 Bug 2349394. call to get_bill_desc function is made to get bill description
418: which is passed as parameter to credits API for all funds except sponsor.
419: vchappid 11-Feb-2002 Enh#2191470,Un-Commented reference to new parameters introduced in the Credits API

Line 439: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;

435:
436: l_credit_activity_id igs_fi_cr_activities.credit_activity_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;

Line 442: l_desc igs_fi_credits_all.description%TYPE;

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;
446: l_credit_rec igs_fi_credit_pvt.credit_rec_type;

Line 447: l_v_credit_number igs_fi_credits.credit_number%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;
446: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
447: l_v_credit_number igs_fi_credits.credit_number%TYPE;
448:
449:
450: BEGIN
451: p_error_desc :=NULL;

Line 590: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE

586: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
587: p_invoice_id OUT NOCOPY igs_fi_inv_int_all.invoice_id%TYPE,
588: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
589: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
590: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE
591: )AS
592: /***********************************************************************************************
593:
594: Created By : Sarakshi

Line 667: l_n_waiver_amount igs_fi_credits_all.amount%TYPE;

663: l_transaction_type igs_lookups_view.lookup_code%TYPE;
664:
665: l_v_currency igs_fi_control_all.currency_cd%TYPE;
666: l_v_message_name fnd_new_messages.message_name%TYPE;
667: l_n_waiver_amount igs_fi_credits_all.amount%TYPE;
668:
669:
670: BEGIN
671: p_error_desc := NULL;

Line 814: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE

810: END call_charges_api;
811:
812: PROCEDURE main_disbursement(
813: p_rec_disb IN cur_disb%ROWTYPE,
814: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE
815: ) AS
816: /***********************************************************************************************
817:
818: Created By : Sarakshi

Line 1475: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;

1471: l_ld_sequence_number igf_aw_awd_ld_cal_v.ld_sequence_number%TYPE;
1472:
1473: l_v_message_name fnd_new_messages.message_name%TYPE;
1474: l_v_closing_status gl_period_statuses.closing_status%TYPE;
1475: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
1476:
1477: l_exp_err_exception EXCEPTION;
1478: l_v_curr_desc fnd_currencies_tl.name%TYPE;
1479: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;