eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_JRCFI_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 313: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',

309: -- add the XML tags
310:
311: FOR v_row IN journal_cash_flow_items_cur(ln_cash_flow_item_rule) LOOP
312: ln_row_count := ln_row_count + 1;
313: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
314: Ja_Cn_Utility.GV_TAG_TYPE_START);
315:
316: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
317: v_row.je_category);

Line 314: Ja_Cn_Utility.GV_TAG_TYPE_START);

310:
311: FOR v_row IN journal_cash_flow_items_cur(ln_cash_flow_item_rule) LOOP
312: ln_row_count := ln_row_count + 1;
313: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
314: Ja_Cn_Utility.GV_TAG_TYPE_START);
315:
316: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
317: v_row.je_category);
318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);

Line 316: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',

312: ln_row_count := ln_row_count + 1;
313: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
314: Ja_Cn_Utility.GV_TAG_TYPE_START);
315:
316: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
317: v_row.je_category);
318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);
319: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',
320: v_row.original_curr_code);

Line 318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);

314: Ja_Cn_Utility.GV_TAG_TYPE_START);
315:
316: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
317: v_row.je_category);
318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);
319: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',
320: v_row.original_curr_code);
321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);
322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',

Line 319: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',

315:
316: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
317: v_row.je_category);
318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);
319: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',
320: v_row.original_curr_code);
321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);
322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',
323: v_row.description);

Line 321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);

317: v_row.je_category);
318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);
319: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',
320: v_row.original_curr_code);
321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);
322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',
323: v_row.description);
324: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', v_row.axis_seq);
325: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',

Line 322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',

318: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', v_row.journal_number);
319: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',
320: v_row.original_curr_code);
321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);
322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',
323: v_row.description);
324: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', v_row.axis_seq);
325: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
326: v_row.item_attribute,

Line 324: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', v_row.axis_seq);

320: v_row.original_curr_code);
321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);
322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',
323: v_row.description);
324: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', v_row.axis_seq);
325: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
326: v_row.item_attribute,
327: 1);
328: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',

Line 325: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',

321: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', ln_row_count);
322: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION',
323: v_row.description);
324: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', v_row.axis_seq);
325: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
326: v_row.item_attribute,
327: 1);
328: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
329: v_row.original_amount,

Line 328: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',

324: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', v_row.axis_seq);
325: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
326: v_row.item_attribute,
327: 1);
328: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
329: v_row.original_amount,
330: Ja_Cn_Utility.GV_TYPE_NUMBER);
331: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
332: v_row.func_amount,

Line 330: Ja_Cn_Utility.GV_TYPE_NUMBER);

326: v_row.item_attribute,
327: 1);
328: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
329: v_row.original_amount,
330: Ja_Cn_Utility.GV_TYPE_NUMBER);
331: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
332: v_row.func_amount,
333: Ja_Cn_Utility.GV_TYPE_NUMBER);
334:

Line 331: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',

327: 1);
328: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
329: v_row.original_amount,
330: Ja_Cn_Utility.GV_TYPE_NUMBER);
331: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
332: v_row.func_amount,
333: Ja_Cn_Utility.GV_TYPE_NUMBER);
334:
335: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',

Line 333: Ja_Cn_Utility.GV_TYPE_NUMBER);

329: v_row.original_amount,
330: Ja_Cn_Utility.GV_TYPE_NUMBER);
331: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
332: v_row.func_amount,
333: Ja_Cn_Utility.GV_TYPE_NUMBER);
334:
335: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
336: Ja_Cn_Utility.GV_TAG_TYPE_END);
337: END LOOP; --v_row IN journal_cash_flow_items_cur(ln_cash_flow_item_rule)

Line 335: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',

331: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
332: v_row.func_amount,
333: Ja_Cn_Utility.GV_TYPE_NUMBER);
334:
335: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
336: Ja_Cn_Utility.GV_TAG_TYPE_END);
337: END LOOP; --v_row IN journal_cash_flow_items_cur(ln_cash_flow_item_rule)
338:
339: -- if the row count is 0

Line 336: Ja_Cn_Utility.GV_TAG_TYPE_END);

332: v_row.func_amount,
333: Ja_Cn_Utility.GV_TYPE_NUMBER);
334:
335: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
336: Ja_Cn_Utility.GV_TAG_TYPE_END);
337: END LOOP; --v_row IN journal_cash_flow_items_cur(ln_cash_flow_item_rule)
338:
339: -- if the row count is 0
340: -- no need to handle if minOccurs=0 specified in xml schema

Line 342: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_JOURNAL_ITEM_DATA');

338:
339: -- if the row count is 0
340: -- no need to handle if minOccurs=0 specified in xml schema
341: IF (ln_row_count = 0) THEN
342: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_JOURNAL_ITEM_DATA');
343:
344: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
345: Ja_Cn_Utility.GV_TAG_TYPE_START);
346:

Line 344: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',

340: -- no need to handle if minOccurs=0 specified in xml schema
341: IF (ln_row_count = 0) THEN
342: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_JOURNAL_ITEM_DATA');
343:
344: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
345: Ja_Cn_Utility.GV_TAG_TYPE_START);
346:
347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);

Line 345: Ja_Cn_Utility.GV_TAG_TYPE_START);

341: IF (ln_row_count = 0) THEN
342: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_JOURNAL_ITEM_DATA');
343:
344: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
345: Ja_Cn_Utility.GV_TAG_TYPE_START);
346:
347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);

Line 347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);

343:
344: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
345: Ja_Cn_Utility.GV_TAG_TYPE_START);
346:
347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);

Line 348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);

344: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
345: Ja_Cn_Utility.GV_TAG_TYPE_START);
346:
347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);
352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);

Line 349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);

345: Ja_Cn_Utility.GV_TAG_TYPE_START);
346:
347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);
352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);
353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',

Line 350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);

346:
347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);
352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);
353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
354: NULL,

Line 351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);

347: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);
352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);
353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
354: NULL,
355: 1);

Line 352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);

348: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER', NULL);
349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);
352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);
353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
354: NULL,
355: 1);
356: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',

Line 353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',

349: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE', NULL);
350: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_LINE_NUMBER', NULL);
351: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_DESCRIPTION', NULL);
352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);
353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
354: NULL,
355: 1);
356: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
357: NULL,

Line 356: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',

352: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ITEM_NUMBER', NULL);
353: Ja_Cn_Utility.Add_Fixed_Child_Node('CASH_FLOW_ITEM_ATTRIBUTE',
354: NULL,
355: 1);
356: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
357: NULL,
358: Ja_Cn_Utility.GV_TYPE_NUMBER);
359: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
360: NULL,

Line 358: Ja_Cn_Utility.GV_TYPE_NUMBER);

354: NULL,
355: 1);
356: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
357: NULL,
358: Ja_Cn_Utility.GV_TYPE_NUMBER);
359: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
360: NULL,
361: Ja_Cn_Utility.GV_TYPE_NUMBER);
362:

Line 359: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',

355: 1);
356: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_ENTERED_AMOUNT',
357: NULL,
358: Ja_Cn_Utility.GV_TYPE_NUMBER);
359: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
360: NULL,
361: Ja_Cn_Utility.GV_TYPE_NUMBER);
362:
363: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',

Line 361: Ja_Cn_Utility.GV_TYPE_NUMBER);

357: NULL,
358: Ja_Cn_Utility.GV_TYPE_NUMBER);
359: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
360: NULL,
361: Ja_Cn_Utility.GV_TYPE_NUMBER);
362:
363: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
364: Ja_Cn_Utility.GV_TAG_TYPE_END);
365: END IF; --(ln_row_count = 0)

Line 363: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',

359: Ja_Cn_Utility.Add_Child_Node('CASH_FLOW_FUNCTIONAL_AMOUNT',
360: NULL,
361: Ja_Cn_Utility.GV_TYPE_NUMBER);
362:
363: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
364: Ja_Cn_Utility.GV_TAG_TYPE_END);
365: END IF; --(ln_row_count = 0)
366:
367: --logging for debug

Line 364: Ja_Cn_Utility.GV_TAG_TYPE_END);

360: NULL,
361: Ja_Cn_Utility.GV_TYPE_NUMBER);
362:
363: Ja_Cn_Utility.Add_Sub_Root_Node('CASH_FLOW_JOURNAL_ITEM_DATA',
364: Ja_Cn_Utility.GV_TAG_TYPE_END);
365: END IF; --(ln_row_count = 0)
366:
367: --logging for debug
368: IF (ln_proc_level >= ln_dbg_level) THEN