APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_K_HEADERS_B

Line 1102: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c

1098: a.conversion_euro_rate, b.inv_trx_type, b.ar_interface_yn,
1099: b.summary_trx_yn, b.hold_billing, a.inv_organization_id,
1100: a.scs_code, c.ste_code source_ste_code, b.period_start,
1101: b.period_type, b.price_uom, a.billed_at_source
1102: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1103: WHERE a.ID = l_chr_id AND a.ID = b.chr_id AND p_sts_code = c.code;
1104:
1105: -- and c.ste_code in ('ACTIVE','ENTERED','SIGNED');
1106:

Line 1134: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c

1130: l_billed_at_source VARCHAR2
1131: )
1132: IS
1133: SELECT a.ID
1134: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1135: WHERE a.ID = l_target_chr_id
1136: AND a.ID = b.chr_id
1137: AND a.sts_code= c.code --Bug fix 5614310
1138: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 8203: UPDATE oks_k_headers_b

8199: SET tax_amount = tax_amount + l_newtax
8200: WHERE cle_id = l_lineid;
8201:
8202: -- Update header tax amount
8203: UPDATE oks_k_headers_b
8204: SET tax_amount = tax_amount + l_newtax
8205: WHERE chr_id = p_kdtl_tbl (l_ctr).hdr_id;
8206: END IF;
8207:

Line 9288: FROM okc_k_headers_b Kh, oks_k_headers_b Ks

9284:
9285: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)
9286: IS
9287: SELECT 'Y'
9288: FROM okc_k_headers_b Kh, oks_k_headers_b Ks
9289: , okc_statuses_b sts
9290: WHERE Kh.ID = p_hdr_id
9291: And Ks.chr_id = Kh.id
9292: And kh.sts_code = sts.code

Line 12436: UPDATE oks_k_headers_b

12432: l_merge_chr_id
12433: AND lse_id IN (1, 19))
12434: WHERE ID = l_merge_chr_id;
12435:
12436: UPDATE oks_k_headers_b
12437: SET tax_amount =
12438: NVL (tax_amount, 0)
12439: + NVL ((SELECT tax_amount
12440: FROM oks_k_lines_b

Line 12975: UPDATE oks_k_headers_b

12971: l_merge_chr_id
12972: AND lse_id IN (1, 19))
12973: WHERE ID = l_merge_chr_id;
12974:
12975: UPDATE oks_k_headers_b
12976: SET tax_amount =
12977: NVL (tax_amount, 0)
12978: + NVL ((SELECT tax_amount
12979: FROM oks_k_lines_b

Line 13464: UPDATE oks_k_headers_b

13460: WHERE dnz_chr_id = l_chr_id
13461: AND lse_id IN (1, 19))
13462: WHERE ID = l_chr_id;
13463:
13464: UPDATE oks_k_headers_b
13465: SET tax_amount =
13466: NVL (tax_amount, 0)
13467: + NVL ((SELECT tax_amount
13468: FROM oks_k_lines_b

Line 15850: UPDATE oks_k_headers_b

15846: AND date_cancelled IS NULL )
15847: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
15848:
15849:
15850: UPDATE oks_k_headers_b
15851: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
15852: FROM oks_k_lines_b
15853: WHERE cle_id IN (SELECT id
15854: FROM okc_k_lineS_b

Line 16329: UPDATE oks_k_headers_b

16325: AND lse_id IN (1, 19)
16326: AND date_cancelled IS NULL)
16327: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16328:
16329: UPDATE oks_k_headers_b
16330: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16331: FROM oks_k_lines_b
16332: WHERE cle_id IN (SELECT id
16333: FROM okc_k_lineS_b

Line 16543: UPDATE oks_k_headers_b

16539: AND date_cancelled IS NULL)
16540: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16541:
16542:
16543: UPDATE oks_k_headers_b
16544: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16545: FROM oks_k_lines_b
16546: WHERE cle_id IN (SELECT id
16547: FROM okc_k_lineS_b