402: -- Define Types
403: -------------------------------------------------------------------------------
404: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
405: TYPE r_security_info IS RECORD
406: (valuation_method xla_transaction_entities.valuation_method%TYPE
407: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
408: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
409:
410: -------------------------------------------------------------------------------
403: -------------------------------------------------------------------------------
404: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
405: TYPE r_security_info IS RECORD
406: (valuation_method xla_transaction_entities.valuation_method%TYPE
407: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
408: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
409:
410: -------------------------------------------------------------------------------
411: -- Global Constants
404: TYPE t_array_char IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER ;
405: TYPE r_security_info IS RECORD
406: (valuation_method xla_transaction_entities.valuation_method%TYPE
407: ,security_id_int_1 xla_transaction_entities.security_id_int_1%TYPE
408: ,security_id_char_1 xla_transaction_entities.security_id_char_1%TYPE);
409:
410: -------------------------------------------------------------------------------
411: -- Global Constants
412: -------------------------------------------------------------------------------
751: ,NULL user_trx_identifier_value_9
752: ,NULL user_trx_identifier_name_10
753: ,NULL user_trx_identifier_value_10
754: FROM
755: xla_transaction_entities ent
756: ,xla_transaction_entities tea
757: ,gl_ledgers gld
758: $party_tab$
759: $user_trx_id_from$
752: ,NULL user_trx_identifier_name_10
753: ,NULL user_trx_identifier_value_10
754: FROM
755: xla_transaction_entities ent
756: ,xla_transaction_entities tea
757: ,gl_ledgers gld
758: $party_tab$
759: $user_trx_id_from$
760: $account_tab$
903: ,NULL user_trx_identifier_value_9
904: ,NULL user_trx_identifier_name_10
905: ,NULL user_trx_identifier_value_10
906: FROM
907: xla_transaction_entities tea
908: ,gl_ledgers gld
909: $party_tab$
910: -- $user_trx_id_from$
911: $account_tab$