[Home] [Help]
3378: */
3379: CURSOR l_Service_Cur IS
3380: SELECT LINE_INDEX,
3381: RELATED_LINE_INDEX
3382: FROM qp_npreq_rltd_lines_tmp
3383: WHERE LINE_INDEX IS NOT NULL
3384: AND RELATED_LINE_INDEX IS NOT NULL
3385: AND RELATIONSHIP_TYPE_CODE = G_SERVICE_LINE;
3386:
7437: END IF;
7438: --added by yangli for Java Engine project
7439:
7440: FORALL i in p_line_index.FIRST..p_line_index.LAST
7441: INSERT INTO qp_npreq_rltd_lines_tmp (
7442: LINE_INDEX,
7443: LINE_DETAIL_INDEX,
7444: RELATIONSHIP_TYPE_CODE,
7445: RELATED_LINE_INDEX,
9597: RELATED_LINE_INDEX,
9598: RELATED_LINE_DETAIL_INDEX,
9599: PRICING_STATUS_CODE,
9600: PRICING_STATUS_TEXT
9601: FROM qp_npreq_rltd_lines_tmp
9602: WHERE PRICING_STATUS_CODE = G_STATUS_NEW
9603: ORDER BY SETUP_VALUE_FROM;
9604:
9605: --for Java Engine interface tables
12830: END LOOP;
12831: END IF; -- l_h_list_line_id_tbl.COUNT > 0
12832:
12833: --after checking each break line, if any one of the break lines satified, insert all
12834: --the break lines to qp_npreq_ldets_tmp table and qp_npreq_rltd_lines_tmp table
12835: --and do not delete the parent line
12836: -- This flag tells that either it was a range break or atleast one of the break lines was satisfied in case of point break
12837: IF (l_VALID_PBH_FLAG = G_YES) THEN
12838: --FOR J IN 1..N-1 LOOP
12977: IF (G_DEBUG_ENGINE = FND_API.G_TRUE) THEN
12978: engine_debug('#L2');
12979: END IF;
12980:
12981: -- julin [3805113]: bulk insert into qp_npreq_rltd_lines_tmp
12982: IF (l_l_p_line_index_tbl.COUNT > 0) THEN
12983: FORALL J IN l_l_p_line_index_tbl.first..l_l_p_line_index_tbl.last
12984: INSERT INTO qp_npreq_rltd_lines_tmp
12985: (LINE_INDEX,
12980:
12981: -- julin [3805113]: bulk insert into qp_npreq_rltd_lines_tmp
12982: IF (l_l_p_line_index_tbl.COUNT > 0) THEN
12983: FORALL J IN l_l_p_line_index_tbl.first..l_l_p_line_index_tbl.last
12984: INSERT INTO qp_npreq_rltd_lines_tmp
12985: (LINE_INDEX,
12986: LINE_DETAIL_INDEX,
12987: RELATIONSHIP_TYPE_CODE,
12988: RELATED_LINE_INDEX,
13132: UPDATE qp_npreq_ldets_tmp a
13133: SET PRICING_STATUS_CODE = G_DELETED_PARENT_FAILS
13134: WHERE line_detail_index IN
13135: (SELECT related_line_detail_index
13136: FROM qp_npreq_rltd_lines_tmp
13137: WHERE line_detail_index = I.line_detail_index);
13138: /*
13139: INDX,QP_PREQ_GRP.delete_invalid_pbh_children.upd2,-No Index Used-,NA,NA
13140: */
13137: WHERE line_detail_index = I.line_detail_index);
13138: /*
13139: INDX,QP_PREQ_GRP.delete_invalid_pbh_children.upd2,-No Index Used-,NA,NA
13140: */
13141: UPDATE qp_npreq_rltd_lines_tmp --upd2
13142: SET PRICING_STATUS_CODE = G_DELETED_PARENT_FAILS
13143: WHERE line_detail_index = I.line_detail_index;
13144:
13145: END LOOP;
13188: AND pricing_phase_id = p_pricing_phase_id
13189: AND nvl(processed_flag,G_NOT_PROCESSED) = G_NOT_PROCESSED;
13190: --AND line_index > 0
13191: --AND not exists (select 'X'
13192: -- from qp_npreq_rltd_lines_tmp b
13193: -- where a.line_index = b.line_index
13194: -- and a.created_from_list_line_id = b.list_line_id
13195: -- and b.relationship_type_code = G_PBH_LINE
13196: -- and nvl(b.pricing_status_text,G_NOT_PROCESSED) <> G_PROCESSED);
35503: INDX,QP_PREQ_GRP.call_calculation_engine.l_service_item_cur,- No Index Used -,NA,NA
35504: */
35505: CURSOR l_service_item_cur(l_line_index PLS_INTEGER) IS
35506: SELECT LINE_INDEX
35507: FROM qp_npreq_rltd_lines_tmp
35508: WHERE RELATED_LINE_INDEX = l_line_index
35509: AND RELATIONSHIP_TYPE_CODE = G_SERVICE_LINE;
35510:
35511: -- Cursor for getting the unit price of the parent line ex: Oracle 8i line
35914: */
35915: /* julin [3805113]: using global table populated in handle_break
35916: SELECT LINE_DETAIL_INDEX
35917: INTO l_parent_line_detail_index
35918: FROM qp_npreq_rltd_lines_tmp
35919: WHERE RELATED_LINE_DETAIL_INDEX = K.line_detail_index;
35920: */
35921: --p_cal_req_rltd_tbl(N).line_detail_index is actually parent line detail index
35922: p_cal_req_rltd_tbl(N).line_detail_index := TO_NUMBER(G_PARENT_LINE_DETAIL_INDEX_TBL(k.line_detail_index));
37106:
37107: -- Update the operand on the related lines also
37108: IF (i.LINE_DETAIL_TYPE_CODE = G_CHILD_DETAIL_TYPE) THEN
37109:
37110: UPDATE qp_npreq_rltd_lines_tmp
37111: SET OPERAND = l_formula_based_price
37112: WHERE RELATED_LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID --bug#2875361
37113: AND LINE_INDEX = i.line_index
37114: AND PRICING_STATUS_CODE = G_STATUS_NEW
37192: --added by yangli for Java Engine project
37193: --Delete from qp_npreq_lines_tmp;
37194: --Delete from qp_npreq_line_attrs_tmp;
37195: --Delete From qp_npreq_ldets_tmp;
37196: --Delete From qp_npreq_rltd_lines_tmp;
37197: --Delete From QP_PREQ_QUAL_TMP;
37198: --Delete From qp_nformula_step_values_tmp;
37199: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;
37200:
37252: The relationship between order level adjustments and request lines
37253: need to be returned back to the caller.
37254: Example: list 'a' is a order level adjustment with line_detail_index
37255: of 3. There are 3 request lines with 4,5,6 line index then
37256: the data in qp_npreq_rltd_lines_tmp should be:
37257: +---------------------------------------------------------------+
37258: | related_line_detail_index| line_index| Relation_ship_type_code|
37259: +--------------------------+-----------+------------------------+
37260: | 3 | 4 | ORDER_TO_LINE |
37321: END IF;
37322:
37323: IF J > 0 THEN
37324: FORALL K IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
37325: INSERT INTO qp_npreq_rltd_lines_tmp
37326: (LINE_INDEX,RELATED_LINE_DETAIL_INDEX,RELATIONSHIP_TYPE_CODE,PRICING_STATUS_CODE)
37327: VALUES
37328: (l_line_index_tbl(K),l_line_detail_index_tbl1(K),G_ORDER_TO_LINE,G_STATUS_NEW);
37329: END IF;