APPS.QP_PREQ_GRP dependencies on QP_INT_LINES

Line 4522: /*INSERT INTO QP_INT_LINES

4518: x_status_code := FND_API.G_RET_STS_SUCCESS;
4519: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
4520:
4521: FORALL i in p_line_index.FIRST..p_line_index.LAST
4522: /*INSERT INTO QP_INT_LINES
4523: (LINE_INDEX,
4524: LINE_TYPE_CODE,
4525: PRICING_EFFECTIVE_DATE,
4526: START_DATE_ACTIVE_FIRST,

Line 4587: INSERT INTO QP_INT_LINES_t

4583: nvl (p_LIST_PRICE_OVERRIDE_FLAG(i), 'N'),
4584: p_CHARGE_PERIODICITY_CODE,
4585: p_UNIT_PRICE(i)-- po integration
4586: );*/
4587: INSERT INTO QP_INT_LINES_t
4588: (LINE_INDEX,
4589: LINE_TYPE_CODE,
4590: PRICING_EFFECTIVE_DATE,
4591: START_DATE_ACTIVE_FIRST,

Line 4913: /*INSERT INTO QP_INT_LINES

4909: QP_PREQ_GRP.engine_debug('line index size:'||p_line_index.count());
4910: END IF;
4911:
4912: FORALL i in p_line_index.FIRST..p_line_index.LAST
4913: /*INSERT INTO QP_INT_LINES
4914: ( LINE_INDEX,
4915: LINE_TYPE_CODE,
4916: PRICING_EFFECTIVE_DATE,
4917: START_DATE_ACTIVE_FIRST,

Line 4997: INSERT INTO QP_INT_LINES_T

4993: NVL(p_LIST_PRICE_OVERRIDE_FLAG(i), 'N'), --po integration
4994: p_CHARGE_PERIODICITY_CODE(i),
4995: p_UNIT_PRICE(i)
4996: );*/
4997: INSERT INTO QP_INT_LINES_T
4998: ( LINE_INDEX,
4999: LINE_TYPE_CODE,
5000: PRICING_EFFECTIVE_DATE,
5001: START_DATE_ACTIVE_FIRST,

Line 9353: INDX,QP_PREQ_GRP.set_expiration_dates.l_int_pricing_effective_date,qp_int_lines_N1,LINE_INDEX,1

9349: WHERE line_index = p_line_index;
9350:
9351: --added by yangli for Java Engine interface tables
9352: /*
9353: INDX,QP_PREQ_GRP.set_expiration_dates.l_int_pricing_effective_date,qp_int_lines_N1,LINE_INDEX,1
9354: */
9355: CURSOR l_int_pricing_effective_date (p_line_index IN PLS_INTEGER) IS
9356: SELECT pricing_effective_date
9357: FROM qp_int_lines

Line 9357: FROM qp_int_lines

9353: INDX,QP_PREQ_GRP.set_expiration_dates.l_int_pricing_effective_date,qp_int_lines_N1,LINE_INDEX,1
9354: */
9355: CURSOR l_int_pricing_effective_date (p_line_index IN PLS_INTEGER) IS
9356: SELECT pricing_effective_date
9357: FROM qp_int_lines
9358: WHERE line_index = p_line_index;
9359:
9360: BEGIN
9361: x_status_code := FND_API.G_RET_STS_SUCCESS;

Line 9639: FROM qp_int_lines;

9635: HOLD_TEXT,
9636: PRICE_REQUEST_CODE,
9637: PRICING_EFFECTIVE_DATE,
9638: EXTENDED_PRICE /* block pricing */
9639: FROM qp_int_lines;
9640:
9641: /*
9642: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9643:

Line 37221: --Delete from qp_int_lines;

37217: ELSE
37218: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37219: ENGINE_DEBUG('Truncate_Temp_tables: Java Engine is Installed ----------');
37220: END IF;
37221: --Delete from qp_int_lines;
37222: --Delete from qp_int_line_attrs;
37223: --Delete From qp_int_ldets;
37224: --Delete From qp_int_rltd_lines;
37225: --Delete From qp_int_formula_step_values;

Line 37228: select count(*) into l_count from qp_int_lines;

37224: --Delete From qp_int_rltd_lines;
37225: --Delete From qp_int_formula_step_values;
37226:
37227: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37228: select count(*) into l_count from qp_int_lines;
37229: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37230: engine_debug('qp_int_lines '||l_count);
37231: END IF;
37232: select count(*) into l_count from qp_int_line_attrs;

Line 37230: engine_debug('qp_int_lines '||l_count);

37226:
37227: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37228: select count(*) into l_count from qp_int_lines;
37229: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37230: engine_debug('qp_int_lines '||l_count);
37231: END IF;
37232: select count(*) into l_count from qp_int_line_attrs;
37233: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37234: engine_debug('qp_int_line_attrs '||l_count);

Line 41155: from qp_int_lines

41151: from qp_npreq_lines_tmp
41152: where QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
41153: UNION ALL
41154: select line_index, unit_price, price_flag
41155: from qp_int_lines
41156: where QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y';
41157:
41158: --skattama
41159: /*

Line 41647: FROM qp_int_lines

41643: --added by yangli for Java Engine
41644: ELSE
41645: SELECT 1
41646: INTO l_price_flag_indx
41647: FROM qp_int_lines
41648: WHERE PRICE_FLAG IN (G_YES, G_PHASE)
41649: AND ROWNUM=1;
41650: END IF;
41651: --added by yangli for Java Engine