DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_AP_ETDS_T

Line 2205: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS

2201: replace(postal_code, ' ') postal_code
2202: FROM hr_locations_all
2203: WHERE location_id = p_location_id;
2204:
2205: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
2206: Select Error_Message from jai_ap_etds_errors_t
2207: where batch_id = cp_batch_id ;
2208:
2209: ln_errors_exist number ;

Line 2690: SELECT JAI_AP_ETDS_T_S.nextval INTO ln_batch_id FROM DUAL;

2686: BEGIN
2687: lv_dummy_date := TO_DATE('01/01/1600', 'DD/MM/RRRR');
2688:
2689: v_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
2690: SELECT JAI_AP_ETDS_T_S.nextval INTO ln_batch_id FROM DUAL;
2691: v_line_number := 0;
2692:
2693:
2694: IF NVL(p_period,'XX') = 'XX' THEN