DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT dependencies on STANDARD

Line 337: nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,

333: lrs.description,
334: lrv.effective_from_date effective_from,
335: lrv.effective_to_date effective_to,
336: --Bug # 5050143 start
337: nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,
338: --Bug # 5050143 End
339: lrv.sts_code,
340: lrs.frq_code
341: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv

Line 493: --Populate Standard Rate Template For Quick Quote

489: END populate_lease_rate_set;
490:
491:
492: -------------------------------------------------------------------------------
493: --Populate Standard Rate Template For Quick Quote
494: --------------------------------------------------------------------------------
495: PROCEDURE populate_std_rate_tmpl(p_api_version IN NUMBER,
496: p_init_msg_list IN VARCHAR2,
497: p_target_id IN NUMBER,

Line 693: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote

689: l_ac_rec_type.src_id := l_okl_srt_rec.adj_mat_version_id; -- Pricing adjustment matrix ID
690: l_ac_rec_type.source_name := NULL; -- NOT Mandatory Pricing Adjustment Matrix Name !
691: l_ac_rec_type.target_id := p_target_id ; -- Quote ID
692: l_ac_rec_type.src_type := 'PAM'; -- Lookup Code
693: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote
694: l_ac_rec_type.target_eff_from := P_target_eff_from; -- Quote effective From
695: l_ac_rec_type.term := p_term; -- Remaining four will be from teh business object like QQ / LQ
696: l_ac_rec_type.territory := p_territory;
697: l_ac_rec_type.deal_size := p_deal_size;

Line 747: ,'okl_ec_uptake_pvt.populate_standard_rate_template returned with status ' ||

743: x_okl_srt_table:=l_okl_srt_table;
744: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
745: okl_debug_pub.log_debug(fnd_log.level_statement
746: ,l_module
747: ,'okl_ec_uptake_pvt.populate_standard_rate_template returned with status ' ||
748: l_return_status ||
749: ' x_msg_data ' ||
750: x_msg_data);
751: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 764: ,'end debug OKL_EC_UPTAKE_PVT.pls call populate_standard_rate_template');

760:
761: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
762: okl_debug_pub.log_debug(fnd_log.level_procedure
763: ,l_module
764: ,'end debug OKL_EC_UPTAKE_PVT.pls call populate_standard_rate_template');
765: END IF;
766: EXCEPTION
767: WHEN okl_api.g_exception_error THEN
768:

Line 833: nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,

829: lrs.description,
830: lrv.effective_from_date effective_from,
831: lrv.effective_to_date effective_to,
832: --Bug # 5050143 start
833: nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,
834: --Bug # 5050143 start
835: lrv.sts_code,
836: lrs.frq_code
837: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv

Line 1094: ,'begin debug OKLRECXB.pls call populate_standard_rate_template2');

1090:
1091: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1092: okl_debug_pub.log_debug(fnd_log.level_procedure
1093: ,l_module
1094: ,'begin debug OKLRECXB.pls call populate_standard_rate_template2');
1095: END IF; -- check for logging on STATEMENT level
1096: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1097: ,fnd_log.level_statement);
1098:

Line 1159: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote

1155: l_ac_rec_type.src_id := l_okl_srt_rec.adj_mat_version_id; -- Pricing adjustment matrix ID
1156: l_ac_rec_type.source_name := NULL; -- NOT Mandatory Pricing Adjustment Matrix Name !
1157: l_ac_rec_type.target_id := p_target_id ; -- Quote ID
1158: l_ac_rec_type.src_type := 'PAM'; -- Lookup Code
1159: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote
1160: l_ac_rec_type.target_eff_from := l_okl_ec_rec_type.target_eff_from; -- Quote effective From
1161: l_ac_rec_type.term := l_okl_ec_rec_type.term; -- Remaining four will be from teh business object like QQ / LQ
1162: l_ac_rec_type.territory := l_okl_ec_rec_type.territory;
1163: l_ac_rec_type.deal_size := l_okl_ec_rec_type.deal_size;

Line 1215: ,'OKL_EC_UPTAKE_PVT.populate_standard_rate_template2 returned with status ' ||

1211: x_okl_srt_table:=l_okl_srt_table;
1212: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1213: okl_debug_pub.log_debug(fnd_log.level_statement
1214: ,l_module
1215: ,'OKL_EC_UPTAKE_PVT.populate_standard_rate_template2 returned with status ' ||
1216: l_return_status ||
1217: ' x_msg_data ' ||
1218: x_msg_data);
1219: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1232: ,'end debug OKL_EC_UPTAKE_PVT.populate_standard_rate_template2 call create_vls');

1228:
1229: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1230: okl_debug_pub.log_debug(fnd_log.level_procedure
1231: ,l_module
1232: ,'end debug OKL_EC_UPTAKE_PVT.populate_standard_rate_template2 call create_vls');
1233: END IF;
1234: EXCEPTION
1235:
1236: WHEN okl_api.g_exception_error THEN