eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_PRICE_PVT dependencies on OKC_PRICE_ADJUSTMENT_PUB

Line 191: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

187:
188: l_rowlevel number :=0;
189: l_p_found boolean :=false;
190:
191: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
192: lx_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
193: BEGIN
194: IF (l_debug = 'Y') THEN
195: okc_debug.Set_Indentation('Update_line_PRICE');

Line 192: lx_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

188: l_rowlevel number :=0;
189: l_p_found boolean :=false;
190:
191: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
192: lx_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
193: BEGIN
194: IF (l_debug = 'Y') THEN
195: okc_debug.Set_Indentation('Update_line_PRICE');
196: END IF;

Line 616: OKC_PRICE_ADJUSTMENT_PUB.update_price_adjustment(

612: IF (l_debug = 'Y') THEN
613: my_debug('1378 : Before calling update price adjustment '||l_return_status, 1);
614: END IF;
615:
616: OKC_PRICE_ADJUSTMENT_PUB.update_price_adjustment(
617: p_api_version => p_api_version,
618: x_return_status => l_return_status ,
619: x_msg_count => x_msg_count,
620: x_msg_data => x_msg_data,

Line 4488: l_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;

4484: i pls_integer :=0;
4485: j pls_integer :=0;
4486: k pls_integer :=0;
4487:
4488: l_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4489: l_patv_dummy_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4490:
4491: lx_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

Line 4489: l_patv_dummy_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;

4485: j pls_integer :=0;
4486: k pls_integer :=0;
4487:
4488: l_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4489: l_patv_dummy_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4490:
4491: lx_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
4493: l_new_pat_tbl num_tbl_type;

Line 4491: lx_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;

4487:
4488: l_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4489: l_patv_dummy_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4490:
4491: lx_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
4493: l_new_pat_tbl num_tbl_type;
4494: -- l_new_detail_tbl num_tbl_type;
4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

Line 4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

4488: l_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4489: l_patv_dummy_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4490:
4491: lx_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
4493: l_new_pat_tbl num_tbl_type;
4494: -- l_new_detail_tbl num_tbl_type;
4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4496: l_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

Line 4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

4491: lx_patv_rec OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type;
4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
4493: l_new_pat_tbl num_tbl_type;
4494: -- l_new_detail_tbl num_tbl_type;
4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4496: l_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4497: lx_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4498: lx_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4499:

Line 4496: l_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

4492: l_patv_tbl OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
4493: l_new_pat_tbl num_tbl_type;
4494: -- l_new_detail_tbl num_tbl_type;
4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4496: l_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4497: lx_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4498: lx_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4499:
4500: TYPE CHAR_TBL_TYPE is TABLE of varchar2(240) INDEX BY BINARY_INTEGER;

Line 4497: lx_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

4493: l_new_pat_tbl num_tbl_type;
4494: -- l_new_detail_tbl num_tbl_type;
4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4496: l_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4497: lx_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4498: lx_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4499:
4500: TYPE CHAR_TBL_TYPE is TABLE of varchar2(240) INDEX BY BINARY_INTEGER;
4501:

Line 4498: lx_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

4494: -- l_new_detail_tbl num_tbl_type;
4495: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4496: l_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4497: lx_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
4498: lx_paav_tbl OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
4499:
4500: TYPE CHAR_TBL_TYPE is TABLE of varchar2(240) INDEX BY BINARY_INTEGER;
4501:
4502:

Line 4567: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(

4563: l:=l_id_tbl.next(l);
4564: end loop;
4565: k:=p_id_tbl.next(k);
4566: end loop;
4567: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(
4568: p_api_version => p_api_version,
4569: x_return_status => l_return_status ,
4570: x_msg_count => x_msg_count,
4571: x_msg_data => x_msg_data,

Line 4634: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(

4630: l:=l_id_tbl.next(l);
4631: end loop;
4632: k:=p_id_tbl.next(k);
4633: end loop;
4634: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(
4635: p_api_version => p_api_version,
4636: x_return_status => l_return_status ,
4637: x_msg_count => x_msg_count,
4638: x_msg_data => x_msg_data,

Line 4788: my_debug('14350 : before calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib count '||l_paav_tbl.count, 1);

4784:
4785: k:=p_Req_LINE_DETAIL_attr_tbl.next(k);
4786: end loop;
4787: IF (l_debug = 'Y') THEN
4788: my_debug('14350 : before calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib count '||l_paav_tbl.count, 1);
4789: END IF;
4790: If l_paav_tbl.count >0 then
4791: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib(
4792: --OKC_PAA_PVT.INSERT_ROW(

Line 4791: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib(

4787: IF (l_debug = 'Y') THEN
4788: my_debug('14350 : before calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib count '||l_paav_tbl.count, 1);
4789: END IF;
4790: If l_paav_tbl.count >0 then
4791: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib(
4792: --OKC_PAA_PVT.INSERT_ROW(
4793: p_api_version => p_api_version,
4794: x_return_status => l_return_status ,
4795: x_msg_count => x_msg_count,

Line 4800: my_debug('14352 : after calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib '||l_return_status, 1);

4796: x_msg_data => x_msg_data,
4797: p_paav_tbl => l_paav_tbl,
4798: x_paav_tbl => lx_paav_tbl);
4799: IF (l_debug = 'Y') THEN
4800: my_debug('14352 : after calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib '||l_return_status, 1);
4801: END IF;
4802:
4803: l_paav_tbl.delete;
4804: End if; --l_paav_tbl.count

Line 4841: px_patv_rec IN OUT NOCOPY OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type

4837: p_opr IN varchar2 DEFAULT 'I' ,
4838: p_service_qty IN NUMBER DEFAULT 1,
4839: p_adj_id IN NUMBER default 0,
4840: p_obj IN NUMBER default 1,
4841: px_patv_rec IN OUT NOCOPY OKC_PRICE_ADJUSTMENT_PUB.patv_rec_type
4842: ) IS
4843: Begin
4844: IF (l_debug = 'Y') THEN
4845: okc_debug.Set_Indentation('LOAD_ADJ_LINES');

Line 5190: OKC_PRICE_ADJUSTMENT_PUB.update_price_adjustment(

5186: IF (l_debug = 'Y') THEN
5187: my_debug('14776 : Before calling update price adjustment '||x_return_status, 1);
5188: END IF;
5189:
5190: OKC_PRICE_ADJUSTMENT_PUB.update_price_adjustment(
5191: p_api_version => p_api_version,
5192: x_return_status => x_return_status ,
5193: x_msg_count => x_msg_count,
5194: x_msg_data => x_msg_data,

Line 5243: OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment(

5239: IF (l_debug = 'Y') THEN
5240: my_debug('14780 : before calling create price adjustment '||x_return_status, 1);
5241: END IF;
5242:
5243: OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment(
5244: p_api_version => p_api_version,
5245: x_return_status => x_return_status ,
5246: x_msg_count => x_msg_count,
5247: x_msg_data => x_msg_data,

Line 5303: p_pacv_rec okc_price_adjustment_pub.pacv_rec_type;

5299: where pat_id_from = p_pat_id_from
5300: and pat_id =p_pat_id
5301: and cle_id = p_cle_id;
5302:
5303: p_pacv_rec okc_price_adjustment_pub.pacv_rec_type;
5304: x_pacv_rec okc_price_adjustment_pub.pacv_rec_type;
5305: l_id number;
5306: p_pat_id_from number;
5307: p_pat_id number;

Line 5304: x_pacv_rec okc_price_adjustment_pub.pacv_rec_type;

5300: and pat_id =p_pat_id
5301: and cle_id = p_cle_id;
5302:
5303: p_pacv_rec okc_price_adjustment_pub.pacv_rec_type;
5304: x_pacv_rec okc_price_adjustment_pub.pacv_rec_type;
5305: l_id number;
5306: p_pat_id_from number;
5307: p_pat_id number;
5308: p_cle_id number;

Line 5345: okc_price_adjustment_pub.create_price_adj_assoc(

5341: p_pacv_rec.pat_id := p_pat_id;
5342: p_pacv_rec.cle_id := p_cle_id;
5343: p_pacv_rec.pat_id_from := p_pat_id_from;
5344:
5345: okc_price_adjustment_pub.create_price_adj_assoc(
5346: p_api_version => p_api_version,
5347: x_return_status => x_return_status ,
5348: p_init_msg_list => p_init_msg_list ,
5349: x_msg_data => x_msg_data,

Line 5395: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(

5391: my_debug('14786 :before calling delete price adjustments'||x_return_status, 1);
5392: END IF;
5393:
5394: IF l_patv_tbl.count > 0 then
5395: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(
5396: p_api_version => p_api_version,
5397: x_return_status => x_return_status ,
5398: x_msg_count => x_msg_count,
5399: x_msg_data => x_msg_data,