639: -- leger parameters
640: --l_sob_id NUMBER := P_SOB_ID;
641: l_ledger_name VARCHAR2(30);
642:
643: l_xml_item XMLTYPE;
644: l_xml_line_items XMLTYPE;
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
640: --l_sob_id NUMBER := P_SOB_ID;
641: l_ledger_name VARCHAR2(30);
642:
643: l_xml_item XMLTYPE;
644: l_xml_line_items XMLTYPE;
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
648: l_xml_all XMLTYPE;
641: l_ledger_name VARCHAR2(30);
642:
643: l_xml_item XMLTYPE;
644: l_xml_line_items XMLTYPE;
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
648: l_xml_all XMLTYPE;
649: l_xml_root XMLTYPE;
642:
643: l_xml_item XMLTYPE;
644: l_xml_line_items XMLTYPE;
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
648: l_xml_all XMLTYPE;
649: l_xml_root XMLTYPE;
650:
643: l_xml_item XMLTYPE;
644: l_xml_line_items XMLTYPE;
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
648: l_xml_all XMLTYPE;
649: l_xml_root XMLTYPE;
650:
651: l_dff_check VARCHAR2(1); --result of DFF Assignment check
644: l_xml_line_items XMLTYPE;
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
648: l_xml_all XMLTYPE;
649: l_xml_root XMLTYPE;
650:
651: l_dff_check VARCHAR2(1); --result of DFF Assignment check
652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
645: l_xml_line XMLTYPE;
646: l_xml_jnl_items XMLTYPE;
647: l_xml_journal XMLTYPE;
648: l_xml_all XMLTYPE;
649: l_xml_root XMLTYPE;
650:
651: l_dff_check VARCHAR2(1); --result of DFF Assignment check
652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
653: l_period_name gl_periods.period_name%TYPE;
1292: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;
1293: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;
1294: --l_sts_settle VARCHAR2(200) := '';
1295:
1296: l_xml_item XMLTYPE;
1297: l_xml_line_items XMLTYPE;
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1293: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;
1294: --l_sts_settle VARCHAR2(200) := '';
1295:
1296: l_xml_item XMLTYPE;
1297: l_xml_line_items XMLTYPE;
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1301: l_xml_all XMLTYPE;
1294: --l_sts_settle VARCHAR2(200) := '';
1295:
1296: l_xml_item XMLTYPE;
1297: l_xml_line_items XMLTYPE;
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1301: l_xml_all XMLTYPE;
1302: l_xml_root XMLTYPE;
1295:
1296: l_xml_item XMLTYPE;
1297: l_xml_line_items XMLTYPE;
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1301: l_xml_all XMLTYPE;
1302: l_xml_root XMLTYPE;
1303:
1296: l_xml_item XMLTYPE;
1297: l_xml_line_items XMLTYPE;
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1301: l_xml_all XMLTYPE;
1302: l_xml_root XMLTYPE;
1303:
1304: l_dff_check varchar2(1); --result of DFF Assignment check
1297: l_xml_line_items XMLTYPE;
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1301: l_xml_all XMLTYPE;
1302: l_xml_root XMLTYPE;
1303:
1304: l_dff_check varchar2(1); --result of DFF Assignment check
1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1298: l_xml_line XMLTYPE;
1299: l_xml_tr_items XMLTYPE;
1300: l_xml_tr XMLTYPE;
1301: l_xml_all XMLTYPE;
1302: l_xml_root XMLTYPE;
1303:
1304: l_dff_check varchar2(1); --result of DFF Assignment check
1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1306: l_period_name gl_periods.period_name%TYPE;