APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on OKS_K_HEADERS_B

Line 47: oks_k_headers_b sh

43: fnd_currency.get_format_mask (ch.currency_code, 50)) ||
44: ' ' ||
45: ch.currency_code AS amount
46: FROM okc_k_headers_all_b ch,
47: oks_k_headers_b sh
48: WHERE ch.ID = sh.chr_id
49: AND ch.ID = p_chr_id;
50: BEGIN
51: -- start debug log

Line 185: oks_k_headers_b sh

181: fnd_currency.get_format_mask (ch.currency_code, 50)) ||
182: ' ' ||
183: ch.currency_code AS amount
184: FROM okc_k_headers_all_b ch,
185: oks_k_headers_b sh
186: WHERE ch.ID = sh.chr_id
187: AND ch.ID = p_chr_id;
188:
189: BEGIN

Line 1841: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;

1837: '/' ||
1838: p_year, 'MM/YYYY'))
1839: FROM DUAL;
1840:
1841: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
1842: l_billing_address_id hz_party_sites.party_site_id%TYPE;
1843: l_expiration_date DATE := '';
1844:
1845: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;

Line 2125: UPDATE oks_k_headers_b

2121: RAISE fnd_api.g_exc_error;
2122: END IF;
2123:
2124: -- update OKC and OKS entities
2125: UPDATE oks_k_headers_b
2126: SET payment_type = p_payment_type,
2127: trxn_extension_id = l_trxn_extension_id,
2128: commitment_id = NULL,
2129: object_version_number = object_version_number +

Line 2149: UPDATE oks_k_headers_b

2145: last_updated_by = fnd_global.user_id,
2146: last_update_login = fnd_global.login_id
2147: WHERE ID = p_chr_id;
2148: ELSIF p_payment_type = 'COM' THEN
2149: UPDATE oks_k_headers_b
2150: SET payment_type = p_payment_type,
2151: commitment_id = p_payment_details,
2152: trxn_extension_id = NULL,
2153: object_version_number = object_version_number +

Line 2171: UPDATE oks_k_headers_b

2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id
2169: WHERE ID = p_chr_id;
2170: ELSE
2171: UPDATE oks_k_headers_b
2172: SET payment_type = NULL,
2173: trxn_extension_id = NULL,
2174: commitment_id = NULL,
2175: object_version_number = object_version_number +

Line 2488: l_curr_payment oks_k_headers_b.payment_type%TYPE

2484: l_k_amount NUMBER (15, 2);
2485: l_k_curr VARCHAR2 (100);
2486: l_curr_instrument okc_k_headers_all_b.payment_instruction_type%TYPE
2487: := '';
2488: l_curr_payment oks_k_headers_b.payment_type%TYPE
2489: := '';
2490: l_k_current_payments VARCHAR2 (2000) := '';
2491:
2492: CURSOR csr_k_amt_curr IS

Line 2498: oks_k_headers_b sh

2494: ch.currency_code AS currency_code,
2495: ch.payment_instruction_type AS instrument_type,
2496: sh.payment_type AS payment_type
2497: FROM okc_k_headers_all_b ch,
2498: oks_k_headers_b sh
2499: WHERE ch.ID = sh.chr_id
2500: AND ch.ID = p_chr_id;
2501:
2502: CURSOR csr_curr_payment IS

Line 2504: FROM oks_k_headers_b

2500: AND ch.ID = p_chr_id;
2501:
2502: CURSOR csr_curr_payment IS
2503: SELECT payment_type
2504: FROM oks_k_headers_b
2505: WHERE chr_id = p_chr_id;
2506:
2507: --cgopinee bugfix for 7443435
2508: CURSOR csr_chk_effective_payments(l_valid_payments IN VARCHAR2) IS

Line 3858: oks_k_headers_b oks,

3854: SELECT oks.trxn_extension_id,
3855: ca.cust_account_id,
3856: ca.party_id
3857: FROM okc_k_headers_all_b okc,
3858: oks_k_headers_b oks,
3859: hz_cust_site_uses_all su,
3860: hz_cust_acct_sites_all sa,
3861: hz_cust_accounts_all ca
3862: WHERE oks.chr_id = okc.ID

Line 3871: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;

3867: AND okc.ID = p_chr_id;
3868:
3869: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;
3870: l_party_id hz_cust_accounts_all.party_id%TYPE;
3871: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
3872:
3873: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;
3874:
3875: l_payer l_payer_type;