APPS.OKC_PRICE_PVT dependencies on OKC_PRICE_ADJUSTMENTS

Line 582: from OKC_PRICE_ADJUSTMENTS

578: -- just have % adjustments on header and that also in bucket 1 only
579: -- If this changes, then revisit this code
580: select id,operand,arithmetic_operator,object_version_number,adjusted_amount
581: bulk collect into l_pat_id_tbl,l_operand_tbl,l_operator_tbl,l_obj_tbl,l_value_tbl
582: from OKC_PRICE_ADJUSTMENTS
583: where chr_id=p_chr_id and cle_id is null;
584: IF (l_debug = 'Y') THEN
585: my_debug('1370 : header adjustments select rowcount'||SQL%ROWCOUNT, 1);
586: END IF;

Line 4988: from OKC_PRICE_ADJUSTMENTS

4984:
4985: while i is not null loop
4986: select cle_id,id,list_line_no,list_header_id,object_version_number
4987: bulk collect into l_id_tmp_tbl,l_pat_tmp_tbl,l_line_tmp_tbl,l_list_tmp_tbl,l_obj_tmp_tbl
4988: from OKC_PRICE_ADJUSTMENTS
4989: where cle_id=p_cle_price_tbl(i).id and chr_id=p_chr_id;
4990: IF (l_debug = 'Y') THEN
4991: my_debug('14710 :line adjustments select rowcount'||SQL%ROWCOUNT, 1);
4992: END IF;

Line 5016: from OKC_PRICE_ADJUSTMENTS

5012: If p_control_rec.p_level = 'H' and p_chr_id is not null then
5013: -- we donot want to touch the header adjustments if only one line is getting repriced
5014: select chr_id,id,list_line_no,list_header_id,object_version_number
5015: bulk collect into l_id_tmp_tbl,l_pat_tmp_tbl,l_line_tmp_tbl,l_list_tmp_tbl,l_obj_tmp_tbl
5016: from OKC_PRICE_ADJUSTMENTS
5017: where chr_id=p_chr_id and cle_id is null;
5018: IF (l_debug = 'Y') THEN
5019: my_debug('14750 : header adjustments select rowcount'||SQL%ROWCOUNT, 1);
5020: END IF;

Line 5046: from OKC_PRICE_ADJUSTMENTS

5042: If p_control_rec.p_config_yn = 'S' and p_control_rec.p_top_model_id is not null then
5043:
5044: select cle_id,id,list_line_no,list_header_id,object_version_number
5045: bulk collect into l_id_tmp_tbl,l_pat_tmp_tbl,l_line_tmp_tbl,l_list_tmp_tbl,l_obj_tmp_tbl
5046: from OKC_PRICE_ADJUSTMENTS
5047: where cle_id=p_control_rec.p_top_model_id and chr_id=p_chr_id;
5048: IF (l_debug = 'Y') THEN
5049: my_debug('14745 : top dummy line adjustments select rowcount'||SQL%ROWCOUNT, 1);
5050: END IF;

Line 6146: from okc_price_adjustments a

6142: Return varchar2 is
6143: l_return_status varchar2(1):= OKC_API.G_RET_STS_SUCCESS;
6144: cursor l_cle(p_id number,pchr_id number) is
6145: select *
6146: from okc_price_adjustments a
6147: where
6148: cle_id = p_id and chr_id=pchr_id
6149: and applied_flag='Y'
6150: --do not process child detail lines -- tope pbh changes

Line 6162: from okc_price_adjustments

6158:
6159:
6160: cursor l_chr(p_id number) is
6161: select *
6162: from okc_price_adjustments
6163: where
6164: chr_id = p_id and cle_id is null --???ask sripriya do we just send manual.(what about overrides)
6165: and applied_flag='Y';
6166:

Line 6170: from okc_price_adj_assocs_v a, okc_price_adjustments b

6166:
6167:
6168: cursor l_related_lines(p_pat_id number,p_cle_id number) is
6169: select b.*
6170: from okc_price_adj_assocs_v a, okc_price_adjustments b
6171: where a.pat_id_from =p_pat_id
6172: and a.pat_id = b.id
6173: and a.cle_id =p_cle_id
6174: and a.cle_id = b.cle_id;

Line 6275: Update okc_price_adjustments

6271: If (nvl(l_related_row.range_break_quantity,-99) = l_row.range_break_quantity
6272: and l_related_row.adjusted_amount is not null )
6273:
6274: Then
6275: Update okc_price_adjustments
6276: set applied_flag = 'Y',
6277: operand = l_row.operand,
6278: updated_flag = 'Y'
6279: where id = l_related_row.id;

Line 6281: Update okc_price_adjustments

6277: operand = l_row.operand,
6278: updated_flag = 'Y'
6279: where id = l_related_row.id;
6280: Else
6281: Update okc_price_adjustments
6282: set updated_flag = 'Y'
6283: where id = l_related_row.id;
6284: End If;
6285: End loop;