eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QP_PREQ_GRP dependencies on QP_INT_LINE_ATTRS

Line 3520: INSERT INTO QP_INT_LINE_ATTRS_T

3516: x_status_code := FND_API.G_RET_STS_SUCCESS;
3517: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
3518:
3519: FORALL i in p_line_index_tbl.FIRST..p_line_index_tbl.LAST
3520: INSERT INTO QP_INT_LINE_ATTRS_T
3521: (LINE_INDEX,
3522: LINE_DETAIL_INDEX,
3523: ATTRIBUTE_TYPE,
3524: CONTEXT,

Line 3539: /*INSERT INTO QP_INT_LINE_ATTRS

3535: p_VALUE_FROM_tbl(i),
3536: p_VALUE_TO_tbl(i),
3537: p_VALIDATED_FLAG_tbl(i),
3538: l_request_id);
3539: /*INSERT INTO QP_INT_LINE_ATTRS
3540: (LINE_INDEX,
3541: LINE_DETAIL_INDEX,
3542: ATTRIBUTE_TYPE,
3543: CONTEXT,

Line 3910: /*INSERT INTO QP_INT_LINE_ATTRS

3906: x_status_code := FND_API.G_RET_STS_SUCCESS;
3907: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
3908:
3909: FORALL i in p_line_index_tbl.FIRST..p_line_index_tbl.LAST
3910: /*INSERT INTO QP_INT_LINE_ATTRS
3911: ( LINE_INDEX,
3912: LINE_DETAIL_INDEX,
3913: ATTRIBUTE_LEVEL,
3914: ATTRIBUTE_TYPE,

Line 3973: INSERT INTO QP_INT_LINE_ATTRS_T

3969: p_LINE_DETAIL_TYPE_CODE_TBL(i),
3970: p_MODIFIER_LEVEL_CODE_TBL(i),
3971: p_PRIMARY_UOM_FLAG_TBL(i)
3972: );*/
3973: INSERT INTO QP_INT_LINE_ATTRS_T
3974: ( LINE_INDEX,
3975: LINE_DETAIL_INDEX,
3976: ATTRIBUTE_LEVEL,
3977: ATTRIBUTE_TYPE,

Line 8051: INDX,QP_PREQ_GRP.populate_temp_tables.l_int_count_cur,qp_int_line_attrs_N2,PRICING_STATUS_CODE,1

8047: WHERE PRICING_STATUS_CODE = 'X';
8048:
8049: --added by yangli for Java Engine project
8050: /*
8051: INDX,QP_PREQ_GRP.populate_temp_tables.l_int_count_cur,qp_int_line_attrs_N2,PRICING_STATUS_CODE,1
8052: */
8053: CURSOR l_int_count_cur IS
8054: SELECT COUNT(*)
8055: FROM qp_int_line_attrs

Line 8055: FROM qp_int_line_attrs

8051: INDX,QP_PREQ_GRP.populate_temp_tables.l_int_count_cur,qp_int_line_attrs_N2,PRICING_STATUS_CODE,1
8052: */
8053: CURSOR l_int_count_cur IS
8054: SELECT COUNT(*)
8055: FROM qp_int_line_attrs
8056: WHERE PRICING_STATUS_CODE = 'X';
8057: --added by yangli for Java Engine project
8058:
8059: -- begin declare shu fix bug 1728757

Line 9372: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1

9368:
9369: /*
9370: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9371:
9372: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9373: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9374: */
9375: CURSOR l_int_qual_cur (L_ATTRIBUTE_LEVEL VARCHAR2)IS
9376: SELECT /*+ dynamic_sampling(1) */ QPLAT.LINE_INDEX,

Line 9373: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2

9369: /*
9370: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9371:
9372: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9373: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9374: */
9375: CURSOR l_int_qual_cur (L_ATTRIBUTE_LEVEL VARCHAR2)IS
9376: SELECT /*+ dynamic_sampling(1) */ QPLAT.LINE_INDEX,
9377: QPLAT.LINE_DETAIL_INDEX,

Line 9387: qp_int_line_attrs QPLAT

9383: QPLAT.VALIDATED_FLAG,
9384: QPLAT.PRICING_STATUS_CODE,
9385: QPLAT.PRICING_STATUS_TEXT
9386: FROM qp_int_ldets QPLD ,
9387: qp_int_line_attrs QPLAT
9388: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
9389: AND QPLD.PRICING_STATUS_CODE = G_STATUS_NEW
9390: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
9391: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 9396: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1

9392:
9393: /*
9394: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9395:
9396: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9397: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9398: */
9399: CURSOR l_int_pricing_attr_cur IS
9400: SELECT QPLAT_PRICING.CONTEXT PRICING_CONTEXT,

Line 9397: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2

9393: /*
9394: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9395:
9396: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9397: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9398: */
9399: CURSOR l_int_pricing_attr_cur IS
9400: SELECT QPLAT_PRICING.CONTEXT PRICING_CONTEXT,
9401: QPLAT_PRICING.ATTRIBUTE PRICING_ATTRIBUTE,

Line 9409: qp_int_line_attrs QPLAT_PRICING

9405: QPLAT_PRICING.LINE_DETAIL_INDEX,
9406: QPLAT_PRICING.LINE_INDEX,
9407: QPLAT_PRICING.VALIDATED_FLAG
9408: FROM qp_int_ldets QPLD ,
9409: qp_int_line_attrs QPLAT_PRICING
9410: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
9411: AND QPLD.PRICING_STATUS_CODE = G_STATUS_NEW
9412: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
9413: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 31644: --Delete from qp_int_line_attrs;

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;
31648:

Line 31654: select count(*) into l_count from qp_int_line_attrs;

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);
31657: END IF;
31658: select count(*) into l_count from qp_int_ldets;

Line 31656: engine_debug('qp_int_line_attrs '||l_count);

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);
31657: END IF;
31658: select count(*) into l_count from qp_int_ldets;
31659: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31660: engine_debug('qp_int_ldets '||l_count);