DBA Data[Home] [Help]

APPS.OKL_QUICK_QUOTES_PVT dependencies on OKL_QQL_PVT

Line 225: okl_qql_pvt.insert_row(p_api_version

221: ,x_return_status => x_return_status); -- check if activity started successfully
222:
223: lp_qqlv_tbl_type := p_qqlv_tbl_type;
224:
225: okl_qql_pvt.insert_row(p_api_version
226: ,okl_api.g_false
227: ,l_return_status
228: ,x_msg_count
229: ,x_msg_data

Line 236: ,'okl_qql_pvt.insert_row returned with status ' ||

232:
233: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
234: okl_debug_pub.log_debug(fnd_log.level_statement
235: ,l_module
236: ,'okl_qql_pvt.insert_row returned with status ' ||
237: l_return_status ||
238: ' x_msg_data ' ||
239: x_msg_data);
240:

Line 712: okl_qql_pvt.update_row(p_api_version

708: ,x_return_status => x_return_status); -- check if activity started successfully
709:
710: IF lp_qqlv_tbl_type.COUNT > 0 THEN
711:
712: okl_qql_pvt.update_row(p_api_version
713: ,okl_api.g_false
714: ,l_return_status
715: ,x_msg_count
716: ,x_msg_data

Line 722: ,'okl_qql_pvt.update_row returned with status ' ||

718: ,lx_qqlv_tbl_type); -- write to log
719: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
720: okl_debug_pub.log_debug(fnd_log.level_statement
721: ,l_module
722: ,'okl_qql_pvt.update_row returned with status ' ||
723: l_return_status ||
724: ' x_msg_data ' ||
725: x_msg_data);
726: END IF; -- end of l_debug_enabled ='Y'

Line 947: okl_qql_pvt.delete_row(

943: ,p_api_version => p_api_version
944: ,p_api_type => g_api_type
945: ,x_return_status => x_return_status); -- check if activity started successfully
946:
947: okl_qql_pvt.delete_row(
948: p_api_version => p_api_version,
949: p_init_msg_list => p_init_msg_list,
950: x_return_status => l_return_status,
951: x_msg_count => x_msg_count,

Line 958: ,'okl_qql_pvt.delete_row returned with status ' ||

954:
955: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
956: okl_debug_pub.log_debug(fnd_log.level_statement
957: ,l_module
958: ,'okl_qql_pvt.delete_row returned with status ' ||
959: l_return_status ||
960: ' x_msg_data ' ||
961: x_msg_data);
962: END IF; -- end of l_debug_enabled ='Y'

Line 1044: okl_qql_pvt.delete_row(

1040: ,p_api_version => p_api_version
1041: ,p_api_type => g_api_type
1042: ,x_return_status => x_return_status); -- check if activity started successfully
1043:
1044: okl_qql_pvt.delete_row(
1045: p_api_version => p_api_version,
1046: p_init_msg_list => p_init_msg_list,
1047: x_return_status => l_return_status,
1048: x_msg_count => x_msg_count,

Line 1055: ,'okl_qql_pvt.delete_row returned with status ' ||

1051:
1052: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
1053: okl_debug_pub.log_debug(fnd_log.level_statement
1054: ,l_module
1055: ,'okl_qql_pvt.delete_row returned with status ' ||
1056: l_return_status ||
1057: ' x_msg_data ' ||
1058: x_msg_data);
1059: END IF; -- end of l_debug_enabled ='Y'

Line 1462: okl_qql_pvt.delete_row(p_api_version,

1458: lxx_qqlv_tbl_type(l_line_no).id := quick_quote_line_id.id;
1459: l_line_no := l_line_no +1;
1460: END LOOP;
1461:
1462: okl_qql_pvt.delete_row(p_api_version,
1463: p_init_msg_list,
1464: x_return_status,
1465: x_msg_count,
1466: x_msg_data,

Line 1481: okl_qql_pvt.insert_row(p_api_version

1477: FOR l_count IN l_qqlv_tbl_type.first .. l_qqlv_tbl_type.last LOOP
1478: -- IF (l_qqlv_tbl_type(l_count).id is null) THEN
1479: l_qqlv_tbl_type(l_count).quick_quote_id:=lx_qqhv_rec_type.id;
1480: -- insert the record
1481: okl_qql_pvt.insert_row(p_api_version
1482: ,okl_api.g_false
1483: ,x_return_status
1484: ,x_msg_count
1485: ,x_msg_data

Line 1819: okl_qql_pvt.insert_row(p_api_version

1815: lp_qqlv_rec.BASIS:='FIXED';
1816: lp_qqlv_rec.VALUE:=round(pricing_results_table(i).subsidy, l_precision);
1817: lp_qqlv_rec.quick_quote_id:=lx_qqhv_rec_type.id;
1818:
1819: okl_qql_pvt.insert_row(p_api_version
1820: ,okl_api.g_false
1821: ,x_return_status
1822: ,x_msg_count
1823: ,x_msg_data