APPS.JE_GR_STATUTORY dependencies on GL_JE_BATCHES

Line 25: gl_je_batches jb

21: gl_sets_of_books sob,
22: fnd_doc_sequence_categories doc,
23: fnd_application a,
24: gl_je_headers jh,
25: gl_je_batches jb
26: WHERE
27: jb.actual_flag = 'A' AND
28: jb.posting_run_id = c_posting_run_id AND
29: jh.je_batch_id = jb.je_batch_id AND

Line 39: v_pkg_batch_id GL_JE_BATCHES.je_batch_id%TYPE;

35: sob.set_of_books_id = jh.ledger_id; --??
36: --
37: -- Fetch variables
38: --
39: v_pkg_batch_id GL_JE_BATCHES.je_batch_id%TYPE;
40: v_pkg_header_id GL_JE_HEADERS.je_header_id%TYPE;
41: v_pkg_trx_date DATE;
42: v_pkg_last_batch_id GL_JE_BATCHES.je_batch_id%TYPE := 0;
43: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;

Line 42: v_pkg_last_batch_id GL_JE_BATCHES.je_batch_id%TYPE := 0;

38: --
39: v_pkg_batch_id GL_JE_BATCHES.je_batch_id%TYPE;
40: v_pkg_header_id GL_JE_HEADERS.je_header_id%TYPE;
41: v_pkg_trx_date DATE;
42: v_pkg_last_batch_id GL_JE_BATCHES.je_batch_id%TYPE := 0;
43: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
44: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;
45: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE; --??
46: --v_pkg_global_attribute GL_SETS_OF_BOOKS.global_attribute1%TYPE;

Line 255: UPDATE gl_je_batches

251: IF ((v_seq_value is NULL) or (v_sequence_id is NULL)) THEN
252: --
253: -- Set error status
254: --
255: UPDATE gl_je_batches
256: SET status = '<'
257: WHERE je_batch_id = v_pkg_batch_id;
258:
259: UPDATE gl_je_headers

Line 444: UPDATE gl_je_batches

440: -- Set error status
441: --
442:
443: IF (p_retcode < 0) THEN
444: UPDATE gl_je_batches
445: SET status = '>'
446: WHERE je_batch_id = v_pkg_batch_id;
447:
448: UPDATE gl_je_headers