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_AP_VALIDATION_PKG dependencies on DUAL

Line 414: FROM DUAL;

410: --for period from
411: SELECT XMLELEMENT("PV_PERIOD_FROM",
412: pv_period_from)
413: INTO L_XML_ITEM
414: FROM DUAL;
415: L_XML_PARAMETER := L_XML_ITEM;
416: --for period to
417: SELECT XMLELEMENT("PV_PERIOD_TO",
418: pv_period_to)

Line 420: FROM DUAL;

416: --for period to
417: SELECT XMLELEMENT("PV_PERIOD_TO",
418: pv_period_to)
419: INTO L_XML_ITEM
420: FROM DUAL;
421: SELECT XMLCONCAT(L_XML_PARAMETER,
422: L_XML_ITEM)
423: INTO L_XML_PARAMETER
424: FROM DUAL;

Line 424: FROM DUAL;

420: FROM DUAL;
421: SELECT XMLCONCAT(L_XML_PARAMETER,
422: L_XML_ITEM)
423: INTO L_XML_PARAMETER
424: FROM DUAL;
425: --for accounting year
426: SELECT XMLELEMENT("PV_ACCOUNTING_YEAR",
427: pv_accounting_year)
428: INTO L_XML_ITEM

Line 429: FROM DUAL;

425: --for accounting year
426: SELECT XMLELEMENT("PV_ACCOUNTING_YEAR",
427: pv_accounting_year)
428: INTO L_XML_ITEM
429: FROM DUAL;
430: SELECT XMLCONCAT(L_XML_PARAMETER,
431: L_XML_ITEM)
432: INTO L_XML_PARAMETER
433: FROM DUAL;

Line 433: FROM DUAL;

429: FROM DUAL;
430: SELECT XMLCONCAT(L_XML_PARAMETER,
431: L_XML_ITEM)
432: INTO L_XML_PARAMETER
433: FROM DUAL;
434: --for ledger name
435: SELECT XMLELEMENT("PV_LEDGER_NAME",
436: lv_ledger_name)
437: INTO L_XML_ITEM

Line 438: FROM DUAL;

434: --for ledger name
435: SELECT XMLELEMENT("PV_LEDGER_NAME",
436: lv_ledger_name)
437: INTO L_XML_ITEM
438: FROM DUAL;
439: SELECT XMLCONCAT(L_XML_PARAMETER,
440: L_XML_ITEM)
441: INTO L_XML_PARAMETER
442: FROM DUAL;

Line 442: FROM DUAL;

438: FROM DUAL;
439: SELECT XMLCONCAT(L_XML_PARAMETER,
440: L_XML_ITEM)
441: INTO L_XML_PARAMETER
442: FROM DUAL;
443: --for legal entity
444: SELECT XMLELEMENT("PV_LEGAL_ENTITY",
445: lv_le_name)
446: INTO L_XML_ITEM

Line 447: FROM DUAL;

443: --for legal entity
444: SELECT XMLELEMENT("PV_LEGAL_ENTITY",
445: lv_le_name)
446: INTO L_XML_ITEM
447: FROM DUAL;
448: SELECT XMLCONCAT(L_XML_PARAMETER,
449: L_XML_ITEM)
450: INTO L_XML_PARAMETER
451: FROM DUAL;

Line 451: FROM DUAL;

447: FROM DUAL;
448: SELECT XMLCONCAT(L_XML_PARAMETER,
449: L_XML_ITEM)
450: INTO L_XML_PARAMETER
451: FROM DUAL;
452:
453: SELECT XMLCONCAT(L_XML_PARAMETER,
454: L_XML_REPORT)
455: INTO L_XML_REPORT

Line 456: FROM DUAL;

452:
453: SELECT XMLCONCAT(L_XML_PARAMETER,
454: L_XML_REPORT)
455: INTO L_XML_REPORT
456: FROM DUAL;
457:
458: --Step2: BSV part
459: L_XML_ITEM := NULL;
460:

Line 469: FROM DUAL;

465:
466: SELECT XMLELEMENT("PV_BSV_ROW_NAME",
467: Fnd_Message.Get)
468: INTO L_XML_ITEM
469: FROM DUAL;
470: SELECT XMLCONCAT(L_XML_REPORT,
471: L_XML_ITEM)
472: INTO L_XML_REPORT
473: FROM DUAL;

Line 473: FROM DUAL;

469: FROM DUAL;
470: SELECT XMLCONCAT(L_XML_REPORT,
471: L_XML_ITEM)
472: INTO L_XML_REPORT
473: FROM DUAL;
474:
475: FOR v_invalid_bsv_inv_row IN invalid_bsv_inv_cur
476: LOOP
477: L_XML_ROW := NULL;

Line 483: FROM DUAL;

479: --for period name
480: SELECT XMLELEMENT("PV_PERIOD_NAME",
481: v_invalid_bsv_inv_row.Period_Name)
482: INTO L_XML_ITEM
483: FROM DUAL;
484: L_XML_ROW_ITEMS := L_XML_ITEM;
485:
486: --for supplier
487: lv_supplier_name := Get_Supplier_Name(v_invalid_bsv_inv_row.Supplier_Name

Line 493: FROM DUAL;

489: ,pn_ledger_id);
490: SELECT XMLELEMENT("PV_SUPPLIER_NAME",
491: lv_supplier_name)
492: INTO L_XML_ITEM
493: FROM DUAL;
494: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
495: L_XML_ITEM)
496: INTO L_XML_ROW_ITEMS
497: FROM DUAL;

Line 497: FROM DUAL;

493: FROM DUAL;
494: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
495: L_XML_ITEM)
496: INTO L_XML_ROW_ITEMS
497: FROM DUAL;
498:
499: --for invoice number
500: SELECT XMLELEMENT("PV_INVOICE_NUMBER",
501: v_invalid_bsv_inv_row.Invoice_Number)

Line 503: FROM DUAL;

499: --for invoice number
500: SELECT XMLELEMENT("PV_INVOICE_NUMBER",
501: v_invalid_bsv_inv_row.Invoice_Number)
502: INTO L_XML_ITEM
503: FROM DUAL;
504: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
505: L_XML_ITEM)
506: INTO L_XML_ROW_ITEMS
507: FROM DUAL;

Line 507: FROM DUAL;

503: FROM DUAL;
504: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
505: L_XML_ITEM)
506: INTO L_XML_ROW_ITEMS
507: FROM DUAL;
508:
509: --for legal entity in invoice
510: FOR v_legal_entity_row IN legal_entity_cur(v_invalid_bsv_inv_row.Bal_Seg_Value)
511: LOOP

Line 515: FROM DUAL;

511: LOOP
512: SELECT XMLELEMENT("PV_LEGAL_ENTITY",
513: v_legal_entity_row.Legal_Entity)
514: INTO L_XML_ITEM
515: FROM DUAL;
516: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
517: L_XML_ITEM)
518: INTO L_XML_ROW_ITEMS
519: FROM DUAL;

Line 519: FROM DUAL;

515: FROM DUAL;
516: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
517: L_XML_ITEM)
518: INTO L_XML_ROW_ITEMS
519: FROM DUAL;
520: EXIT;
521: END LOOP;
522:
523: SELECT XMLELEMENT("ROW_BSV",

Line 526: FROM DUAL;

522:
523: SELECT XMLELEMENT("ROW_BSV",
524: L_XML_ROW_ITEMS)
525: INTO L_XML_ROW
526: FROM DUAL;
527: SELECT XMLCONCAT(L_XML_REPORT,
528: L_XML_ROW)
529: INTO L_XML_REPORT
530: FROM DUAL;

Line 530: FROM DUAL;

526: FROM DUAL;
527: SELECT XMLCONCAT(L_XML_REPORT,
528: L_XML_ROW)
529: INTO L_XML_REPORT
530: FROM DUAL;
531: END LOOP;
532:
533: --for row name in un-itemized part
534: L_XML_ITEM := NULL;

Line 542: FROM DUAL;

538:
539: SELECT XMLELEMENT("PV_UNITEMIZED_ROW_NAME",
540: Fnd_Message.Get)
541: INTO L_XML_ITEM
542: FROM DUAL;
543: SELECT XMLCONCAT(L_XML_REPORT,
544: L_XML_ITEM)
545: INTO L_XML_REPORT
546: FROM DUAL;

Line 546: FROM DUAL;

542: FROM DUAL;
543: SELECT XMLCONCAT(L_XML_REPORT,
544: L_XML_ITEM)
545: INTO L_XML_REPORT
546: FROM DUAL;
547:
548: FOR v_unitemized_inv_row IN unitemized_inv_cur
549: LOOP
550: L_XML_ROW := NULL;

Line 556: FROM DUAL;

552: --for period name
553: SELECT XMLELEMENT("PV_PERIOD_NAME",
554: v_unitemized_inv_row.Period_Name)
555: INTO L_XML_ITEM
556: FROM DUAL;
557: L_XML_ROW_ITEMS := L_XML_ITEM;
558:
559: --for journal name
560: SELECT XMLELEMENT("PV_JOURNAL_NAME",

Line 563: FROM DUAL;

559: --for journal name
560: SELECT XMLELEMENT("PV_JOURNAL_NAME",
561: v_unitemized_inv_row.Journal_Name)
562: INTO L_XML_ITEM
563: FROM DUAL;
564: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
565: L_XML_ITEM)
566: INTO L_XML_ROW_ITEMS
567: FROM DUAL;

Line 567: FROM DUAL;

563: FROM DUAL;
564: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
565: L_XML_ITEM)
566: INTO L_XML_ROW_ITEMS
567: FROM DUAL;
568:
569: --for supplier
570: lv_supplier_name := Get_Supplier_Name(v_unitemized_inv_row.Supplier_Name
571: ,v_unitemized_inv_row.Ae_Header_Id

Line 576: FROM DUAL;

572: ,pn_ledger_id);
573: SELECT XMLELEMENT("PV_SUPPLIER_NAME",
574: lv_supplier_name)
575: INTO L_XML_ITEM
576: FROM DUAL;
577: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
578: L_XML_ITEM)
579: INTO L_XML_ROW_ITEMS
580: FROM DUAL;

Line 580: FROM DUAL;

576: FROM DUAL;
577: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
578: L_XML_ITEM)
579: INTO L_XML_ROW_ITEMS
580: FROM DUAL;
581:
582: --for invoice number/payment number
583: FOR v_inv_pay_num_row IN inv_pay_num_cur(v_unitemized_inv_row.Ae_Header_Id)
584: LOOP

Line 588: FROM DUAL;

584: LOOP
585: SELECT XMLELEMENT("PV_INV_PAY_NUMBER",
586: v_inv_pay_num_row.Inv_Pay_Number)
587: INTO L_XML_ITEM
588: FROM DUAL;
589: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
590: L_XML_ITEM)
591: INTO L_XML_ROW_ITEMS
592: FROM DUAL;

Line 592: FROM DUAL;

588: FROM DUAL;
589: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
590: L_XML_ITEM)
591: INTO L_XML_ROW_ITEMS
592: FROM DUAL;
593: EXIT;
594: END LOOP;
595:
596: SELECT XMLELEMENT("ROW_UNITEMIZED",

Line 599: FROM DUAL;

595:
596: SELECT XMLELEMENT("ROW_UNITEMIZED",
597: L_XML_ROW_ITEMS)
598: INTO L_XML_ROW
599: FROM DUAL;
600: SELECT XMLCONCAT(L_XML_REPORT,
601: L_XML_ROW)
602: INTO L_XML_REPORT
603: FROM DUAL;

Line 603: FROM DUAL;

599: FROM DUAL;
600: SELECT XMLCONCAT(L_XML_REPORT,
601: L_XML_ROW)
602: INTO L_XML_REPORT
603: FROM DUAL;
604: END LOOP;
605:
606: SELECT XMLELEMENT("REPORT",
607: L_XML_REPORT)

Line 609: FROM DUAL;

605:
606: SELECT XMLELEMENT("REPORT",
607: L_XML_REPORT)
608: INTO L_XML_ROOT
609: FROM DUAL;
610: JA_CN_UTILITY.OUTPUT_CONC(L_XML_ROOT.GETCLOBVAL());
611:
612: --logging for debug
613: IF (ln_proc_level >= ln_dbg_level)