DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_FXL_PVT

Line 4154: l_fxl_rec okl_fxl_pvt.fxl_rec_type;

4150: -- for capture header translatable sources
4151: l_fxhl_tbl okl_fxh_pvt.fxhl_tbl_type;
4152: lx_fxhl_tbl okl_fxh_pvt.fxhl_tbl_type;
4153:
4154: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
4155: lx_fxl_rec okl_fxl_pvt.fxl_rec_type;
4156: -- for capture header translatable sources
4157: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4158: lx_fxll_tbl okl_fxl_pvt.fxll_tbl_type;

Line 4155: lx_fxl_rec okl_fxl_pvt.fxl_rec_type;

4151: l_fxhl_tbl okl_fxh_pvt.fxhl_tbl_type;
4152: lx_fxhl_tbl okl_fxh_pvt.fxhl_tbl_type;
4153:
4154: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
4155: lx_fxl_rec okl_fxl_pvt.fxl_rec_type;
4156: -- for capture header translatable sources
4157: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4158: lx_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4159:

Line 4157: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;

4153:
4154: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
4155: lx_fxl_rec okl_fxl_pvt.fxl_rec_type;
4156: -- for capture header translatable sources
4157: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4158: lx_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4159:
4160: l_led_lang_tbl led_lang_tbl_type;
4161:

Line 4158: lx_fxll_tbl okl_fxl_pvt.fxll_tbl_type;

4154: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
4155: lx_fxl_rec okl_fxl_pvt.fxl_rec_type;
4156: -- for capture header translatable sources
4157: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4158: lx_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
4159:
4160: l_led_lang_tbl led_lang_tbl_type;
4161:
4162: -- Record structures based on the Cursor defintions

Line 4757: l_fxlv_tbl okl_fxl_pvt.fxlv_tbl_type;

4753: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TRX_EXTENSION';
4754: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4755: fxl_index BINARY_INTEGER;
4756: l_fxhv_rec okl_fxh_pvt.fxhv_rec_type;
4757: l_fxlv_tbl okl_fxl_pvt.fxlv_tbl_type;
4758: lx_fxhv_rec okl_fxh_pvt.fxhv_rec_type;
4759: lx_fxlv_tbl okl_fxl_pvt.fxlv_tbl_type;
4760: -- Cursor Definitions
4761: CURSOR get_fa_ext_hdr_id( p_source_id NUMBER, p_source_table VARCHAR2)

Line 4759: lx_fxlv_tbl okl_fxl_pvt.fxlv_tbl_type;

4755: fxl_index BINARY_INTEGER;
4756: l_fxhv_rec okl_fxh_pvt.fxhv_rec_type;
4757: l_fxlv_tbl okl_fxl_pvt.fxlv_tbl_type;
4758: lx_fxhv_rec okl_fxh_pvt.fxhv_rec_type;
4759: lx_fxlv_tbl okl_fxl_pvt.fxlv_tbl_type;
4760: -- Cursor Definitions
4761: CURSOR get_fa_ext_hdr_id( p_source_id NUMBER, p_source_table VARCHAR2)
4762: IS
4763: SELECT fxh.header_extension_id header_extension_id

Line 4861: 'calling the okl_fa_extension_pvt okl_fxl_pvt.delete_row Line Count=' || l_fxlv_tbl.COUNT );

4857: x_fxlv_tbl := l_fxlv_tbl;
4858:
4859: -- Delete the FA Extension Lines by calling the TAPI first
4860: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4861: 'calling the okl_fa_extension_pvt okl_fxl_pvt.delete_row Line Count=' || l_fxlv_tbl.COUNT );
4862: okl_fa_extension_pvt.delete_fxh_extension(
4863: p_api_version => p_api_version
4864: ,p_init_msg_list => p_init_msg_list
4865: ,x_return_status => x_return_status

Line 7639: l_fxl_rec okl_fxl_pvt.fxl_rec_type;

7635: lx_fxhl_tbl okl_fxh_pvt.fxhl_tbl_type;
7636: l_fxl_tbl_tbl fxl_tbl_tbl_type;
7637: lx_fxl_tbl_tbl fxl_tbl_tbl_type;
7638: l_fxl_tbl_tbl_out fxl_tbl_tbl_type;
7639: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
7640: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7641: l_null_fxl_rec okl_fxl_pvt.fxl_rec_type;
7642: l_null_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7643: l_led_lang_tbl led_lang_tbl_type;

Line 7640: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;

7636: l_fxl_tbl_tbl fxl_tbl_tbl_type;
7637: lx_fxl_tbl_tbl fxl_tbl_tbl_type;
7638: l_fxl_tbl_tbl_out fxl_tbl_tbl_type;
7639: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
7640: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7641: l_null_fxl_rec okl_fxl_pvt.fxl_rec_type;
7642: l_null_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7643: l_led_lang_tbl led_lang_tbl_type;
7644: -- Record structures based on the Cursor defintions

Line 7641: l_null_fxl_rec okl_fxl_pvt.fxl_rec_type;

7637: lx_fxl_tbl_tbl fxl_tbl_tbl_type;
7638: l_fxl_tbl_tbl_out fxl_tbl_tbl_type;
7639: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
7640: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7641: l_null_fxl_rec okl_fxl_pvt.fxl_rec_type;
7642: l_null_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7643: l_led_lang_tbl led_lang_tbl_type;
7644: -- Record structures based on the Cursor defintions
7645: l_sales_rep_csr_rec c_sales_rep_csr%ROWTYPE;

Line 7642: l_null_fxll_tbl okl_fxl_pvt.fxll_tbl_type;

7638: l_fxl_tbl_tbl_out fxl_tbl_tbl_type;
7639: l_fxl_rec okl_fxl_pvt.fxl_rec_type;
7640: l_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7641: l_null_fxl_rec okl_fxl_pvt.fxl_rec_type;
7642: l_null_fxll_tbl okl_fxl_pvt.fxll_tbl_type;
7643: l_led_lang_tbl led_lang_tbl_type;
7644: -- Record structures based on the Cursor defintions
7645: l_sales_rep_csr_rec c_sales_rep_csr%ROWTYPE;
7646: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;