APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 241: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

237: ,p_period_from IN VARCHAR2
238: ,p_period_to IN VARCHAR2) IS
239:
240: -- declare local variables
241: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
242: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
243: l_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
244: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
245: l_sob_name VARCHAR2(2000);

Line 242: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

238: ,p_period_to IN VARCHAR2) IS
239:
240: -- declare local variables
241: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
242: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
243: l_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
244: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
245: l_sob_name VARCHAR2(2000);
246: l_sysdate DATE := SYSDATE;

Line 366: (contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

362: FROM OKC_K_HEADERS_B
363: WHERE id = p_agr_id;
364:
365: TYPE depr_contracts_rec_type IS RECORD
366: (contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
367: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE);
368: TYPE depr_contracts_tbl_type IS TABLE OF depr_contracts_rec_type INDEX BY BINARY_INTEGER;
369:
370: l_depr_contracts_tbl depr_contracts_tbl_type;

Line 367: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE);

363: WHERE id = p_agr_id;
364:
365: TYPE depr_contracts_rec_type IS RECORD
366: (contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
367: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE);
368: TYPE depr_contracts_tbl_type IS TABLE OF depr_contracts_rec_type INDEX BY BINARY_INTEGER;
369:
370: l_depr_contracts_tbl depr_contracts_tbl_type;
371:

Line 483: l_agreement_id OKL_K_HEADERS_FULL_V.id%TYPE;

479: -- Declare local variables which need to be re-initialized to null for each contract
480: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
481: l_record_status VARCHAR2(10);
482: l_deprn_amount NUMBER := 0;
483: l_agreement_id OKL_K_HEADERS_FULL_V.id%TYPE;
484: l_agreement_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
485: l_revenue_share NUMBER := 0;
486:
487: -- Begin a new PL/SQL block to trap errors related to a praticular contract and to move on to the next contract

Line 484: l_agreement_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

480: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
481: l_record_status VARCHAR2(10);
482: l_deprn_amount NUMBER := 0;
483: l_agreement_id OKL_K_HEADERS_FULL_V.id%TYPE;
484: l_agreement_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
485: l_revenue_share NUMBER := 0;
486:
487: -- Begin a new PL/SQL block to trap errors related to a praticular contract and to move on to the next contract
488: BEGIN