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;
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;
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;
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;
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:
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
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
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
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;