APPS.JA_CN_CFSSE_CALCULATE_PKG dependencies on DUAL

Line 510: FROM dual;

506: 0),
507: 'FM' || to_char(rec_rows.display_format,
508: l_format_mask))
509: INTO l_amount_display
510: FROM dual;
511:
512: SELECT to_char(nvl(rec_rows.last_year_amount,
513: 0),
514: 'FM' || to_char(rec_rows.display_format,

Line 517: FROM dual;

513: 0),
514: 'FM' || to_char(rec_rows.display_format,
515: l_format_mask))
516: INTO l_last_year_amount_display
517: FROM dual;
518:
519: ELSE
520: SELECT to_char(nvl(rec_rows.amount,
521: 0),

Line 524: FROM dual;

520: SELECT to_char(nvl(rec_rows.amount,
521: 0),
522: l_format_mask)
523: INTO l_amount_display
524: FROM dual;
525:
526: SELECT to_char(nvl(rec_rows.last_year_amount,
527: 0),
528: l_format_mask)

Line 530: FROM dual;

526: SELECT to_char(nvl(rec_rows.last_year_amount,
527: 0),
528: l_format_mask)
529: INTO l_last_year_amount_display
530: FROM dual;
531: END IF; -- rec_rows.display_format IS NOT NULL
532:
533: END IF; --l_display_zero_amount_flag='N' AND NVL(l_amount,0)=0
534:

Line 549: FROM dual;

545: XMLATTRIBUTES(l_colcnt2 AS "ColCnt"),
546: nvl(l_amount_display,
547: 0)))
548: INTO l_xml_output_row
549: FROM dual;
550:
551: --log for debug
552: IF (g_stmt_level >= g_dbg_level)
553: THEN

Line 568: FROM dual;

564: ELSE
565: SELECT XMLCONCAT(l_xml_output,
566: l_xml_output_row)
567: INTO l_xml_output
568: FROM dual;
569: END IF; --l_xml_output IS NULL
570:
571: --If the type of current row is 'M', then the row is calculated by
572: --items in both main part and subsidiary part of cash flow statment

Line 601: FROM dual;

597: '-',
598: '+',
599: '+')
600: INTO l_operator
601: FROM dual;
602: ELSE
603: l_operator := rec_calculation_lines.operator;
604: END IF; --_calculation_lines.change_sign_flag='Y'
605:

Line 632: FROM dual;

628: THEN
629: SELECT 'FM' || to_char(rec_rows.display_format,
630: l_format_mask)
631: INTO l_final_display_format
632: FROM dual;
633: ELSE
634: l_final_display_format := l_format_mask;
635: END IF; --l_display_format IS NOT NULL
636:

Line 651: FROM dual;

647: l_final_display_format AS
648: "DisplayFormat"),
649: l_formula)
650: INTO l_xml_output_row
651: FROM dual;
652:
653: --log for debug
654: IF (g_stmt_level >= g_dbg_level)
655: THEN

Line 670: FROM dual;

666: ELSE
667: SELECT XMLCONCAT(l_xml_output,
668: l_xml_output_row)
669: INTO l_xml_output
670: FROM dual;
671: END IF; --l_xml_output IS NULL
672:
673: --To populate final formula for amount
674: l_formula := rec_rows.lincnt || ':' || l_colcnt2 || '=' ||

Line 687: FROM dual;

683: l_final_display_format AS
684: "DisplayFormat"),
685: l_formula)
686: INTO l_xml_output_row
687: FROM dual;
688:
689: --log for debug
690: IF (g_stmt_level >= g_dbg_level)
691: THEN

Line 706: FROM dual;

702: ELSE
703: SELECT XMLCONCAT(l_xml_output,
704: l_xml_output_row)
705: INTO l_xml_output
706: FROM dual;
707: END IF; --l_xml_output IS NULL
708:
709: --If the type of current row is 'E', then the row is calculated item,but its formual
710: --is wrong, so amount of current row cannot be calculated, an error message will be

Line 730: FROM dual;

726: XMLELEMENT("fsggRptCell",
727: XMLATTRIBUTES(l_colcnt2 AS "ColCnt"),
728: l_error_message))
729: INTO l_xml_output_row
730: FROM dual;
731:
732: --To concatenate xml output
733: IF l_xml_output IS NULL
734: THEN

Line 740: FROM dual;

736: ELSE
737: SELECT XMLCONCAT(l_xml_output,
738: l_xml_output_row)
739: INTO l_xml_output
740: FROM dual;
741:
742: END IF; --l_xml_output IS NULL
743:
744: END IF; --l_type='F'

Line 761: FROM dual;

757: 'http://www.oracle.com/2002-03-20/fsg.xsd' AS
758: "xsi:schemaLocation"),
759: l_xml_output)
760: INTO l_xml_output_root
761: FROM dual;
762:
763: --FND_FILE.Put_Line(FND_FILE.LOG,
764: -- REPLACE(l_xml_output_root.getclobval(),
765: -- 'fsgg',