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 2875: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;

2871: l_org_id NUMBER(15);
2872: x_amount NUMBER;
2873: l_void_date DATE;
2874:
2875: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
2876: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
2877: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;
2878:
2879: --Added for reclassification changes

Line 2877: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;

2873: l_void_date DATE;
2874:
2875: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
2876: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
2877: l_alc_addresses_id fv_alc_addresses_all.fv_alc_addresses_id%TYPE;
2878:
2879: --Added for reclassification changes
2880: l_void_check_number ap_checks_all.void_check_number%TYPE;
2881: l_voided_reclassified_payment VARCHAR2(1);

Line 4746: p_business_activity_code IN fv_alc_addresses_all.business_activity_code%TYPE,

4742:
4743:
4744: PROCEDURE Check_partial_reporting
4745: (
4746: p_business_activity_code IN fv_alc_addresses_all.business_activity_code%TYPE,
4747: p_gwa_reporter_category_code IN fv_alc_gwa_categories.gwa_reporter_category_code%TYPE,
4748: p_error_code OUT NOCOPY NUMBER,
4749: p_error_desc OUT NOCOPY VARCHAR2
4750: )

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

5122:
5123: -- End addition
5124:
5125: -- ==============================================================================================
5126: -- This procedure check is the ALC address for each ALC code in the FV_ALC_ADDRESSES_ALL Table
5127: -- If atleast address for one ALC code does not exist the status of the Concurrent program is set
5128: -- as Warning and all the ALCs with out address are displayed in the Con Log
5129: -- ==============================================================================================
5130: PROCEDURE check_alc_address

Line 5153: FROM fv_alc_addresses_all

5149: FOR alc_code_rec IN alc_code_csr LOOP
5150: BEGIN
5151: SELECT 1
5152: INTO l_count
5153: FROM fv_alc_addresses_all
5154: WHERE AGENCY_LOCATION_CODE = alc_code_rec.alc_code
5155: AND set_of_books_id = sob;
5156: EXCEPTION
5157: WHEN NO_DATA_FOUND THEN

Line 5172: FROM fv_alc_addresses_all

5168: ELSE /* when p_alc is not 'ALL' */
5169: BEGIN
5170: SELECT 1
5171: INTO l_count
5172: FROM fv_alc_addresses_all
5173: WHERE AGENCY_LOCATION_CODE = p_alc
5174: AND set_of_books_id = sob;
5175: EXCEPTION
5176: WHEN NO_DATA_FOUND THEN