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 3032: OKS_K_HEADERS_B OKS

3028: start_date,
3029: end_date
3030: FROM
3031: okc_k_headers_all_b OKC,
3032: OKS_K_HEADERS_B OKS
3033: WHERE
3034: OKC.id = p_chr_id AND
3035: OKC.ID = OKS.chr_id
3036: AND (exempt_certificate_number IS NOT NULL

Line 3051: FROM OKS_K_HEADERS_B

3047:
3048: CURSOR Cur_Inv_Trx_Type(p_chr_id IN NUMBER)
3049: IS
3050: SELECT inv_trx_type
3051: FROM OKS_K_HEADERS_B
3052: WHERE OKS_K_HEADERS_B.id = p_chr_id;
3053:
3054: CURSOR cust_acct_csr(p_site_use_id NUMBER) IS
3055: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID

Line 3052: WHERE OKS_K_HEADERS_B.id = p_chr_id;

3048: CURSOR Cur_Inv_Trx_Type(p_chr_id IN NUMBER)
3049: IS
3050: SELECT inv_trx_type
3051: FROM OKS_K_HEADERS_B
3052: WHERE OKS_K_HEADERS_B.id = p_chr_id;
3053:
3054: CURSOR cust_acct_csr(p_site_use_id NUMBER) IS
3055: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID
3056: FROM

Line 3115: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;

3111: l_bill_to_cust_acct_id NUMBER;
3112: l_bill_to_party_id NUMBER;
3113: l_legal_entity_id NUMBER;
3114: l_org_id NUMBER;
3115: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;
3116: l_cust_trx_type_id NUMBER;
3117: l_batch_source_id NUMBER;
3118:
3119: l_valid_flag VARCHAR2(1);

Line 4907: FROM oks_k_headers_b s,

4903: s.payment_type,
4904: NVL(c.org_id, c.authoring_org_id) org_id,
4905: c.currency_code,
4906: c.bill_to_site_use_id
4907: FROM oks_k_headers_b s,
4908: okc_k_headers_all_b c
4909: WHERE s.chr_id = c.id
4910: AND c.id = p_chr_id;
4911:

Line 5246: UPDATE oks_k_headers_b

5242:
5243: --Go on to update_Authorization Info of the header
5244: --we directly update instead of using public API to avoid locking issues
5245: --auth code could come from either IBY_FNDCPT_TRXN_PUB.Get_Authorization or IBY_FNDCPT_TRXN_PUB.Create_Authorization
5246: UPDATE oks_k_headers_b
5247: SET cc_auth_code = l_auth_result.auth_code
5248: WHERE id = l_oks_header_rec.id;
5249:
5250: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN