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.

APPS.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_PUB

Line 9305: QP_PREQ_PUB.g_back_calculation_sts);

9301: QP_PREQ_GRP.g_status_dup_price_list,
9302: QP_PREQ_GRP.g_status_invalid_uom_conv,
9303: QP_PREQ_GRP.g_status_invalid_incomp,
9304: QP_PREQ_GRP.g_status_best_price_eval_error,
9305: QP_PREQ_PUB.g_back_calculation_sts);
9306:
9307: CURSOR C_status_code_GSA IS
9308: SELECT pricing_status_code,
9309: pricing_status_text

Line 9342: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9338: lines.line_id,
9339: lines.process_status
9340: FROM QP_PREQ_RLTD_LINES_TMP rltd,
9341: QP_PREQ_LINES_TMP lines
9342: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9343: AND RLTD.Relationship_Type_Code in (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
9344: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9345: AND lines.line_type_code = 'LINE'
9346: AND lines.line_index = rltd.line_index;

Line 9728: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9724: QP_PREQ_LINES_TMP LINE,
9725: QP_PREQ_LINES_TMP RLTD_LINE,
9726: ASO_PRICE_ADJUSTMENTS ADJ,
9727: ASO_PRICE_ADJUSTMENTS RADJ
9728: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9729: AND RLTD_LINE.line_index = RLTD.related_line_index
9730: AND RLTD.Relationship_Type_Code in
9731: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
9732: AND line.line_index = rltd.line_index

Line 9795: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9791: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
9792: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9793: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9794: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
9795: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9796: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9797: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9798: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9799: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

Line 9799: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

9795: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9796: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9797: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9798: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9799: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
9800:
9801: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9802: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert into Adjustment Attributes - Line Level Attributes'||sql%ROWCOUNT,1,'Y');
9803: END IF;

Line 9846: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9842: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
9843: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9844: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9845: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
9846: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9847: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9848: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9849: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9850: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

Line 9850: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

9846: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9847: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9848: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9849: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9850: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
9851:
9852: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9853: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert into Adjustment Attributes - Header Level Attributes'||sql%ROWCOUNT,1,'Y');
9854: END IF;

Line 9974: AND nvl(ldets_v.Calculation_code,'X') <> QP_PREQ_PUB.G_FREEGOOD

9970: QP_LDETS_V ldets_v
9971: WHERE lines.line_index = ldets_v.line_index
9972: AND ldets_v.modifier_level_code = 'LINE'
9973: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9974: AND nvl(ldets_v.Calculation_code,'X') <> QP_PREQ_PUB.G_FREEGOOD
9975: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
9976: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
9977: AND nvl(ldets_v.created_from_list_type_code,'X') not in ('PRL','AGR'));
9978:

Line 10048: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

10044: QP_PREQ_LINES_TMP LINE,
10045: QP_PREQ_LINES_TMP RLTD_LINE,
10046: ASO_PRICE_ADJUSTMENTS ADJ,
10047: ASO_PRICE_ADJUSTMENTS RADJ
10048: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10049: AND RLTD_LINE.line_index = RLTD.related_line_index
10050: AND RLTD.Relationship_Type_Code in
10051: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
10052: AND line.line_index = rltd.line_index

Line 10113: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

10109: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
10110: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10111: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10112: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
10113: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10114: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10115: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10116: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10117: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

Line 10117: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

10113: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10114: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10115: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10116: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10117: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
10118:
10119: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10120: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert into Adjustment Attributes - Line Level Attributes'||sql%ROWCOUNT,1,'Y');
10121: END IF;

Line 10279: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

10275: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
10276: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10277: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10278: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
10279: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10280: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10281: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10282: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10283: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

Line 10283: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

10279: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10280: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10281: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10282: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10283: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
10284:
10285: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10286: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert Adjustment Attributes - Header Level Attributes'||sql%ROWCOUNT,1,'Y');
10287: END IF;

Line 10807: --WHERE lines.PROCESSED_CODE = QP_PREQ_PUB.G_BY_ENGINE

10803: attrs.CONTEXT CONTEXT,
10804: attrs.VALUE_FROM VALUE_FROM
10805: FROM QP_PREQ_LINES_TMP lines,
10806: QP_PREQ_LINE_ATTRS_TMP attrs
10807: --WHERE lines.PROCESSED_CODE = QP_PREQ_PUB.G_BY_ENGINE
10808: WHERE lines.process_status in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_DELETED)
10809: AND lines.line_index = attrs.line_index
10810: AND attrs.CONTEXT = 'ITEM'
10811: AND attrs.ATTRIBUTE = 'PRICING_ATTRIBUTE1';

Line 11521: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST second implicit call', 1, 'Y');

11517: l_req_control_rec.REQUEST_TYPE_CODE := p_control_rec.request_type;
11518: l_req_control_rec.rounding_flag := 'Q';
11519:
11520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11521: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST second implicit call', 1, 'Y');
11522: END IF;
11523:
11524: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
11525:

Line 11531: QP_PREQ_PUB.PRICE_REQUEST

11527:
11528: /* End of Change (MOAC) */
11529:
11530:
11531: QP_PREQ_PUB.PRICE_REQUEST
11532: (p_control_rec =>l_req_control_rec
11533: ,x_return_status =>l_return_status
11534: ,x_return_status_Text =>l_return_status_Text
11535: );

Line 11547: aso_debug_pub.add('ASO_PRICING_CORE_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

11543: RAISE FND_API.G_EXC_ERROR;
11544: END IF;
11545:
11546: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11547: aso_debug_pub.add('ASO_PRICING_CORE_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
11548: aso_debug_pub.add('ASO_PRICING_CORE_PVT: After PRICE_REQUEST l_return_status:'
11549: ||l_return_status, 1, 'Y');
11550: aso_debug_pub.add('ASO_PRICING_CORE_PVT: After PRICE_REQUEST l_return_status_text '
11551: ||l_return_status_text,1,'Y');