DBA Data[Home] [Help]

APPS.JG_CREATE_JOURNALS_PKG dependencies on GL_JE_LINES

Line 104: REFERENCE21, -- GL_JE_LINES.reference_1

100: REFERENCE4, -- Header Name
101: REFERENCE5, -- Header Description
102: REFERENCE6, -- Header Reference
103: REFERENCE10, -- Line Description
104: REFERENCE21, -- GL_JE_LINES.reference_1
105: REFERENCE22, -- GL_JE_LINES.reference_2
106: STAT_AMOUNT,
107: SUBLEDGER_DOC_SEQUENCE_ID,
108: SUBLEDGER_DOC_SEQUENCE_VALUE,

Line 105: REFERENCE22, -- GL_JE_LINES.reference_2

101: REFERENCE5, -- Header Description
102: REFERENCE6, -- Header Reference
103: REFERENCE10, -- Line Description
104: REFERENCE21, -- GL_JE_LINES.reference_1
105: REFERENCE22, -- GL_JE_LINES.reference_2
106: STAT_AMOUNT,
107: SUBLEDGER_DOC_SEQUENCE_ID,
108: SUBLEDGER_DOC_SEQUENCE_VALUE,
109: ATTRIBUTE1,

Line 315: REFERENCE21, -- GL_JE_LINES.reference_1

311: REFERENCE4, -- Header Name
312: REFERENCE5, -- Header Description
313: REFERENCE6, -- Header Reference
314: REFERENCE10, -- Line Description
315: REFERENCE21, -- GL_JE_LINES.reference_1
316: REFERENCE22, -- GL_JE_LINES.reference_2
317: STAT_AMOUNT,
318: SUBLEDGER_DOC_SEQUENCE_ID,
319: SUBLEDGER_DOC_SEQUENCE_VALUE,

Line 316: REFERENCE22, -- GL_JE_LINES.reference_2

312: REFERENCE5, -- Header Description
313: REFERENCE6, -- Header Reference
314: REFERENCE10, -- Line Description
315: REFERENCE21, -- GL_JE_LINES.reference_1
316: REFERENCE22, -- GL_JE_LINES.reference_2
317: STAT_AMOUNT,
318: SUBLEDGER_DOC_SEQUENCE_ID,
319: SUBLEDGER_DOC_SEQUENCE_VALUE,
320: ATTRIBUTE1,

Line 693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;

689: rule_line_id RULE_LINE_ID
690: FROM jg_zz_ta_rule_lines
691: WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;

Line 694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;

690: FROM jg_zz_ta_rule_lines
691: WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
698: l_first_alloc_for_jrnal NUMBER;

Line 695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;

691: WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
698: l_first_alloc_for_jrnal NUMBER;
699: l_max_prc_alloc_for_jrnal NUMBER := 0;

Line 696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;

692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
698: l_first_alloc_for_jrnal NUMBER;
699: l_max_prc_alloc_for_jrnal NUMBER := 0;
700: l_is_max_prc_alloc_line BOOLEAN := FALSE;