APPS.JE_GR_STATUTORY dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 22: fnd_doc_sequence_categories doc,

18: -- nvl(sob.global_attribute2, 'N'),
19: -- nvl(sob.global_attribute3, 'N')
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

Line 43: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;

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;
47: v_pkg_sequence_ax_journals VARCHAR2(150);

Line 44: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_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;
47: v_pkg_sequence_ax_journals VARCHAR2(150);
48: v_pkg_append_sequence VARCHAR2(150);

Line 77: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;

73: enabled_flag
74: FROM je_gr_cutoff_rules;
75:
76: idx BINARY_INTEGER;
77: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
78: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;
79: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
80: v_days JE_GR_CUTOFF_RULES.days%TYPE;
81: v_violation_response JE_GR_CUTOFF_RULES.violation_response%TYPE;

Line 78: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;

74: FROM je_gr_cutoff_rules;
75:
76: idx BINARY_INTEGER;
77: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
78: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;
79: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
80: v_days JE_GR_CUTOFF_RULES.days%TYPE;
81: v_violation_response JE_GR_CUTOFF_RULES.violation_response%TYPE;
82: v_enabled_flag JE_GR_CUTOFF_RULES.enabled_flag%TYPE;