APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_K_HEADERS_B

Line 231: OKS_K_HEADERS_B

227:
228: CURSOR l_renewal_sts_csr IS
229: SELECT renewal_status
230: FROM
231: OKS_K_HEADERS_B
232: WHERE
233: chr_id = p_chr_id;
234:
235: l_renewal_sts VARCHAR2(30);

Line 369: OKS_K_HEADERS_B

365: -- Gets service PO from SPO rules.
366: CURSOR rules_cur IS
367: SELECT SERVICE_PO_NUMBER sr_po_num, SERVICE_PO_REQUIRED sr_po_flag
368: FROM
369: OKS_K_HEADERS_B
370: WHERE chr_id = p_chr_id;
371:
372: l_sr_po_flag VARCHAR2(3);
373: l_sr_po_num VARCHAR2(150);

Line 541: SELECT RENEWAL_PRICE_LIST FROM OKS_K_HEADERS_B

537: -- GCHADHA --
538: -- BUG 4048186 --
539:
540: CURSOR get_renewal_info(p_chr_id IN NUMBER) IS
541: SELECT RENEWAL_PRICE_LIST FROM OKS_K_HEADERS_B
542: WHERE CHR_ID = p_chr_id;
543:
544: l_renewal_price_list_id NUMBER;
545:

Line 731: l_inv_trx_type oks_k_headers_b.inv_trx_type%TYPE;

727:
728:
729: l_org_id NUMBER;
730: l_tax_method zx_product_options_all.tax_method_code%TYPE;
731: l_inv_trx_type oks_k_headers_b.inv_trx_type%TYPE;
732: l_api_name CONSTANT VARCHAR2(30) := 'Check_Inv_Trx';
733: l_mod_name VARCHAR2(256) := G_APP_NAME || '.PLSQL.' || G_PKG_NAME || '.' || l_api_name;
734:
735: BEGIN

Line 760: FROM oks_k_headers_b

756: END IF;
757:
758: IF l_tax_method = 'LTE' THEN
759: SELECT inv_trx_type INTO l_inv_trx_type
760: FROM oks_k_headers_b
761: WHERE id = p_chr_id;
762:
763: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_mod_name,'latin tax, l_inv_trx_type: '|| l_inv_trx_type);

Line 2963: OKS_K_HEADERS_B OKS

2959: start_date,
2960: end_date
2961: FROM
2962: okc_k_headers_all_b OKC,
2963: OKS_K_HEADERS_B OKS
2964: WHERE
2965: OKC.id = p_chr_id AND
2966: OKC.ID = OKS.chr_id
2967: AND (exempt_certificate_number IS NOT NULL

Line 2982: FROM OKS_K_HEADERS_B

2978:
2979: CURSOR Cur_Inv_Trx_Type(p_chr_id IN NUMBER)
2980: IS
2981: SELECT inv_trx_type
2982: FROM OKS_K_HEADERS_B
2983: WHERE OKS_K_HEADERS_B.id = p_chr_id;
2984:
2985: CURSOR cust_acct_csr(p_site_use_id NUMBER) IS
2986: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID

Line 2983: WHERE OKS_K_HEADERS_B.id = p_chr_id;

2979: CURSOR Cur_Inv_Trx_Type(p_chr_id IN NUMBER)
2980: IS
2981: SELECT inv_trx_type
2982: FROM OKS_K_HEADERS_B
2983: WHERE OKS_K_HEADERS_B.id = p_chr_id;
2984:
2985: CURSOR cust_acct_csr(p_site_use_id NUMBER) IS
2986: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID
2987: FROM

Line 3046: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;

3042: l_bill_to_cust_acct_id NUMBER;
3043: l_bill_to_party_id NUMBER;
3044: l_legal_entity_id NUMBER;
3045: l_org_id NUMBER;
3046: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;
3047: l_cust_trx_type_id NUMBER;
3048: l_batch_source_id NUMBER;
3049:
3050: l_valid_flag VARCHAR2(1);

Line 4760: FROM oks_k_headers_b s,

4756: s.payment_type,
4757: NVL(c.org_id, c.authoring_org_id) org_id,
4758: c.currency_code,
4759: c.bill_to_site_use_id
4760: FROM oks_k_headers_b s,
4761: okc_k_headers_all_b c
4762: WHERE s.chr_id = c.id
4763: AND c.id = p_chr_id;
4764:

Line 5099: UPDATE oks_k_headers_b

5095:
5096: --Go on to update_Authorization Info of the header
5097: --we directly update instead of using public API to avoid locking issues
5098: --auth code could come from either IBY_FNDCPT_TRXN_PUB.Get_Authorization or IBY_FNDCPT_TRXN_PUB.Create_Authorization
5099: UPDATE oks_k_headers_b
5100: SET cc_auth_code = l_auth_result.auth_code
5101: WHERE id = l_oks_header_rec.id;
5102:
5103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN