APPS.FV_1219_TRANSACTIONS dependencies on FV_INTERAGENCY_FUNDS_ALL

Line 72: l_cb_flag FV_INTERAGENCY_FUNDS_ALL.chargeback_flag%TYPE;

68:
69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
71: l_payables_ia_paygroup FV_OPERATING_UNITS_ALL.payables_ia_paygroup%TYPE;
72: l_cb_flag FV_INTERAGENCY_FUNDS_ALL.chargeback_flag%TYPE;
73: l_billing_agency_fund FV_INTERAGENCY_FUNDS_ALL.billing_agency_fund%TYPE;
74: l_dit_flag varchar2(2);
75: l_error_stage number;
76: l_inv_amount number;

Line 73: l_billing_agency_fund FV_INTERAGENCY_FUNDS_ALL.billing_agency_fund%TYPE;

69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
71: l_payables_ia_paygroup FV_OPERATING_UNITS_ALL.payables_ia_paygroup%TYPE;
72: l_cb_flag FV_INTERAGENCY_FUNDS_ALL.chargeback_flag%TYPE;
73: l_billing_agency_fund FV_INTERAGENCY_FUNDS_ALL.billing_agency_fund%TYPE;
74: l_dit_flag varchar2(2);
75: l_error_stage number;
76: l_inv_amount number;
77: l_yr_start_date date;

Line 496: -- fv_interagency_funds_all and fv_refunds_voids_all tables.

492: -- JE Batches, which exists in Audit table, are omitted. Also, only those
493: -- accounts of JE lines are selected which have been setup by user in the
494: -- Accounts setup table.
495: -- Update_type and type are required to set 'processed flag' in
496: -- fv_interagency_funds_all and fv_refunds_voids_all tables.
497: ----------------------------------------------------------------------------
498: PROCEDURE INSERT_BATCHES IS
499: l_module_name VARCHAR2(200) := g_module_name || 'INSERT_BATCHES';
500: no_of_tran number := 0;

Line 3178: FROM FV_INTERAGENCY_FUNDS_ALL

3174:
3175: BEGIN
3176: SELECT 'X'
3177: INTO null_var
3178: FROM FV_INTERAGENCY_FUNDS_ALL
3179: WHERE cash_receipt_id = l_cash_receipt_id
3180: and org_id = p_def_org_id;
3181:
3182: l_inter_agency_flag := 'Y';

Line 3459: FROM fv_interagency_funds_all iaf

3455: SELECT chargeback_flag,
3456: iaf.billing_agency_fund
3457: INTO l_cb_flag,
3458: l_billing_agency_fund
3459: FROM fv_interagency_funds_all iaf
3460: WHERE iaf.vendor_id = l_vendor_id
3461: AND iaf.invoice_id = l_invoice_id
3462: AND iaf.org_id = p_def_org_id;
3463: EXCEPTION

Line 4516: -- Also, it sets the processed_flag to 'Y' for fv_interagency_funds_all and

4512: -- 1219/1220 report, only when report is run in Final mode. The procedure
4513: -- inserts records from FV_SF1219_TEMP table to FV_SF1219_AUDITS table, which
4514: -- have reported_month as 'CURRENT' or 'CURRENT / PRIOR', and org id is not null.
4515: -- These batches are excluded for any subsequent run.
4516: -- Also, it sets the processed_flag to 'Y' for fv_interagency_funds_all and
4517: -- fv_refunds_voids_all tables.
4518:
4519: -- For this procedure p_gl_period format needs to be same as gl_period which
4520: -- is varchar2(15)

Line 4707: UPDATE fv_interagency_funds_all

4703: BEGIN
4704: IF (l2_inter_agency_flag = 'Y' AND
4705: l2_reported_month LIKE '%CURRENT%') THEN
4706:
4707: UPDATE fv_interagency_funds_all
4708: SET processed_flag = 'Y',
4709: period_reported = l2_gl_period_name
4710: WHERE decode(l2_update_type, 'RECEIPT',
4711: cash_receipt_id, invoice_id)