DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_AP_ETDS_T

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

2661: replace(postal_code, ' ') postal_code
2662: FROM hr_locations_all
2663: WHERE location_id = p_location_id;
2664:
2665: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
2666: Select Error_Message from jai_ap_etds_errors_t
2667: where batch_id = cp_batch_id ;
2668:
2669: ln_errors_exist number ;

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

3192: BEGIN
3193: lv_dummy_date := TO_DATE('01/01/1600', 'DD/MM/RRRR');
3194:
3195: v_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
3196: SELECT JAI_AP_ETDS_T_S.nextval INTO ln_batch_id FROM DUAL;
3197: v_line_number := 0;
3198:
3199:
3200: IF NVL(p_period,'XX') = 'XX' THEN