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 1840: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;

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

Line 2124: UPDATE oks_k_headers_b

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

Line 2148: UPDATE oks_k_headers_b

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

Line 2170: UPDATE oks_k_headers_b

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

Line 2486: l_curr_payment oks_k_headers_b.payment_type%TYPE

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

Line 2496: oks_k_headers_b sh

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

Line 2502: FROM oks_k_headers_b

2498: AND ch.ID = p_chr_id;
2499:
2500: CURSOR csr_curr_payment IS
2501: SELECT payment_type
2502: FROM oks_k_headers_b
2503: WHERE chr_id = p_chr_id;
2504: BEGIN
2505: -- start debug log
2506: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3810: oks_k_headers_b oks,

3806: SELECT oks.trxn_extension_id,
3807: ca.cust_account_id,
3808: ca.party_id
3809: FROM okc_k_headers_all_b okc,
3810: oks_k_headers_b oks,
3811: hz_cust_site_uses_all su,
3812: hz_cust_acct_sites_all sa,
3813: hz_cust_accounts_all ca
3814: WHERE oks.chr_id = okc.ID

Line 3823: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;

3819: AND okc.ID = p_chr_id;
3820:
3821: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;
3822: l_party_id hz_cust_accounts_all.party_id%TYPE;
3823: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
3824:
3825: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;
3826:
3827: l_payer l_payer_type;