75: ld_end_date DATE;
76: lv_le_name VARCHAR2(255);
77: lv_ledger_name VARCHAR2(255);
78:
79: L_XML_ITEM XMLTYPE;
80: L_XML_ROW_ITEMS XMLTYPE;
81: L_XML_ROW XMLTYPE;
82: L_XML_REPORT XMLTYPE;
83: L_XML_PARAMETER XMLTYPE;
76: lv_le_name VARCHAR2(255);
77: lv_ledger_name VARCHAR2(255);
78:
79: L_XML_ITEM XMLTYPE;
80: L_XML_ROW_ITEMS XMLTYPE;
81: L_XML_ROW XMLTYPE;
82: L_XML_REPORT XMLTYPE;
83: L_XML_PARAMETER XMLTYPE;
84: L_XML_ROOT XMLTYPE;
77: lv_ledger_name VARCHAR2(255);
78:
79: L_XML_ITEM XMLTYPE;
80: L_XML_ROW_ITEMS XMLTYPE;
81: L_XML_ROW XMLTYPE;
82: L_XML_REPORT XMLTYPE;
83: L_XML_PARAMETER XMLTYPE;
84: L_XML_ROOT XMLTYPE;
85:
78:
79: L_XML_ITEM XMLTYPE;
80: L_XML_ROW_ITEMS XMLTYPE;
81: L_XML_ROW XMLTYPE;
82: L_XML_REPORT XMLTYPE;
83: L_XML_PARAMETER XMLTYPE;
84: L_XML_ROOT XMLTYPE;
85:
86: --Cursor for getting data which satisty the below contidion:
79: L_XML_ITEM XMLTYPE;
80: L_XML_ROW_ITEMS XMLTYPE;
81: L_XML_ROW XMLTYPE;
82: L_XML_REPORT XMLTYPE;
83: L_XML_PARAMETER XMLTYPE;
84: L_XML_ROOT XMLTYPE;
85:
86: --Cursor for getting data which satisty the below contidion:
87: --The Legal Entity stamp on transaction is not same with the legal entity
80: L_XML_ROW_ITEMS XMLTYPE;
81: L_XML_ROW XMLTYPE;
82: L_XML_REPORT XMLTYPE;
83: L_XML_PARAMETER XMLTYPE;
84: L_XML_ROOT XMLTYPE;
85:
86: --Cursor for getting data which satisty the below contidion:
87: --The Legal Entity stamp on transaction is not same with the legal entity
88: --to which the BSV is assigned in Accounting Setup Manager.