APPS.OKL_REPORT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 4405: PROCEDURE insert_gt(p_contract_number IN okc_k_headers_all_b.contract_number%TYPE,

4401: '_PVT');
4402:
4403: END update_report;
4404:
4405: PROCEDURE insert_gt(p_contract_number IN okc_k_headers_all_b.contract_number%TYPE,
4406: p_party_name in hz_parties.party_name%TYPE,
4407: p_account_number IN hz_cust_accounts.account_number%TYPE ,
4408: p_cust_site_name IN okx_cust_sites_v.description%TYPE,
4409: p_inv_msg IN fnd_new_messages.message_text%TYPE,

Line 4673: CURSOR validate_k_bank_account (cp_khr_id IN okc_k_headers_all_b.id%TYPE) IS

4669: AND acct_site.status = 'A'
4670: AND site_use.status = 'A';
4671:
4672: -- Validate K Level Bank Account in IBY
4673: CURSOR validate_k_bank_account (cp_khr_id IN okc_k_headers_all_b.id%TYPE) IS
4674: SELECT DECODE (SIGN ( TRUNC (SYSDATE) - pym_instr.start_date),-1, 'I',
4675: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (pym_instr.end_date, TRUNC (SYSDATE))),1, 'I','A')) instr_status,
4676: bnk.bank_account_number,
4677: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (bnk.start_date, TRUNC (SYSDATE))), -1, 'I',

Line 4788: l_auth_org_id okc_k_headers_all_b.authoring_org_id%TYPE;

4784:
4785: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
4786: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
4787: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
4788: l_auth_org_id okc_k_headers_all_b.authoring_org_id%TYPE;
4789: l_pdt_id okl_products.id%TYPE;
4790: l_aes_id okl_products.aes_id%TYPE;
4791: l_chart_of_accounts_id NUMBER;
4792: l_instr_assignment_id NUMBER;