APPS.QP_PREQ_GRP dependencies on QP_INT_LINES

Line 4374: /*INSERT INTO QP_INT_LINES

4370: x_status_code := FND_API.G_RET_STS_SUCCESS;
4371: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
4372:
4373: FORALL i in p_line_index.FIRST..p_line_index.LAST
4374: /*INSERT INTO QP_INT_LINES
4375: (LINE_INDEX,
4376: LINE_TYPE_CODE,
4377: PRICING_EFFECTIVE_DATE,
4378: START_DATE_ACTIVE_FIRST,

Line 4439: INSERT INTO QP_INT_LINES_t

4435: nvl (p_LIST_PRICE_OVERRIDE_FLAG(i), 'N'),
4436: p_CHARGE_PERIODICITY_CODE,
4437: p_UNIT_PRICE(i)-- po integration
4438: );*/
4439: INSERT INTO QP_INT_LINES_t
4440: (LINE_INDEX,
4441: LINE_TYPE_CODE,
4442: PRICING_EFFECTIVE_DATE,
4443: START_DATE_ACTIVE_FIRST,

Line 4754: /*INSERT INTO QP_INT_LINES

4750: QP_PREQ_GRP.engine_debug('line index size:'||p_line_index.count());
4751: END IF;
4752:
4753: FORALL i in p_line_index.FIRST..p_line_index.LAST
4754: /*INSERT INTO QP_INT_LINES
4755: ( LINE_INDEX,
4756: LINE_TYPE_CODE,
4757: PRICING_EFFECTIVE_DATE,
4758: START_DATE_ACTIVE_FIRST,

Line 4838: INSERT INTO QP_INT_LINES_T

4834: NVL(p_LIST_PRICE_OVERRIDE_FLAG(i), 'N'), --po integration
4835: p_CHARGE_PERIODICITY_CODE(i),
4836: p_UNIT_PRICE(i)
4837: );*/
4838: INSERT INTO QP_INT_LINES_T
4839: ( LINE_INDEX,
4840: LINE_TYPE_CODE,
4841: PRICING_EFFECTIVE_DATE,
4842: START_DATE_ACTIVE_FIRST,

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

9080: WHERE line_index = p_line_index;
9081:
9082: --added by yangli for Java Engine interface tables
9083: /*
9084: INDX,QP_PREQ_GRP.set_expiration_dates.l_int_pricing_effective_date,qp_int_lines_N1,LINE_INDEX,1
9085: */
9086: CURSOR l_int_pricing_effective_date (p_line_index IN PLS_INTEGER) IS
9087: SELECT pricing_effective_date
9088: FROM qp_int_lines

Line 9088: FROM qp_int_lines

9084: INDX,QP_PREQ_GRP.set_expiration_dates.l_int_pricing_effective_date,qp_int_lines_N1,LINE_INDEX,1
9085: */
9086: CURSOR l_int_pricing_effective_date (p_line_index IN PLS_INTEGER) IS
9087: SELECT pricing_effective_date
9088: FROM qp_int_lines
9089: WHERE line_index = p_line_index;
9090:
9091: BEGIN
9092: x_status_code := FND_API.G_RET_STS_SUCCESS;

Line 9367: FROM qp_int_lines;

9363: HOLD_TEXT,
9364: PRICE_REQUEST_CODE,
9365: PRICING_EFFECTIVE_DATE,
9366: EXTENDED_PRICE /* block pricing */
9367: FROM qp_int_lines;
9368:
9369: /*
9370: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9371:

Line 31643: --Delete from qp_int_lines;

31639: ELSE
31640: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31641: ENGINE_DEBUG('Truncate_Temp_tables: Java Engine is Installed ----------');
31642: END IF;
31643: --Delete from qp_int_lines;
31644: --Delete from qp_int_line_attrs;
31645: --Delete From qp_int_ldets;
31646: --Delete From qp_int_rltd_lines;
31647: --Delete From qp_int_formula_step_values;

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

31646: --Delete From qp_int_rltd_lines;
31647: --Delete From qp_int_formula_step_values;
31648:
31649: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31650: select count(*) into l_count from qp_int_lines;
31651: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31652: engine_debug('qp_int_lines '||l_count);
31653: END IF;
31654: select count(*) into l_count from qp_int_line_attrs;

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

31648:
31649: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31650: select count(*) into l_count from qp_int_lines;
31651: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31652: engine_debug('qp_int_lines '||l_count);
31653: END IF;
31654: select count(*) into l_count from qp_int_line_attrs;
31655: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31656: engine_debug('qp_int_line_attrs '||l_count);

Line 32414: from qp_int_lines

32410: from qp_npreq_lines_tmp
32411: where QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
32412: UNION ALL
32413: select line_index, unit_price, price_flag
32414: from qp_int_lines
32415: where QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y';
32416:
32417:
32418: --added by yangli for Java Engine changes

Line 32837: FROM qp_int_lines

32833: --added by yangli for Java Engine
32834: ELSE
32835: SELECT 1
32836: INTO l_price_flag_indx
32837: FROM qp_int_lines
32838: WHERE PRICE_FLAG IN (G_YES, G_PHASE)
32839: AND ROWNUM=1;
32840: END IF;
32841: --added by yangli for Java Engine