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.OKL_QUICK_QUOTES_PVT dependencies on OKL_QUICK_QUOTES_PVT

Line 1: PACKAGE BODY OKL_QUICK_QUOTES_PVT AS

1: PACKAGE BODY OKL_QUICK_QUOTES_PVT AS
2: /* $Header: OKLRQQHB.pls 120.37.12010000.3 2008/11/13 13:33:45 kkorrapo ship $ */
3: -- subtype records used during pricing
4: SUBTYPE pricing_results_tbl_type IS OKL_PRICING_UTILS_PVT.pricing_results_tbl_type;
5: SUBTYPE yields_rec IS OKL_PRICING_UTILS_PVT.yields_rec;

Line 65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQH';

61: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type ) IS
62:
63: lp_qqhv_rec_type qqhv_rec_type;
64: lx_qqhv_rec_type qqhv_rec_type;
65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQH';
66: l_debug_enabled VARCHAR2(10);
67: is_debug_procedure_on BOOLEAN;
68: is_debug_statement_on BOOLEAN;
69: l_api_name CONSTANT VARCHAR2(30) := 'create_qqh';

Line 110: ,'Function okl_quick_quotes_pvt.validate_header returned with status ' ||

106:
107: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN -- write to log
108: okl_debug_pub.log_debug(fnd_log.level_statement
109: ,l_module
110: ,'Function okl_quick_quotes_pvt.validate_header returned with status ' ||
111: l_return_status);
112: END IF; -- end of l_debug_enabled ='Y'
113:
114: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 190: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQL';

186: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type) IS
187:
188: lp_qqlv_tbl_type qqlv_tbl_type;
189: lx_qqlv_tbl_type qqlv_tbl_type;
190: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQL';
191: l_debug_enabled VARCHAR2(10);
192: is_debug_procedure_on BOOLEAN;
193: is_debug_statement_on BOOLEAN;
194: l_api_name CONSTANT VARCHAR2(30) := 'create_qql';

Line 300: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QUICK_QTE';

296: lp_qqhv_rec_type qqhv_rec_type;
297: lx_qqhv_rec_type qqhv_rec_type;
298: lp_qqlv_tbl_type qqlv_tbl_type;
299: lx_qqlv_tbl_type qqlv_tbl_type;
300: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QUICK_QTE';
301: l_debug_enabled VARCHAR2(10);
302: is_debug_procedure_on BOOLEAN;
303: is_debug_statement_on BOOLEAN;
304: l_api_name CONSTANT VARCHAR2(30) := 'create_quick_qte';

Line 337: okl_quick_quotes_pvt.create_qqh(

333:
334: lp_qqhv_rec_type := p_qqhv_rec_type;
335: lp_qqlv_tbl_type := p_qqlv_tbl_type;
336:
337: okl_quick_quotes_pvt.create_qqh(
338: p_api_version => p_api_version
339: ,p_init_msg_list => okl_api.g_false
340: ,x_return_status => l_return_status
341: ,x_msg_count => x_msg_count

Line 350: ,'okl_quick_quotes_pvt.create_qqh returned with status ' ||

346:
347: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
348: okl_debug_pub.log_debug(fnd_log.level_statement
349: ,l_module
350: ,'okl_quick_quotes_pvt.create_qqh returned with status ' ||
351: l_return_status ||
352: ' x_msg_data ' ||
353: x_msg_data);
354: END IF; -- end of l_debug_enabled ='Y'

Line 366: okl_quick_quotes_pvt.create_qql(

362: FOR i in lp_qqlv_tbl_type.first..lp_qqlv_tbl_type.last LOOP
363: lp_qqlv_tbl_type(i).quick_quote_id:=lx_qqhv_rec_type.id;
364: END LOOP;
365:
366: okl_quick_quotes_pvt.create_qql(
367: p_api_version => p_api_version
368: ,p_init_msg_list => okl_api.g_false
369: ,x_return_status => l_return_status
370: ,x_msg_count => x_msg_count

Line 378: ,'okl_quick_quotes_pvt.create_qql returned with status ' ||

374:
375: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
376: okl_debug_pub.log_debug(fnd_log.level_statement
377: ,l_module
378: ,'okl_quick_quotes_pvt.create_qql returned with status ' ||
379: l_return_status ||
380: ' x_msg_data ' ||
381: x_msg_data);
382: END IF; -- end of l_debug_enabled ='Y'

Line 435: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQH';

431: ,p_qqhv_rec_type IN qqhv_rec_type
432: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type) IS
433: lp_qqhv_rec_type qqhv_rec_type;
434: lx_qqhv_rec_type qqhv_rec_type;
435: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQH';
436: l_debug_enabled VARCHAR2(10);
437: is_debug_procedure_on BOOLEAN;
438: is_debug_statement_on BOOLEAN;
439: l_api_name CONSTANT VARCHAR2(30) := 'update_qqh';

Line 569: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CANCEL_QUICK_QUOTE';

565: ,p_qqhv_rec_type IN qqhv_rec_type
566: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type) IS
567: lp_qqhv_rec_type qqhv_rec_type;
568: lx_qqhv_rec_type qqhv_rec_type;
569: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CANCEL_QUICK_QUOTE';
570: QQ_CANCELLED CONSTANT okl_quick_quotes_b.sts_code%TYPE := 'CANCELLED';
571: l_debug_enabled VARCHAR2(10);
572: is_debug_procedure_on BOOLEAN;
573: is_debug_statement_on BOOLEAN;

Line 678: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQL';

674: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type) IS
675:
676: lp_qqlv_tbl_type qqlv_tbl_type := p_qqlv_tbl_type; --dkagrawa assigned the in value
677: lx_qqlv_tbl_type qqlv_tbl_type;
678: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQL';
679: l_debug_enabled VARCHAR2(10);
680: is_debug_procedure_on BOOLEAN;
681: is_debug_statement_on BOOLEAN;
682: l_api_name CONSTANT VARCHAR2(30) := 'update_qql';

Line 786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QUICK_QTE';

782: lp_qqhv_rec_type qqhv_rec_type;
783: lx_qqhv_rec_type qqhv_rec_type;
784: lp_qqlv_tbl_type qqlv_tbl_type;
785: lx_qqlv_tbl_type qqlv_tbl_type;
786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QUICK_QTE';
787: l_debug_enabled VARCHAR2(10);
788: is_debug_procedure_on BOOLEAN;
789: is_debug_statement_on BOOLEAN;
790: l_api_name CONSTANT VARCHAR2(30) := 'update_quick_qte';

Line 821: okl_quick_quotes_pvt.update_qqh(

817:
818: lp_qqhv_rec_type := p_qqhv_rec_type;
819: lp_qqlv_tbl_type := p_qqlv_tbl_type;
820:
821: okl_quick_quotes_pvt.update_qqh(
822: p_api_version => p_api_version
823: ,p_init_msg_list => okl_api.g_false
824: ,x_return_status => l_return_status
825: ,x_msg_count => x_msg_count

Line 834: ,'okl_quick_quotes_pvt.update_qqh returned with status ' ||

830:
831: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
832: okl_debug_pub.log_debug(fnd_log.level_statement
833: ,l_module
834: ,'okl_quick_quotes_pvt.update_qqh returned with status ' ||
835: l_return_status ||
836: ' x_msg_data ' ||
837: x_msg_data);
838: END IF; -- end of l_debug_enabled ='Y'

Line 846: okl_quick_quotes_pvt.update_qql(

842: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: END IF;
845:
846: okl_quick_quotes_pvt.update_qql(
847: p_api_version => p_api_version
848: ,p_init_msg_list => okl_api.g_false
849: ,x_return_status => l_return_status
850: ,x_msg_count => x_msg_count

Line 859: ,'okl_quick_quotes_pvt.update_qql returned with status ' ||

855:
856: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
857: okl_debug_pub.log_debug(fnd_log.level_statement
858: ,l_module
859: ,'okl_quick_quotes_pvt.update_qql returned with status ' ||
860: l_return_status ||
861: ' x_msg_data ' ||
862: x_msg_data);
863: END IF; -- end of l_debug_enabled ='Y'

Line 918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';

914: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
915: l_api_version CONSTANT NUMBER := 1.0;
916: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
917: l_qqlv_rec qqlv_rec_type := p_qqlv_rec_type;
918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
919: l_debug_enabled VARCHAR2(10);
920: is_debug_procedure_on BOOLEAN;
921: is_debug_statement_on BOOLEAN;
922:

Line 1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';

1011: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
1012: l_api_version CONSTANT NUMBER := 1.0;
1013: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1014: l_qqlv_tbl qqlv_tbl_type := p_qqlv_tbl_type;
1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
1016: l_debug_enabled VARCHAR2(10);
1017: is_debug_procedure_on BOOLEAN;
1018: is_debug_statement_on BOOLEAN;
1019:

Line 1138: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.handle_quick_quote';

1134: lxx_qqlv_tbl_type qqlv_tbl_type;
1135: lp_qqlv_rec qqlv_rec_type;
1136: lx_qqlv_rec qqlv_rec_type;
1137:
1138: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.handle_quick_quote';
1139: l_debug_enabled VARCHAR2(10);
1140: is_debug_procedure_on BOOLEAN;
1141: is_debug_statement_on BOOLEAN;
1142: l_item_name VARCHAR2(240);

Line 1242: Modified the cursor query get_line_dtls in OKL_QUICK_QUOTES_PVT.handle_quick_quote, so

1238: SELECT id FROM okl_quick_quote_lines_b where quick_quote_id=qqh_id;
1239:
1240: -- cursor to fetch the fees and services
1241: /* sosharma 08-Feb-2008 bug 6692055
1242: Modified the cursor query get_line_dtls in OKL_QUICK_QUOTES_PVT.handle_quick_quote, so
1243: that the composite index would be used.
1244: Start Changes
1245: */
1246: /*

Line 2392: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DUPLICATE_QUICK_QTE';

2388: l_quote_lines_tbl qqlv_tbl_type;
2389: x_quick_qte_rec qqhv_rec_type;
2390: x_quick_qte_lines_tbl qqlv_tbl_type;
2391:
2392: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DUPLICATE_QUICK_QTE';
2393: l_debug_enabled VARCHAR2(10);
2394: is_debug_procedure_on BOOLEAN;
2395: is_debug_statement_on BOOLEAN;
2396: l_api_name CONSTANT VARCHAR2(30) := 'duplicate_quick_qte';

Line 2495: END okl_quick_quotes_pvt;

2491: END duplicate_estimate;
2492:
2493:
2494:
2495: END okl_quick_quotes_pvt;