[Home] [Help]
138: --Cursor to retrieve name for defined price list id
139: CURSOR Get_price_list_name_cur (C_LIST_HEADER_ID IN NUMBER)
140: IS
141: SELECT name
142: FROM qp_list_headers
143: WHERE list_header_id = C_LIST_HEADER_ID;
144:
145: -- AnRaj: Query changed for fixing performance bug 4919475
146: -- Get Billing item id for the associated mr
332: );
333: END IF;
334:
335:
336: --Get Price list name from qp_list_headers table
337: IF l_task_cost_price_rec.price_list_id IS NOT NULL THEN
338: --
339: OPEN Get_price_list_name_cur(l_task_cost_price_rec.price_list_id);
340: FETCH Get_price_list_name_cur INTO l_cost_price_rec.price_list_name;
345: fnd_log.string
346: (
347: fnd_log.level_error,
348: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
349: 'Price List Name not found in qp_list_headers table'
350: );
351: END IF;
352: CLOSE Get_price_list_name_cur;
353: RAISE FND_API.G_EXC_ERROR;
361: fnd_log.string
362: (
363: fnd_log.level_statement,
364: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
365: 'Price List Name from QP_LIST_HEADERS: '||l_cost_price_rec.price_list_name
366: );
367: fnd_log.string
368: (
369: fnd_log.level_statement,
873:
874: CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)
875: IS
876: SELECT qlhv.list_header_id
877: FROM qp_list_headers_vl qlhv, qp_qualifiers qpq
878: WHERE qlhv.list_type_code = 'PRL'
879: AND upper(qlhv.name) like upper(p_price_list_name)
880: AND qpq.QUALIFIER_ATTR_VALUE = p_customer_id
881: AND qpq.list_header_id=qlhv.list_header_id
887: CURSOR Get_price_list_cur (c_price_list_id IN NUMBER)
888: IS
889: SELECT start_date_active,
890: end_date_active
891: FROM QP_LIST_HEADERS
892: WHERE list_header_id = c_price_list_id;
893: l_price_list_rec Get_price_list_cur%ROWTYPE;
894:
895: -- Local Variables
1087: fnd_log.string
1088: (
1089: fnd_log.level_error,
1090: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1091: 'Price List Name not found in qp_list_headers table'
1092: );
1093: END IF;
1094: END IF;
1095: CLOSE Get_price_list_cur;