APPS.OKC_PRICE_PVT dependencies on OKC_K_HEADERS_B

Line 502: From okc_k_headers_b

498: If p_lowest_level = -2 then
499: Begin
500: Select object_version_number,estimated_amount,total_line_list_price
501: into l_obj,l_amt,l_list_price
502: From okc_k_headers_b
503: where id=p_chr_id;
504: IF (l_debug = 'Y') THEN
505: my_debug('1300 : select rowcount for header should be 1: '||SQL%ROWCOUNT, 1);
506: my_debug('1310 : old amount on header'||l_amt, 1);

Line 748: PROCEDURE validate_covered_line_qty ( p_chr_id IN okc_k_headers_b.ID%TYPE,

744: -- Out Parameters: x_return_status
745: --
746: -- Comments: This procedure is to be called only by QA
747:
748: PROCEDURE validate_covered_line_qty ( p_chr_id IN okc_k_headers_b.ID%TYPE,
749: p_cle_id IN okc_k_lines_b.ID%TYPE,
750: p_l_id_tbl IN num_tbl_type,
751: p_l_cle_id_tbl IN num_tbl_type,
752: p_l_line_number_tbl IN char_tbl_type,

Line 1155: From okc_k_headers_b

1151: -- do rollups
1152: Begin
1153: Select object_version_number,estimated_amount,total_line_list_price
1154: into l_obj,l_amt,l_list_price
1155: From okc_k_headers_b
1156: where id=p_chr_id;
1157: l_chr_rec.id := p_chr_id;
1158: l_chr_rec.object_version_number := l_obj;
1159: l_chr_rec.estimated_amount := null;

Line 3047: from okc_k_headers_b

3043: OKC_PRICE_PUB.G_CONTRACT_INFO:=null;
3044: Begin
3045: select INV_ORGANIZATION_ID,price_list_id,authoring_org_id,nvl(pricing_date,sysdate)
3046: into OKC_PRICE_PUB.G_CONTRACT_INFO.INV_ORG_ID , l_price_list_id,g_authoring_org_id,OKC_PRICE_PUB.G_CONTRACT_INFO.PRICING_DATE
3047: from okc_k_headers_b
3048: where id = p_chr_id;
3049:
3050: EXCEPTION
3051: when no_data_found then

Line 3886: from okc_k_headers_b

3882:
3883: Begin
3884: select INV_ORGANIZATION_ID
3885: into OKC_PRICE_PUB.G_CONTRACT_INFO.INV_ORG_ID
3886: from okc_k_headers_b
3887: where id = p_chr_id;
3888: IF (l_debug = 'Y') THEN
3889: my_debug('11290 : rowcount'||SQL%ROWCOUNT, 1);
3890: END IF;

Line 6783: from okc_k_headers_b

6779: -- create header request line everytime irrespective of p_level
6780: Begin
6781: select currency_code
6782: into l_curr
6783: from okc_k_headers_b
6784: where id = p_chr_id;
6785: IF (l_debug = 'Y') THEN
6786: my_debug('16750 : select rowcount'||SQL%ROWCOUNT, 1);
6787: END IF;