[Home] [Help]
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: );
15:
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:
168: CURSOR current_224_cur
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
2880: l_void_check_number ap_checks_all.void_check_number%TYPE;
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: )
4751: IS