DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on XMLTYPE

Line 514: L_XML_ITEM XMLTYPE;

510: -- Fix bug#6697073 end------------------------------------------
511:
512: L_SOURCE_AR VARCHAR2(10) := 'AR';
513: L_ROW_AMOUNT NUMBER;
514: L_XML_ITEM XMLTYPE;
515: L_XML_ALL XMLTYPE;
516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;

Line 515: L_XML_ALL XMLTYPE;

511:
512: L_SOURCE_AR VARCHAR2(10) := 'AR';
513: L_ROW_AMOUNT NUMBER;
514: L_XML_ITEM XMLTYPE;
515: L_XML_ALL XMLTYPE;
516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;

Line 516: L_XML_ROW_ITEMS XMLTYPE;

512: L_SOURCE_AR VARCHAR2(10) := 'AR';
513: L_ROW_AMOUNT NUMBER;
514: L_XML_ITEM XMLTYPE;
515: L_XML_ALL XMLTYPE;
516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;
520: L_XML_PARAMETER XMLTYPE;

Line 517: L_XML_ROW XMLTYPE;

513: L_ROW_AMOUNT NUMBER;
514: L_XML_ITEM XMLTYPE;
515: L_XML_ALL XMLTYPE;
516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;
520: L_XML_PARAMETER XMLTYPE;
521: L_XML_ROOT XMLTYPE;

Line 518: L_XML_PERIOD XMLTYPE;

514: L_XML_ITEM XMLTYPE;
515: L_XML_ALL XMLTYPE;
516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;
520: L_XML_PARAMETER XMLTYPE;
521: L_XML_ROOT XMLTYPE;
522:

Line 519: L_XML_REPORT XMLTYPE;

515: L_XML_ALL XMLTYPE;
516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;
520: L_XML_PARAMETER XMLTYPE;
521: L_XML_ROOT XMLTYPE;
522:
523: -- Fix bug#6854438 add new variable begin

Line 520: L_XML_PARAMETER XMLTYPE;

516: L_XML_ROW_ITEMS XMLTYPE;
517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;
520: L_XML_PARAMETER XMLTYPE;
521: L_XML_ROOT XMLTYPE;
522:
523: -- Fix bug#6854438 add new variable begin
524: L_XML_ROWS_ALL XMLTYPE; -- record all the rows

Line 521: L_XML_ROOT XMLTYPE;

517: L_XML_ROW XMLTYPE;
518: L_XML_PERIOD XMLTYPE;
519: L_XML_REPORT XMLTYPE;
520: L_XML_PARAMETER XMLTYPE;
521: L_XML_ROOT XMLTYPE;
522:
523: -- Fix bug#6854438 add new variable begin
524: L_XML_ROWS_ALL XMLTYPE; -- record all the rows
525: -- Fix bug#6854438 add new variable end

Line 524: L_XML_ROWS_ALL XMLTYPE; -- record all the rows

520: L_XML_PARAMETER XMLTYPE;
521: L_XML_ROOT XMLTYPE;
522:
523: -- Fix bug#6854438 add new variable begin
524: L_XML_ROWS_ALL XMLTYPE; -- record all the rows
525: -- Fix bug#6854438 add new variable end
526: L_DIS_FLAG NUMBER;
527: L_ERROR_STATUS BOOLEAN;
528: JA_CN_INVALID_GLPERIOD EXCEPTION;