DBA Data[Home] [Help]

APPS.AP_WEB_OA_DISC_PKG dependencies on AP_WEB_DISC_HEADERS_GT

Line 491: DELETE FROM ap_web_disc_headers_gt;

487: BEGIN
488: -----------------------------------------
489: l_debug_info := 'Delete existing data in temporary files';
490: ------------------------------------------
491: DELETE FROM ap_web_disc_headers_gt;
492: DELETE FROM ap_web_disc_lines_gt;
493:
494: -----------------------------------------
495: l_debug_info := 'Insert header into temporary table';

Line 497: INSERT INTO ap_web_disc_headers_gt (EMPLOYEE_ID,

493:
494: -----------------------------------------
495: l_debug_info := 'Insert header into temporary table';
496: ------------------------------------------
497: INSERT INTO ap_web_disc_headers_gt (EMPLOYEE_ID,
498: COST_CENTER,
499: TEMPLATE_ID,
500: PURPOSE,
501: REIMBURSEMENT_CURRENCY_CODE,

Line 616: DELETE FROM ap_web_disc_headers_gt;

612:
613: COMMIT;
614: EXCEPTION
615: WHEN OTHERS THEN
616: DELETE FROM ap_web_disc_headers_gt;
617: DELETE FROM ap_web_disc_lines_gt;
618: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
619: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');