DBA Data[Home] [Help]

APPS.JE_GR_STATUTORY dependencies on GL_JE_HEADERS

Line 24: gl_je_headers jh,

20: FROM
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

Line 40: v_pkg_header_id GL_JE_HEADERS.je_header_id%TYPE;

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;
44: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;

Line 259: UPDATE gl_je_headers

255: UPDATE gl_je_batches
256: SET status = '<'
257: WHERE je_batch_id = v_pkg_batch_id;
258:
259: UPDATE gl_je_headers
260: SET status = '<'
261: WHERE je_header_id = v_pkg_header_id;
262: --
263: -- Close cursor and re-open cursor to continue processing with next batch

Line 287: UPDATE gl_je_headers

283: v_je_header_id_flag := 1;
284: end;
285:
286: if v_je_header_id_flag =1 then
287: UPDATE gl_je_headers
288: SET global_attribute_category = v_je_attribute_category,
289: -- ** global_attribute1 = v_sequence_name,
290: -- ** global_attribute2 = v_seq_val,
291: external_reference = DECODE(v_pkg_append_sequence,

Line 450: UPDATE gl_je_headers

446: UPDATE gl_je_batches
447: SET status = '>'
448: WHERE je_batch_id = v_pkg_batch_id;
449:
450: UPDATE gl_je_headers
451: SET status = '>'
452: WHERE je_header_id = v_pkg_header_id;
453: --
454: -- Close cursor and re-open cursor to continue processing with