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 9289: QP_PREQ_PUB.g_back_calculation_sts);

9285: QP_PREQ_GRP.g_status_dup_price_list,
9286: QP_PREQ_GRP.g_status_invalid_uom_conv,
9287: QP_PREQ_GRP.g_status_invalid_incomp,
9288: QP_PREQ_GRP.g_status_best_price_eval_error,
9289: QP_PREQ_PUB.g_back_calculation_sts);
9290:
9291: CURSOR C_status_code_GSA IS
9292: SELECT pricing_status_code,
9293: pricing_status_text

Line 9326: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9322: lines.line_id,
9323: lines.process_status
9324: FROM QP_PREQ_RLTD_LINES_TMP rltd,
9325: QP_PREQ_LINES_TMP lines
9326: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9327: AND RLTD.Relationship_Type_Code in (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
9328: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9329: AND lines.line_type_code = 'LINE'
9330: AND lines.line_index = rltd.line_index;

Line 9711: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9707: QP_PREQ_LINES_TMP LINE,
9708: QP_PREQ_LINES_TMP RLTD_LINE,
9709: ASO_PRICE_ADJUSTMENTS ADJ,
9710: ASO_PRICE_ADJUSTMENTS RADJ
9711: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9712: AND RLTD_LINE.line_index = RLTD.related_line_index
9713: AND RLTD.Relationship_Type_Code in
9714: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
9715: AND line.line_index = rltd.line_index

Line 9778: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9774: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
9775: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9776: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9777: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
9778: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9779: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9780: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9781: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9782: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

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

9778: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9779: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9780: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9781: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9782: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
9783:
9784: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9785: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert into Adjustment Attributes - Line Level Attributes'||sql%ROWCOUNT,1,'Y');
9786: END IF;

Line 9829: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

9825: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
9826: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
9827: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9828: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
9829: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9830: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9831: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9832: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9833: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

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

9829: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9830: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
9831: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
9832: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
9833: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
9834:
9835: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9836: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert into Adjustment Attributes - Header Level Attributes'||sql%ROWCOUNT,1,'Y');
9837: END IF;

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

9953: QP_LDETS_V ldets_v
9954: WHERE lines.line_index = ldets_v.line_index
9955: AND ldets_v.modifier_level_code = 'LINE'
9956: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9957: AND nvl(ldets_v.Calculation_code,'X') <> QP_PREQ_PUB.G_FREEGOOD
9958: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
9959: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
9960: AND nvl(ldets_v.created_from_list_type_code,'X') not in ('PRL','AGR'));
9961:

Line 10031: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

10027: QP_PREQ_LINES_TMP LINE,
10028: QP_PREQ_LINES_TMP RLTD_LINE,
10029: ASO_PRICE_ADJUSTMENTS ADJ,
10030: ASO_PRICE_ADJUSTMENTS RADJ
10031: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10032: AND RLTD_LINE.line_index = RLTD.related_line_index
10033: AND RLTD.Relationship_Type_Code in
10034: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
10035: AND line.line_index = rltd.line_index

Line 10096: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

10092: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
10093: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10094: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10095: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
10096: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10097: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10098: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10099: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10100: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

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

10096: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10097: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10098: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10099: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10100: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
10101:
10102: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10103: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert into Adjustment Attributes - Line Level Attributes'||sql%ROWCOUNT,1,'Y');
10104: END IF;

Line 10262: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW

10258: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
10259: AND LDETS.LINE_INDEX = LINES.LINE_INDEX
10260: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10261: AND LDETS.PRICING_PHASE_ID = ADJ.PRICING_PHASE_ID
10262: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10263: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10264: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10265: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10266: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);

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

10262: AND LDETS.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10263: AND LDETS.CREATED_FROM_LIST_LINE_ID = ADJ.MODIFIER_LINE_ID
10264: AND LDETS.CREATED_FROM_LIST_HEADER_ID = ADJ.MODIFIER_HEADER_ID
10265: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
10266: AND QPLAT.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW);
10267:
10268: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10269: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Insert Adjustment Attributes - Header Level Attributes'||sql%ROWCOUNT,1,'Y');
10270: END IF;

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

10786: attrs.CONTEXT CONTEXT,
10787: attrs.VALUE_FROM VALUE_FROM
10788: FROM QP_PREQ_LINES_TMP lines,
10789: QP_PREQ_LINE_ATTRS_TMP attrs
10790: --WHERE lines.PROCESSED_CODE = QP_PREQ_PUB.G_BY_ENGINE
10791: WHERE lines.process_status in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_DELETED)
10792: AND lines.line_index = attrs.line_index
10793: AND attrs.CONTEXT = 'ITEM'
10794: AND attrs.ATTRIBUTE = 'PRICING_ATTRIBUTE1';

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

11500: l_req_control_rec.REQUEST_TYPE_CODE := p_control_rec.request_type;
11501: l_req_control_rec.rounding_flag := 'Q';
11502:
11503: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11504: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST second implicit call', 1, 'Y');
11505: END IF;
11506:
11507: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
11508:

Line 11514: QP_PREQ_PUB.PRICE_REQUEST

11510:
11511: /* End of Change (MOAC) */
11512:
11513:
11514: QP_PREQ_PUB.PRICE_REQUEST
11515: (p_control_rec =>l_req_control_rec
11516: ,x_return_status =>l_return_status
11517: ,x_return_status_Text =>l_return_status_Text
11518: );

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

11526: RAISE FND_API.G_EXC_ERROR;
11527: END IF;
11528:
11529: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11530: aso_debug_pub.add('ASO_PRICING_CORE_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
11531: aso_debug_pub.add('ASO_PRICING_CORE_PVT: After PRICE_REQUEST l_return_status:'
11532: ||l_return_status, 1, 'Y');
11533: aso_debug_pub.add('ASO_PRICING_CORE_PVT: After PRICE_REQUEST l_return_status_text '
11534: ||l_return_status_text,1,'Y');