DBA Data[Home] [Help]

APPS.GL_IMPORT_REFERENCES_PKG dependencies on GL_JE_HEADERS

Line 31: is deleted gl_je_headers */

27: END delete_lines;
28:
29: PROCEDURE delete_header(X_header_id NUMBER ) IS
30: /* It Deletes a header in gl_import_references while a header
31: is deleted gl_je_headers */
32: BEGIN
33: DELETE FROM GL_IMPORT_REFERENCES
34: WHERE je_header_id = X_header_id;
35:

Line 47: (select je_header_id FROM gl_je_headers WHERE je_batch_id = X_batch_id );

43: is deleted in gl_je_batches*/
44: BEGIN
45: DELETE FROM GL_IMPORT_REFERENCES
46: WHERE je_header_id IN
47: (select je_header_id FROM gl_je_headers WHERE je_batch_id = X_batch_id );
48:
49: EXCEPTION
50: WHEN NO_DATA_FOUND then
51: null;