[Home] [Help]
3232: */
3233: CURSOR l_Service_Cur IS
3234: SELECT LINE_INDEX,
3235: RELATED_LINE_INDEX
3236: FROM qp_npreq_rltd_lines_tmp
3237: WHERE LINE_INDEX IS NOT NULL
3238: AND RELATED_LINE_INDEX IS NOT NULL
3239: AND RELATIONSHIP_TYPE_CODE = G_SERVICE_LINE;
3240:
7226: END IF;
7227: --added by yangli for Java Engine project
7228:
7229: FORALL i in p_line_index.FIRST..p_line_index.LAST
7230: INSERT INTO qp_npreq_rltd_lines_tmp (
7231: LINE_INDEX,
7232: LINE_DETAIL_INDEX,
7233: RELATIONSHIP_TYPE_CODE,
7234: RELATED_LINE_INDEX,
9325: RELATED_LINE_INDEX,
9326: RELATED_LINE_DETAIL_INDEX,
9327: PRICING_STATUS_CODE,
9328: PRICING_STATUS_TEXT
9329: FROM qp_npreq_rltd_lines_tmp
9330: WHERE PRICING_STATUS_CODE = G_STATUS_NEW
9331: ORDER BY SETUP_VALUE_FROM;
9332:
9333: --for Java Engine interface tables
12540: END LOOP;
12541: END IF; -- l_h_list_line_id_tbl.COUNT > 0
12542:
12543: --after checking each break line, if any one of the break lines satified, insert all
12544: --the break lines to qp_npreq_ldets_tmp table and qp_npreq_rltd_lines_tmp table
12545: --and do not delete the parent line
12546: -- This flag tells that either it was a range break or atleast one of the break lines was satisfied in case of point break
12547: IF (l_VALID_PBH_FLAG = G_YES) THEN
12548: --FOR J IN 1..N-1 LOOP
12683: IF (G_DEBUG_ENGINE = FND_API.G_TRUE) THEN
12684: engine_debug('#L2');
12685: END IF;
12686:
12687: -- julin [3805113]: bulk insert into qp_npreq_rltd_lines_tmp
12688: IF (l_l_p_line_index_tbl.COUNT > 0) THEN
12689: FORALL J IN l_l_p_line_index_tbl.first..l_l_p_line_index_tbl.last
12690: INSERT INTO qp_npreq_rltd_lines_tmp
12691: (LINE_INDEX,
12686:
12687: -- julin [3805113]: bulk insert into qp_npreq_rltd_lines_tmp
12688: IF (l_l_p_line_index_tbl.COUNT > 0) THEN
12689: FORALL J IN l_l_p_line_index_tbl.first..l_l_p_line_index_tbl.last
12690: INSERT INTO qp_npreq_rltd_lines_tmp
12691: (LINE_INDEX,
12692: LINE_DETAIL_INDEX,
12693: RELATIONSHIP_TYPE_CODE,
12694: RELATED_LINE_INDEX,
12838: UPDATE qp_npreq_ldets_tmp a
12839: SET PRICING_STATUS_CODE = G_DELETED_PARENT_FAILS
12840: WHERE line_detail_index IN
12841: (SELECT related_line_detail_index
12842: FROM qp_npreq_rltd_lines_tmp
12843: WHERE line_detail_index = I.line_detail_index);
12844: /*
12845: INDX,QP_PREQ_GRP.delete_invalid_pbh_children.upd2,-No Index Used-,NA,NA
12846: */
12843: WHERE line_detail_index = I.line_detail_index);
12844: /*
12845: INDX,QP_PREQ_GRP.delete_invalid_pbh_children.upd2,-No Index Used-,NA,NA
12846: */
12847: UPDATE qp_npreq_rltd_lines_tmp --upd2
12848: SET PRICING_STATUS_CODE = G_DELETED_PARENT_FAILS
12849: WHERE line_detail_index = I.line_detail_index;
12850:
12851: END LOOP;
12893: AND pricing_phase_id = p_pricing_phase_id
12894: AND nvl(processed_flag,G_NOT_PROCESSED) = G_NOT_PROCESSED;
12895: --AND line_index > 0
12896: --AND not exists (select 'X'
12897: -- from qp_npreq_rltd_lines_tmp b
12898: -- where a.line_index = b.line_index
12899: -- and a.created_from_list_line_id = b.list_line_id
12900: -- and b.relationship_type_code = G_PBH_LINE
12901: -- and nvl(b.pricing_status_text,G_NOT_PROCESSED) <> G_PROCESSED);
29931: INDX,QP_PREQ_GRP.call_calculation_engine.l_service_item_cur,- No Index Used -,NA,NA
29932: */
29933: CURSOR l_service_item_cur(l_line_index PLS_INTEGER) IS
29934: SELECT LINE_INDEX
29935: FROM qp_npreq_rltd_lines_tmp
29936: WHERE RELATED_LINE_INDEX = l_line_index
29937: AND RELATIONSHIP_TYPE_CODE = G_SERVICE_LINE;
29938:
29939: -- Cursor for getting the unit price of the parent line ex: Oracle 8i line
30339: */
30340: /* julin [3805113]: using global table populated in handle_break
30341: SELECT LINE_DETAIL_INDEX
30342: INTO l_parent_line_detail_index
30343: FROM qp_npreq_rltd_lines_tmp
30344: WHERE RELATED_LINE_DETAIL_INDEX = K.line_detail_index;
30345: */
30346: --p_cal_req_rltd_tbl(N).line_detail_index is actually parent line detail index
30347: p_cal_req_rltd_tbl(N).line_detail_index := TO_NUMBER(G_PARENT_LINE_DETAIL_INDEX_TBL(k.line_detail_index));
31528:
31529: -- Update the operand on the related lines also
31530: IF (i.LINE_DETAIL_TYPE_CODE = G_CHILD_DETAIL_TYPE) THEN
31531:
31532: UPDATE qp_npreq_rltd_lines_tmp
31533: SET OPERAND = l_formula_based_price
31534: WHERE RELATED_LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID --bug#2875361
31535: AND LINE_INDEX = i.line_index
31536: AND PRICING_STATUS_CODE = G_STATUS_NEW
31614: --added by yangli for Java Engine project
31615: --Delete from qp_npreq_lines_tmp;
31616: --Delete from qp_npreq_line_attrs_tmp;
31617: --Delete From qp_npreq_ldets_tmp;
31618: --Delete From qp_npreq_rltd_lines_tmp;
31619: --Delete From QP_PREQ_QUAL_TMP;
31620: --Delete From qp_nformula_step_values_tmp;
31621: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;
31622:
31674: The relationship between order level adjustments and request lines
31675: need to be returned back to the caller.
31676: Example: list 'a' is a order level adjustment with line_detail_index
31677: of 3. There are 3 request lines with 4,5,6 line index then
31678: the data in qp_npreq_rltd_lines_tmp should be:
31679: +---------------------------------------------------------------+
31680: | related_line_detail_index| line_index| Relation_ship_type_code|
31681: +--------------------------+-----------+------------------------+
31682: | 3 | 4 | ORDER_TO_LINE |
31743: END IF;
31744:
31745: IF J > 0 THEN
31746: FORALL K IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31747: INSERT INTO qp_npreq_rltd_lines_tmp
31748: (LINE_INDEX,RELATED_LINE_DETAIL_INDEX,RELATIONSHIP_TYPE_CODE,PRICING_STATUS_CODE)
31749: VALUES
31750: (l_line_index_tbl(K),l_line_detail_index_tbl1(K),G_ORDER_TO_LINE,G_STATUS_NEW);
31751: END IF;