APPS.FV_SF224_TRANSACTIONS dependencies on FV_ALC_ADDRESSES_ALL

Line 10: p_business_activity_code IN fv_alc_addresses_all.business_activity_code%TYPE,

6: FUNCTION get_void_check_obligation_date( p_invoice_id NUMBER,
7: p_check_id NUMBER,
8: p_inv_dist_num NUMBER) RETURN DATE;
9: PROCEDURE Check_partial_reporting (
10: p_business_activity_code IN fv_alc_addresses_all.business_activity_code%TYPE,
11: p_gwa_reporter_category_code IN fv_alc_gwa_categories.gwa_reporter_category_code%TYPE,
12: p_error_code OUT NOCOPY NUMBER,
13: p_error_desc OUT NOCOPY VARCHAR2
14: );

Line 163: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;

159: l_start_date_2 gl_periods.start_date%TYPE;
160: l_end_date_2 gl_periods.end_date%TYPE;
161: l_cash_receipt_id NUMBER;
162: l_hi_date DATE := TO_DATE('12/31/9999', 'MM/DD/YYYY');
163: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
164: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
165: l_include_in_report fv_sf224_map.trx_category_coll%TYPE;
166:
167:

Line 2747: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;

2743: l_org_id NUMBER(15);
2744: x_amount NUMBER;
2745: l_void_date DATE;
2746:
2747: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
2748: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
2749: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;
2750:
2751: --Added for reclassification changes

Line 2749: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;

2745: l_void_date DATE;
2746:
2747: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
2748: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
2749: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;
2750:
2751: --Added for reclassification changes
2752: l_void_check_number ap_checks_all.void_check_number%TYPE;
2753: l_voided_reclassified_payment VARCHAR2(1);

Line 4608: p_business_activity_code IN fv_alc_addresses_all.business_activity_code%TYPE,

4604:
4605:
4606: PROCEDURE Check_partial_reporting
4607: (
4608: p_business_activity_code IN fv_alc_addresses_all.business_activity_code%TYPE,
4609: p_gwa_reporter_category_code IN fv_alc_gwa_categories.gwa_reporter_category_code%TYPE,
4610: p_error_code OUT NOCOPY NUMBER,
4611: p_error_desc OUT NOCOPY VARCHAR2
4612: )

Line 4988: -- This procedure check is the ALC address for each ALC code in the FV_ALC_ADDRESSES_ALL Table

4984:
4985: -- End addition
4986:
4987: -- ==============================================================================================
4988: -- This procedure check is the ALC address for each ALC code in the FV_ALC_ADDRESSES_ALL Table
4989: -- If atleast address for one ALC code does not exist the status of the Concurrent program is set
4990: -- as Warning and all the ALCs with out address are displayed in the Con Log
4991: -- ==============================================================================================
4992: PROCEDURE check_alc_address

Line 5015: FROM fv_alc_addresses_all

5011: FOR alc_code_rec IN alc_code_csr LOOP
5012: BEGIN
5013: SELECT 1
5014: INTO l_count
5015: FROM fv_alc_addresses_all
5016: WHERE AGENCY_LOCATION_CODE = alc_code_rec.alc_code
5017: AND set_of_books_id = sob;
5018: EXCEPTION
5019: WHEN NO_DATA_FOUND THEN

Line 5034: FROM fv_alc_addresses_all

5030: ELSE /* when p_alc is not 'ALL' */
5031: BEGIN
5032: SELECT 1
5033: INTO l_count
5034: FROM fv_alc_addresses_all
5035: WHERE AGENCY_LOCATION_CODE = p_alc
5036: AND set_of_books_id = sob;
5037: EXCEPTION
5038: WHEN NO_DATA_FOUND THEN