[Home] [Help]
12: FUNCTION validate_header(p_qqhv_rec_type IN qqhv_rec_type) RETURN VARCHAR2 IS
13:
14: CURSOR chk_uniquness IS
15: SELECT 'x'
16: FROM okl_quick_quotes_b
17: WHERE reference_number = p_qqhv_rec_type.reference_number
18: AND id <> NVL(p_qqhv_rec_type.id, -9999);
19:
20: l_dummy_var VARCHAR2(1);
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;
574: l_api_name CONSTANT VARCHAR2(30) := 'cancel_quick_quote';
1118: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type
1119: ) IS
1120:
1121: l_api_name CONSTANT VARCHAR2(30) := 'handle_quick_quote';
1122: QQ_ACTIVE CONSTANT okl_quick_quotes_b.sts_code%TYPE :='ACTIVE';
1123: l_api_version CONSTANT NUMBER := 1.0;
1124: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1125:
1126: l_qqhv_rec_type qqhv_rec_type := p_qqhv_rec_type;
1211: ql.id LINE_ID,
1212: levels.rate,
1213: ql.value VALUE
1214: FROM okl_cash_flow_objects obj, okl_cash_flows flow, okl_cash_flow_levels levels,
1215: okl_quick_quotes_b qh, okl_quick_quote_lines_b ql
1216: where obj.id= flow.cfo_id
1217: AND flow.id= levels.caf_id
1218: AND qh.id= ql.quick_quote_id
1219: AND obj.source_table='OKL_QUICK_QUOTE_LINES_B'
1249: levels.number_of_periods NUMBER_OF_PERIODS,
1250: levels.start_date START_DATE,
1251: ql.TYPE TYPE
1252: FROM okl_cash_flow_objects obj, okl_cash_flows flow, okl_cash_flow_levels levels,
1253: okl_quick_quotes_b qh, okl_quick_quote_lines_b ql
1254: where obj.id= flow.cfo_id
1255: AND flow.id= levels.caf_id
1256: AND qh.id= ql.quick_quote_id
1257: AND obj.source_table='OKL_QUICK_QUOTE_LINES_B'
1262: CURSOR get_line_dtls(p_qqh_id IN NUMBER) IS
1263: SELECT LEVELS.AMOUNT AMOUNT, LEVELS.NUMBER_OF_PERIODS NUMBER_OF_PERIODS,
1264: LEVELS.START_DATE START_DATE, QL.TYPE TYPE
1265: FROM
1266: OKL_QUICK_QUOTES_B QH,
1267: OKL_QUICK_QUOTE_LINES_B QL,
1268: OKL_CASH_FLOW_OBJECTS OBJ,
1269: OKL_CASH_FLOWS FLOW,
1270: OKL_CASH_FLOW_LEVELS LEVELS,
2152:
2153: --------------------------------
2154: -- PROCEDURE get_quick_quote
2155: --------------------------------
2156: PROCEDURE get_quick_quote(p_quote_id IN okl_quick_quotes_b.id%type,
2157: x_qqhv_rec OUT NOCOPY qqhv_rec_type,
2158: x_qqlv_tbl OUT NOCOPY qqlv_tbl_type,
2159: x_return_status OUT NOCOPY VARCHAR2)
2160: IS
2158: x_qqlv_tbl OUT NOCOPY qqlv_tbl_type,
2159: x_return_status OUT NOCOPY VARCHAR2)
2160: IS
2161:
2162: CURSOR c_qqh(p_id IN okl_quick_quotes_b.id%TYPE) IS
2163: SELECT id,
2164: object_version_number,
2165: attribute_category,
2166: attribute1,
2316: --viselvar modified code
2317:
2318: --Bug 7022258-Changed by kkorrapo
2319: --SELECT OKL_QQH_REF_SEQ.nextval INTO x_qqhv_rec.reference_number FROM DUAL;
2320: x_qqhv_rec.reference_number := okl_util.get_next_seq_num('OKL_QQH_REF_SEQ','OKL_QUICK_QUOTES_B','REFERENCE_NUMBER');
2321: --Bug 7022258--Change end
2322:
2323: IF c_qqh%NOTFOUND THEN
2324: x_return_status := okl_api.g_ret_sts_error;
2398: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2399:
2400: -- cursor to get the estimates of a particular lease opportunity
2401: CURSOR get_estimates(l_lopp_id IN NUMBER) IS
2402: SELECT ID FROM OKL_QUICK_QUOTES_B
2403: WHERE LEASE_OPPORTUNITY_ID = l_lopp_id;
2404:
2405: BEGIN
2406: