DBA Data[Home] [Help]

APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

269: ,p_period_to IN VARCHAR2
270: ,p_batch_name IN VARCHAR2) IS
271:
272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;

Line 274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

270: ,p_batch_name IN VARCHAR2) IS
271:
272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;

Line 275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

271:
272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

Line 280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;
282: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
283: l_book_type_code OKL_TXD_ASSETS_V.tax_book%TYPE;
284: l_contract_currency OKC_K_HEADERS_B.currency_code%TYPE;

Line 513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE

509: SELECT generate_accrual_override_yn
510: FROM okl_k_headers
511: WHERE id = p_khr_id;
512:
513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE
514: INDEX BY BINARY_INTEGER;
515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

Line 517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE
514: INDEX BY BINARY_INTEGER;
515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

Line 518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

514: INDEX BY BINARY_INTEGER;
515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);

Line 521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524:
525: TYPE gaap_contracts_tbl_type IS TABLE OF gaap_contracts_rec_type

Line 522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524:
525: TYPE gaap_contracts_tbl_type IS TABLE OF gaap_contracts_rec_type
526: INDEX BY BINARY_INTEGER;

Line 523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);

519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524:
525: TYPE gaap_contracts_tbl_type IS TABLE OF gaap_contracts_rec_type
526: INDEX BY BINARY_INTEGER;
527: