416: -- Define Types
417: -------------------------------------------------------------------------------
418: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
419: TYPE r_security_info IS RECORD
420: (valuation_method xla_transaction_entities.valuation_method%TYPE
421: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
422: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
423:
424: -------------------------------------------------------------------------------
417: -------------------------------------------------------------------------------
418: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
419: TYPE r_security_info IS RECORD
420: (valuation_method xla_transaction_entities.valuation_method%TYPE
421: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
422: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
423:
424: -------------------------------------------------------------------------------
425: -- Global Constants
418: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
419: TYPE r_security_info IS RECORD
420: (valuation_method xla_transaction_entities.valuation_method%TYPE
421: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
422: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
423:
424: -------------------------------------------------------------------------------
425: -- Global Constants
426: -------------------------------------------------------------------------------
765: ,NULL user_trx_identifier_value_9
766: ,NULL user_trx_identifier_name_10
767: ,NULL user_trx_identifier_value_10
768: FROM
769: xla_transaction_entities ent
770: ,xla_transaction_entities tea
771: ,gl_ledgers gld
772: $party_tab$
773: $user_trx_id_from$
766: ,NULL user_trx_identifier_name_10
767: ,NULL user_trx_identifier_value_10
768: FROM
769: xla_transaction_entities ent
770: ,xla_transaction_entities tea
771: ,gl_ledgers gld
772: $party_tab$
773: $user_trx_id_from$
774: $account_tab$
917: ,NULL user_trx_identifier_value_9
918: ,NULL user_trx_identifier_name_10
919: ,NULL user_trx_identifier_value_10
920: FROM
921: xla_transaction_entities tea
922: ,gl_ledgers gld
923: $party_tab$
924: -- $user_trx_id_from$
925: $account_tab$