[Home] [Help]
644: -- leger parameters
645: --l_sob_id NUMBER := P_SOB_ID;
646: l_ledger_name VARCHAR2(30);
647:
648: l_xml_item XMLTYPE;
649: l_xml_line_items XMLTYPE;
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
645: --l_sob_id NUMBER := P_SOB_ID;
646: l_ledger_name VARCHAR2(30);
647:
648: l_xml_item XMLTYPE;
649: l_xml_line_items XMLTYPE;
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
653: l_xml_all XMLTYPE;
646: l_ledger_name VARCHAR2(30);
647:
648: l_xml_item XMLTYPE;
649: l_xml_line_items XMLTYPE;
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
653: l_xml_all XMLTYPE;
654: l_xml_root XMLTYPE;
647:
648: l_xml_item XMLTYPE;
649: l_xml_line_items XMLTYPE;
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
653: l_xml_all XMLTYPE;
654: l_xml_root XMLTYPE;
655:
648: l_xml_item XMLTYPE;
649: l_xml_line_items XMLTYPE;
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
653: l_xml_all XMLTYPE;
654: l_xml_root XMLTYPE;
655:
656: l_dff_check VARCHAR2(1); --result of DFF Assignment check
649: l_xml_line_items XMLTYPE;
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
653: l_xml_all XMLTYPE;
654: l_xml_root XMLTYPE;
655:
656: l_dff_check VARCHAR2(1); --result of DFF Assignment check
657: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
650: l_xml_line XMLTYPE;
651: l_xml_jnl_items XMLTYPE;
652: l_xml_journal XMLTYPE;
653: l_xml_all XMLTYPE;
654: l_xml_root XMLTYPE;
655:
656: l_dff_check VARCHAR2(1); --result of DFF Assignment check
657: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
658: l_period_name gl_periods.period_name%TYPE;
1329: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;
1330: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;
1331: --l_sts_settle VARCHAR2(200) := '';
1332:
1333: l_xml_item XMLTYPE;
1334: l_xml_line_items XMLTYPE;
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1330: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;
1331: --l_sts_settle VARCHAR2(200) := '';
1332:
1333: l_xml_item XMLTYPE;
1334: l_xml_line_items XMLTYPE;
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1338: l_xml_all XMLTYPE;
1331: --l_sts_settle VARCHAR2(200) := '';
1332:
1333: l_xml_item XMLTYPE;
1334: l_xml_line_items XMLTYPE;
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1338: l_xml_all XMLTYPE;
1339: l_xml_root XMLTYPE;
1332:
1333: l_xml_item XMLTYPE;
1334: l_xml_line_items XMLTYPE;
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1338: l_xml_all XMLTYPE;
1339: l_xml_root XMLTYPE;
1340:
1333: l_xml_item XMLTYPE;
1334: l_xml_line_items XMLTYPE;
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1338: l_xml_all XMLTYPE;
1339: l_xml_root XMLTYPE;
1340:
1341: l_dff_check varchar2(1); --result of DFF Assignment check
1334: l_xml_line_items XMLTYPE;
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1338: l_xml_all XMLTYPE;
1339: l_xml_root XMLTYPE;
1340:
1341: l_dff_check varchar2(1); --result of DFF Assignment check
1342: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1335: l_xml_line XMLTYPE;
1336: l_xml_tr_items XMLTYPE;
1337: l_xml_tr XMLTYPE;
1338: l_xml_all XMLTYPE;
1339: l_xml_root XMLTYPE;
1340:
1341: l_dff_check varchar2(1); --result of DFF Assignment check
1342: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1343: l_period_name gl_periods.period_name%TYPE;