APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on GL_JE_LINES

Line 1200: -- set a flag 'P' for journals in table gl_je_lines to identify them as

1196: -- FUNCTION NAME:
1197: -- Set_flag_P Public
1198: --
1199: -- DESCRIPTION:
1200: -- set a flag 'P' for journals in table gl_je_lines to identify them as
1201: -- processed journal according to the paramter input.
1202: --
1203: -- PARAMETERS:
1204: -- P_LEDGER_ID ledger id

Line 1296: ' ,gl_je_lines jel' ||

1292: -- ' ,bsv.legal_entity_id' || ',' ||
1293:
1294: -- ',jeh.default_effective_date ' ||
1295: ' FROM gl_je_headers jeh' ||
1296: ' ,gl_je_lines jel' ||
1297: ' ,gl_code_combinations gcc' ||
1298: ' ,gl_periods gp' ||
1299: ' ,gl_ledgers led' ||
1300: ' ,ja_cn_ledger_le_bsv_gt bsv' ||

Line 1327: -- set all the journal found in gl_je_lines as processed journal lines.

1323: ' AND led.ledger_id = jeh.ledger_id' ||
1324: ' AND nvl(jel.global_attribute2' ||
1325: ' ,''U'') <> ''P''';
1326:
1327: -- set all the journal found in gl_je_lines as processed journal lines.
1328: OPEN c_journal FOR l_Populate_Journal_Sql;
1329: loop
1330: fetch c_journal into l_header_id,l_line_num;
1331: EXIT WHEN c_journal%NOTFOUND;

Line 1332: update gl_je_lines

1328: OPEN c_journal FOR l_Populate_Journal_Sql;
1329: loop
1330: fetch c_journal into l_header_id,l_line_num;
1331: EXIT WHEN c_journal%NOTFOUND;
1332: update gl_je_lines
1333: set global_attribute2='P'
1334: where je_header_id=l_header_id
1335: and je_line_num=l_line_num;
1336: end loop;

Line 2209: --set a flag 'P' for journals in table gl_je_lines to identify them as processed journal.

2205: 'fail to populate BSV');
2206: END IF; --(l_proc_level >= l_dbg_level)
2207: END IF;
2208:
2209: --set a flag 'P' for journals in table gl_je_lines to identify them as processed journal.
2210:
2211: set_flag_p( l_ledger_id ,
2212: l_legal_entity_id,
2213: l_period_from,