APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_APPLICATIONS

Line 518: FROM igs_fi_applications appl

514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
516:
517: SELECT appl.rowid row_id, appl.*
518: FROM igs_fi_applications appl
519: WHERE appl.gl_date IS NOT NULL
520: AND TRUNC(appl.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
521: AND appl.posting_id IS NULL
522: AND appl.posting_control_id IS NULL

Line 528: CURSOR cur_credit (cp_credit_id igs_fi_applications.credit_id%TYPE ) IS

524: FOR UPDATE OF gl_posted_date NOWAIT;
525:
526:
527: -- Get the details like Effective date and Currency Code from the Credit table with the given credit id.
528: CURSOR cur_credit (cp_credit_id igs_fi_applications.credit_id%TYPE ) IS
529: SELECT currency_cd
530: FROM igs_fi_credits
531: WHERE credit_id = cp_credit_id;
532:

Line 536: l_v_cr_account_cd igs_fi_applications.cr_account_cd%TYPE;

532:
533:
534: l_b_exception_flag BOOLEAN := FALSE;
535:
536: l_v_cr_account_cd igs_fi_applications.cr_account_cd%TYPE;
537: l_v_dr_account_cd igs_fi_applications.dr_account_cd%TYPE;
538: l_n_amount igs_fi_applications.amount_applied%TYPE;
539: l_v_posting_rowid ROWID;
540: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

Line 537: l_v_dr_account_cd igs_fi_applications.dr_account_cd%TYPE;

533:
534: l_b_exception_flag BOOLEAN := FALSE;
535:
536: l_v_cr_account_cd igs_fi_applications.cr_account_cd%TYPE;
537: l_v_dr_account_cd igs_fi_applications.dr_account_cd%TYPE;
538: l_n_amount igs_fi_applications.amount_applied%TYPE;
539: l_v_posting_rowid ROWID;
540: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
541: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;

Line 538: l_n_amount igs_fi_applications.amount_applied%TYPE;

534: l_b_exception_flag BOOLEAN := FALSE;
535:
536: l_v_cr_account_cd igs_fi_applications.cr_account_cd%TYPE;
537: l_v_dr_account_cd igs_fi_applications.dr_account_cd%TYPE;
538: l_n_amount igs_fi_applications.amount_applied%TYPE;
539: l_v_posting_rowid ROWID;
540: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
541: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
542:

Line 610: igs_fi_applications_pkg.update_row(

606: p_cr_acc_code => l_v_cr_account_cd,
607: p_src_txn_type => g_application);
608:
609: BEGIN
610: igs_fi_applications_pkg.update_row(
611: x_rowid => app_rec.row_id,
612: x_application_id => app_rec.application_id,
613: x_application_type => app_rec.application_type,
614: x_invoice_id => app_rec.invoice_id,

Line 1038: FROM igs_fi_applications app,

1034: --Cursor to fetch the credit id and invoice id for the passed application id
1035: CURSOR cur_appl(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1036: SELECT crd.credit_number,
1037: inv.invoice_number
1038: FROM igs_fi_applications app,
1039: igs_fi_credits crd,
1040: igs_fi_inv_int inv
1041: WHERE application_id = cp_transaction_id
1042: AND app.credit_id = crd.credit_id

Line 1230: l_d_gl_date_start igs_fI_applications.gl_date%TYPE;

1226: || schodava 8-OCT-2001 Enh # 2030448 (SFCR002)
1227: */
1228:
1229:
1230: l_d_gl_date_start igs_fI_applications.gl_date%TYPE;
1231: l_d_gl_date_end igs_fI_applications.gl_date%TYPE;
1232: l_d_gl_posted_date igs_fI_applications.gl_date%TYPE;
1233: l_org_id VARCHAR2(15);
1234: CURSOR cur_gen_control_id IS

Line 1231: l_d_gl_date_end igs_fI_applications.gl_date%TYPE;

1227: */
1228:
1229:
1230: l_d_gl_date_start igs_fI_applications.gl_date%TYPE;
1231: l_d_gl_date_end igs_fI_applications.gl_date%TYPE;
1232: l_d_gl_posted_date igs_fI_applications.gl_date%TYPE;
1233: l_org_id VARCHAR2(15);
1234: CURSOR cur_gen_control_id IS
1235: SELECT igs_fi_posting_control_s.nextval

Line 1232: l_d_gl_posted_date igs_fI_applications.gl_date%TYPE;

1228:
1229:
1230: l_d_gl_date_start igs_fI_applications.gl_date%TYPE;
1231: l_d_gl_date_end igs_fI_applications.gl_date%TYPE;
1232: l_d_gl_posted_date igs_fI_applications.gl_date%TYPE;
1233: l_org_id VARCHAR2(15);
1234: CURSOR cur_gen_control_id IS
1235: SELECT igs_fi_posting_control_s.nextval
1236: FROM dual;