306: , source_type_code
307: , source_code
308: , SUBSTR(source_value ,1,1996)
309: , SUBSTR(source_meaning,1,200)
310: , xla_environment_pkg.g_Usr_Id
311: , TRUNC(SYSDATE)
312: , TRUNC(SYSDATE)
313: , xla_environment_pkg.g_Usr_Id
314: , xla_environment_pkg.g_Login_Id
309: , SUBSTR(source_meaning,1,200)
310: , xla_environment_pkg.g_Usr_Id
311: , TRUNC(SYSDATE)
312: , TRUNC(SYSDATE)
313: , xla_environment_pkg.g_Usr_Id
314: , xla_environment_pkg.g_Login_Id
315: , TRUNC(SYSDATE)
316: , xla_environment_pkg.g_Prog_Appl_Id
317: , xla_environment_pkg.g_Prog_Id
310: , xla_environment_pkg.g_Usr_Id
311: , TRUNC(SYSDATE)
312: , TRUNC(SYSDATE)
313: , xla_environment_pkg.g_Usr_Id
314: , xla_environment_pkg.g_Login_Id
315: , TRUNC(SYSDATE)
316: , xla_environment_pkg.g_Prog_Appl_Id
317: , xla_environment_pkg.g_Prog_Id
318: , xla_environment_pkg.g_Req_Id
312: , TRUNC(SYSDATE)
313: , xla_environment_pkg.g_Usr_Id
314: , xla_environment_pkg.g_Login_Id
315: , TRUNC(SYSDATE)
316: , xla_environment_pkg.g_Prog_Appl_Id
317: , xla_environment_pkg.g_Prog_Id
318: , xla_environment_pkg.g_Req_Id
319: FROM (
320: SELECT xet.event_id event_id
313: , xla_environment_pkg.g_Usr_Id
314: , xla_environment_pkg.g_Login_Id
315: , TRUNC(SYSDATE)
316: , xla_environment_pkg.g_Prog_Appl_Id
317: , xla_environment_pkg.g_Prog_Id
318: , xla_environment_pkg.g_Req_Id
319: FROM (
320: SELECT xet.event_id event_id
321: , 0 line_number
314: , xla_environment_pkg.g_Login_Id
315: , TRUNC(SYSDATE)
316: , xla_environment_pkg.g_Prog_Appl_Id
317: , xla_environment_pkg.g_Prog_Id
318: , xla_environment_pkg.g_Req_Id
319: FROM (
320: SELECT xet.event_id event_id
321: , 0 line_number
322: , CASE r
405: , source_type_code
406: , source_code
407: , SUBSTR(source_value ,1,1996)
408: , SUBSTR(source_meaning ,1,200)
409: , xla_environment_pkg.g_Usr_Id
410: , TRUNC(SYSDATE)
411: , TRUNC(SYSDATE)
412: , xla_environment_pkg.g_Usr_Id
413: , xla_environment_pkg.g_Login_Id
408: , SUBSTR(source_meaning ,1,200)
409: , xla_environment_pkg.g_Usr_Id
410: , TRUNC(SYSDATE)
411: , TRUNC(SYSDATE)
412: , xla_environment_pkg.g_Usr_Id
413: , xla_environment_pkg.g_Login_Id
414: , TRUNC(SYSDATE)
415: , xla_environment_pkg.g_Prog_Appl_Id
416: , xla_environment_pkg.g_Prog_Id
409: , xla_environment_pkg.g_Usr_Id
410: , TRUNC(SYSDATE)
411: , TRUNC(SYSDATE)
412: , xla_environment_pkg.g_Usr_Id
413: , xla_environment_pkg.g_Login_Id
414: , TRUNC(SYSDATE)
415: , xla_environment_pkg.g_Prog_Appl_Id
416: , xla_environment_pkg.g_Prog_Id
417: , xla_environment_pkg.g_Req_Id
411: , TRUNC(SYSDATE)
412: , xla_environment_pkg.g_Usr_Id
413: , xla_environment_pkg.g_Login_Id
414: , TRUNC(SYSDATE)
415: , xla_environment_pkg.g_Prog_Appl_Id
416: , xla_environment_pkg.g_Prog_Id
417: , xla_environment_pkg.g_Req_Id
418: FROM (
419: SELECT xet.event_id event_id
412: , xla_environment_pkg.g_Usr_Id
413: , xla_environment_pkg.g_Login_Id
414: , TRUNC(SYSDATE)
415: , xla_environment_pkg.g_Prog_Appl_Id
416: , xla_environment_pkg.g_Prog_Id
417: , xla_environment_pkg.g_Req_Id
418: FROM (
419: SELECT xet.event_id event_id
420: , 0 line_number
413: , xla_environment_pkg.g_Login_Id
414: , TRUNC(SYSDATE)
415: , xla_environment_pkg.g_Prog_Appl_Id
416: , xla_environment_pkg.g_Prog_Id
417: , xla_environment_pkg.g_Req_Id
418: FROM (
419: SELECT xet.event_id event_id
420: , 0 line_number
421: , CASE r
504: , source_type_code
505: , source_code
506: , SUBSTR(source_value,1,1996)
507: , SUBSTR(source_meaning,1,200)
508: , xla_environment_pkg.g_Usr_Id
509: , TRUNC(SYSDATE)
510: , TRUNC(SYSDATE)
511: , xla_environment_pkg.g_Usr_Id
512: , xla_environment_pkg.g_Login_Id
507: , SUBSTR(source_meaning,1,200)
508: , xla_environment_pkg.g_Usr_Id
509: , TRUNC(SYSDATE)
510: , TRUNC(SYSDATE)
511: , xla_environment_pkg.g_Usr_Id
512: , xla_environment_pkg.g_Login_Id
513: , TRUNC(SYSDATE)
514: , xla_environment_pkg.g_Prog_Appl_Id
515: , xla_environment_pkg.g_Prog_Id
508: , xla_environment_pkg.g_Usr_Id
509: , TRUNC(SYSDATE)
510: , TRUNC(SYSDATE)
511: , xla_environment_pkg.g_Usr_Id
512: , xla_environment_pkg.g_Login_Id
513: , TRUNC(SYSDATE)
514: , xla_environment_pkg.g_Prog_Appl_Id
515: , xla_environment_pkg.g_Prog_Id
516: , xla_environment_pkg.g_Req_Id
510: , TRUNC(SYSDATE)
511: , xla_environment_pkg.g_Usr_Id
512: , xla_environment_pkg.g_Login_Id
513: , TRUNC(SYSDATE)
514: , xla_environment_pkg.g_Prog_Appl_Id
515: , xla_environment_pkg.g_Prog_Id
516: , xla_environment_pkg.g_Req_Id
517: FROM (
518: SELECT xet.event_id event_id
511: , xla_environment_pkg.g_Usr_Id
512: , xla_environment_pkg.g_Login_Id
513: , TRUNC(SYSDATE)
514: , xla_environment_pkg.g_Prog_Appl_Id
515: , xla_environment_pkg.g_Prog_Id
516: , xla_environment_pkg.g_Req_Id
517: FROM (
518: SELECT xet.event_id event_id
519: , $line_number$ line_number
512: , xla_environment_pkg.g_Login_Id
513: , TRUNC(SYSDATE)
514: , xla_environment_pkg.g_Prog_Appl_Id
515: , xla_environment_pkg.g_Prog_Id
516: , xla_environment_pkg.g_Req_Id
517: FROM (
518: SELECT xet.event_id event_id
519: , $line_number$ line_number
520: , CASE r
602: , source_type_code
603: , source_code
604: , SUBSTR(source_value,1,1996)
605: , SUBSTR(source_meaning ,1,200)
606: , xla_environment_pkg.g_Usr_Id
607: , TRUNC(SYSDATE)
608: , TRUNC(SYSDATE)
609: , xla_environment_pkg.g_Usr_Id
610: , xla_environment_pkg.g_Login_Id
605: , SUBSTR(source_meaning ,1,200)
606: , xla_environment_pkg.g_Usr_Id
607: , TRUNC(SYSDATE)
608: , TRUNC(SYSDATE)
609: , xla_environment_pkg.g_Usr_Id
610: , xla_environment_pkg.g_Login_Id
611: , TRUNC(SYSDATE)
612: , xla_environment_pkg.g_Prog_Appl_Id
613: , xla_environment_pkg.g_Prog_Id
606: , xla_environment_pkg.g_Usr_Id
607: , TRUNC(SYSDATE)
608: , TRUNC(SYSDATE)
609: , xla_environment_pkg.g_Usr_Id
610: , xla_environment_pkg.g_Login_Id
611: , TRUNC(SYSDATE)
612: , xla_environment_pkg.g_Prog_Appl_Id
613: , xla_environment_pkg.g_Prog_Id
614: , xla_environment_pkg.g_Req_Id
608: , TRUNC(SYSDATE)
609: , xla_environment_pkg.g_Usr_Id
610: , xla_environment_pkg.g_Login_Id
611: , TRUNC(SYSDATE)
612: , xla_environment_pkg.g_Prog_Appl_Id
613: , xla_environment_pkg.g_Prog_Id
614: , xla_environment_pkg.g_Req_Id
615: FROM (
616: SELECT xet.event_id event_id
609: , xla_environment_pkg.g_Usr_Id
610: , xla_environment_pkg.g_Login_Id
611: , TRUNC(SYSDATE)
612: , xla_environment_pkg.g_Prog_Appl_Id
613: , xla_environment_pkg.g_Prog_Id
614: , xla_environment_pkg.g_Req_Id
615: FROM (
616: SELECT xet.event_id event_id
617: , $line_number$ line_number
610: , xla_environment_pkg.g_Login_Id
611: , TRUNC(SYSDATE)
612: , xla_environment_pkg.g_Prog_Appl_Id
613: , xla_environment_pkg.g_Prog_Id
614: , xla_environment_pkg.g_Req_Id
615: FROM (
616: SELECT xet.event_id event_id
617: , $line_number$ line_number
618: , CASE r
675: C_ALWAYS_POPULATED CONSTANT VARCHAR2(1) := 'Y';
676: --
677: C_NOT_REF_OBJ CONSTANT VARCHAR2(1) := 'N';
678: --
679: g_chr_newline CONSTANT VARCHAR2(10):= xla_environment_pkg.g_chr_newline;
680: g_application_id XLA_SUBLEDGERS.APPLICATION_ID%TYPE;
681: --
682: --
683: --+==========================================================================+