DBA Data[Home] [Help]

APPS.OKC_PHI_PVT dependencies on OKC_PH_LINE_BREAKS_V

Line 28: l_ph_line_breaks_tbl okc_phl_pvt.okc_ph_line_breaks_v_tbl_type;

24: l_qp_ph_relship_tbl l_qp_ph_relship_tbl_type ; -- table to keep relationship between modifier heaer/line to Contract line
25:
26: l_clev_tbl okc_cle_pvt.clev_tbl_type ;
27: lx_clev_tbl okc_cle_pvt.clev_tbl_type ;
28: l_ph_line_breaks_tbl okc_phl_pvt.okc_ph_line_breaks_v_tbl_type;
29: lx_ph_line_breaks_tbl okc_phl_pvt.okc_ph_line_breaks_v_tbl_type;
30: l_call_qp_api boolean := false;
31: l_cust_found boolean := false;
32:

Line 29: lx_ph_line_breaks_tbl okc_phl_pvt.okc_ph_line_breaks_v_tbl_type;

25:
26: l_clev_tbl okc_cle_pvt.clev_tbl_type ;
27: lx_clev_tbl okc_cle_pvt.clev_tbl_type ;
28: l_ph_line_breaks_tbl okc_phl_pvt.okc_ph_line_breaks_v_tbl_type;
29: lx_ph_line_breaks_tbl okc_phl_pvt.okc_ph_line_breaks_v_tbl_type;
30: l_call_qp_api boolean := false;
31: l_cust_found boolean := false;
32:
33: --------------------------------------------------------------------------------------

Line 141: FROM okc_ph_line_breaks_v

137: value_to,
138: value,
139: qp_reference_id,
140: integrated_with_qp
141: FROM okc_ph_line_breaks_v
142: WHERE cle_id=b_ph_line_id
143: AND nvl(integrated_with_qp,'N')='N'
144: order by id;
145:

Line 925: p_okc_ph_line_breaks_v_tbl =>l_ph_line_breaks_tbl,

921: p_init_msg_list => FND_API.G_FALSE,
922: x_return_status => l_return_status,
923: x_msg_count => x_msg_count,
924: x_msg_data => x_msg_data,
925: p_okc_ph_line_breaks_v_tbl =>l_ph_line_breaks_tbl,
926: x_okc_ph_line_breaks_v_tbl =>lx_ph_line_breaks_tbl);
927: IF (l_debug = 'Y') THEN
928: okc_util.print_trace(2,'End OKC_PHL_PVT.update_row:Status'||l_return_status);
929: END IF;

Line 926: x_okc_ph_line_breaks_v_tbl =>lx_ph_line_breaks_tbl);

922: x_return_status => l_return_status,
923: x_msg_count => x_msg_count,
924: x_msg_data => x_msg_data,
925: p_okc_ph_line_breaks_v_tbl =>l_ph_line_breaks_tbl,
926: x_okc_ph_line_breaks_v_tbl =>lx_ph_line_breaks_tbl);
927: IF (l_debug = 'Y') THEN
928: okc_util.print_trace(2,'End OKC_PHL_PVT.update_row:Status'||l_return_status);
929: END IF;
930:

Line 1208: FROM okc_ph_line_breaks_v

1204: Cursor c_ph_line_break(b_ph_line_id Number) IS
1205: SELECT id ,
1206: qp_reference_id,
1207: integrated_with_qp
1208: FROM okc_ph_line_breaks_v
1209: WHERE cle_id=b_ph_line_id
1210: AND qp_reference_id is not null
1211: order by id;
1212: