APPS.FV_SF224_TRANSACTIONS dependencies on FV_INTERAGENCY_FUNDS

Line 77: L_BILLING_AGENCY_FUND FV_INTERAGENCY_FUNDS.BILLING_AGENCY_FUND%TYPE;

73: L_REPORTED_MONTH FV_SF224_TEMP.REPORTED_MONTH%TYPE;
74: L_EXCEPTION_CATEGORY FV_SF224_TEMP.EXCEPTION_CATEGORY%TYPE;
75: L_COLUMN_GROUP NUMBER;
76: L_TXN_CATEGORY FV_SF224_TEMP.TXN_CATEGORY%TYPE;
77: L_BILLING_AGENCY_FUND FV_INTERAGENCY_FUNDS.BILLING_AGENCY_FUND%TYPE;
78:
79: L_BATCH_ID FV_SF224_TEMP.JE_BATCH_ID%TYPE;
80: L_RECORD_TYPE VARCHAR2(30);
81: L_IA_FLAG VARCHAR2(2);

Line 546: FROM fv_interagency_funds_all

542: END IF;
543: BEGIN
544: SELECT 'x'
545: INTO l_exists
546: FROM fv_interagency_funds_all
547: WHERE cash_receipt_id = l_cash_receipt_id;
548: l_inter_agency_flag(i) := 'Y';
549: l_update_type(i) := 'RECEIPT';
550: l_column_group(i) := 21;

Line 562: FROM fv_interagency_funds_all

558: l_cash_receipt_id := l_reference_2(i);
559: BEGIN
560: SELECT 'x'
561: INTO l_exists
562: FROM fv_interagency_funds_all
563: WHERE cash_receipt_id = l_cash_receipt_id;
564: l_inter_agency_flag(i) := 'Y';
565: l_update_type(i) := 'RECEIPT';
566: l_column_group(i) := 21;

Line 583: UPDATE fv_interagency_funds_all

579: IF (p_run_mode = 'F') THEN
580:
581: IF (l_inter_agency_flag(i) = 'Y' and l_reported_month(i) like '%CURRENT%') THEN
582: BEGIN
583: UPDATE fv_interagency_funds_all
584: SET processed_flag = 'Y',
585: period_reported = p_gl_period,
586: last_updated_by = g_user_id,
587: last_update_date = g_sysdate,

Line 595: l_location := l_module_name||'update_fv_interagency_funds_all';

591: EXCEPTION
592: WHEN OTHERS THEN
593: p_error_code := g_FAILURE;
594: p_error_desc := SQLERRM;
595: l_location := l_module_name||'update_fv_interagency_funds_all';
596: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
597: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
598: END;
599: END IF;

Line 3713: FROM fv_interagency_funds_all

3709: l_record_type := 'Receipt';
3710: BEGIN /* B1 */
3711: SELECT 'x'
3712: INTO l_dummy
3713: FROM fv_interagency_funds_all
3714: WHERE cash_receipt_id = l_cash_receipt_id;
3715: l_ia_flag := 'Y';
3716: l_update_type := 'RECEIPT';
3717: EXCEPTION

Line 3745: FROM fv_interagency_funds_all a

3741: IF (l_reclass_receipt_number IS NOT NULL) THEN
3742: BEGIN /* B1 */
3743: SELECT 'x'
3744: INTO l_dummy
3745: FROM fv_interagency_funds_all a
3746: WHERE cash_receipt_id = (SELECT cash_receipt_id
3747: FROM ar_cash_receipts b
3748: WHERE b.receipt_number = l_reclass_receipt_number);
3749: l_ia_flag := 'Y';

Line 4145: FROM fv_interagency_funds_all iaf

4141: IF l_ia_flag = 'Y' THEN
4142: BEGIN
4143: SELECT chargeback_flag, iaf.billing_agency_fund
4144: INTO l_cb_flag, l_billing_agency_fund
4145: FROM fv_interagency_funds_all iaf
4146: WHERE iaf.vendor_id = l_vendor_id
4147: AND iaf.invoice_id = l_invoice_id ;
4148: EXCEPTION
4149: WHEN too_many_rows THEN