DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on XMLTYPE

Line 648: l_xml_item XMLTYPE;

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;

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

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

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

Line 652: l_xml_journal XMLTYPE;

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

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

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

Line 1333: l_xml_item XMLTYPE;

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;

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

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

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

Line 1337: l_xml_tr XMLTYPE;

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

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

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