141: lsm_id NUMBER,
142: asset_number Okl_Xtl_Sell_Invs_tl.XTRX_ASSET%TYPE,
143: invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE,
144: line_type okl_invc_line_types_v.NAME%TYPE,
145: private_label Okl_Ext_Sell_Invs_tl.xtrx_private_label%TYPE,
146: sty_name okl_strm_type_v.NAME%TYPE,
147: contract_number okc_k_headers_b.contract_number%TYPE,
148: lsm_amount NUMBER,
149: xsi_id NUMBER,
393: g_xls_counter NUMBER := 0;
394:
395:
396: TYPE xsi_tl_rec IS RECORD (
397: id okl_ext_sell_invs_tl.id%type,
398: xtrx_cons_invoice_number okl_ext_sell_invs_tl.xtrx_cons_invoice_number%type,
399: xtrx_format_type okl_ext_sell_invs_tl.xtrx_format_type%type,
400: xtrx_private_label okl_ext_sell_invs_tl.xtrx_private_label%type);
401:
394:
395:
396: TYPE xsi_tl_rec IS RECORD (
397: id okl_ext_sell_invs_tl.id%type,
398: xtrx_cons_invoice_number okl_ext_sell_invs_tl.xtrx_cons_invoice_number%type,
399: xtrx_format_type okl_ext_sell_invs_tl.xtrx_format_type%type,
400: xtrx_private_label okl_ext_sell_invs_tl.xtrx_private_label%type);
401:
402: TYPE xsi_tl_tbl IS TABLE OF xsi_tl_rec
395:
396: TYPE xsi_tl_rec IS RECORD (
397: id okl_ext_sell_invs_tl.id%type,
398: xtrx_cons_invoice_number okl_ext_sell_invs_tl.xtrx_cons_invoice_number%type,
399: xtrx_format_type okl_ext_sell_invs_tl.xtrx_format_type%type,
400: xtrx_private_label okl_ext_sell_invs_tl.xtrx_private_label%type);
401:
402: TYPE xsi_tl_tbl IS TABLE OF xsi_tl_rec
403: INDEX BY BINARY_INTEGER;
396: TYPE xsi_tl_rec IS RECORD (
397: id okl_ext_sell_invs_tl.id%type,
398: xtrx_cons_invoice_number okl_ext_sell_invs_tl.xtrx_cons_invoice_number%type,
399: xtrx_format_type okl_ext_sell_invs_tl.xtrx_format_type%type,
400: xtrx_private_label okl_ext_sell_invs_tl.xtrx_private_label%type);
401:
402: TYPE xsi_tl_tbl IS TABLE OF xsi_tl_rec
403: INDEX BY BINARY_INTEGER;
404: