DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on XMLTYPE

Line 643: l_xml_item XMLTYPE;

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;

Line 644: l_xml_line_items 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;

Line 645: l_xml_line 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;

Line 646: l_xml_jnl_items 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:

Line 647: l_xml_journal XMLTYPE;

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

Line 648: l_xml_all 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
652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction

Line 649: l_xml_root 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
653: l_period_name gl_periods.period_name%TYPE;

Line 1296: l_xml_item XMLTYPE;

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;

Line 1297: l_xml_line_items 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;

Line 1298: l_xml_line 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;

Line 1299: l_xml_tr_items 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:

Line 1300: l_xml_tr XMLTYPE;

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

Line 1301: l_xml_all 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
1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction

Line 1302: l_xml_root 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
1306: l_period_name gl_periods.period_name%TYPE;