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.OE_ADV_PRICE_PVT dependencies on QP_PREQ_GRP

Line 311: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

307: QP_PREQ_LINES_TMP lines
308: WHERE ldets.list_line_Type_code /*created_from_list_line_type list_line_Type_code*/= 'IUE'
309: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,
310: QP_PREQ_PUB.G_STATUS_UPDATED)
311: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
312: AND lines.process_status <> 'NOT_VALID'
313: AND ldets.line_index=lines.line_index;
314:
315:

Line 622: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

618: , QP_LIST_HEADERS_B QH
619: WHERE
620: ldets.line_detail_index = i.line_detail_index
621: and ldets.list_header_id=qh.list_header_id
622: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
623: );
624:
625: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
626: IF l_debug_level > 0 THEN

Line 625: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

621: and ldets.list_header_id=qh.list_header_id
622: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
623: );
624:
625: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'in upgraded items cursor');
628: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
629: END IF;

Line 1257: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

1253: , QP_LIST_HEADERS_B QH
1254: WHERE
1255: ldets.line_detail_index = i.line_detail_index
1256: and ldets.list_header_id=qh.list_header_id
1257: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
1258: );
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add( 'in new_terms cursor');
1261: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;

Line 2055: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);

2051:
2052: Cursor Hold_Lines IS
2053: SELECT line_index, line_id, line_Type_code, hold_code
2054: FROM QP_PREQ_LINES_TMP
2055: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
2056:
2057: Cursor limit_violated_details IS
2058: SELECT ldets.line_index, ldets.limit_text, lines.line_id
2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

Line 2060: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )

2056:
2057: Cursor limit_violated_details IS
2058: SELECT ldets.line_index, ldets.limit_text, lines.line_id
2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
2060: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
2061: AND ldets.line_index = lines.line_index;
2062: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
2063: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
2064:

Line 2095: i.hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED or

2091:
2092: END IF;
2093:
2094: IF (l_limit_hold_action = 'NO_HOLD' or
2095: i.hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED or
2096: nvl(l_TRANSACTION_PHASE_CODE, 'F') <> 'F'
2097: ) THEN
2098: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
2099: OE_MSG_PUB.ADD;

Line 2282: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED) --Bug8467307

2278: , QP_PREQ_LINES_TMP lines
2279: , QP_LIST_HEADERS_B QH
2280: where
2281: ldets.LIST_HEADER_ID = qh.list_header_id
2282: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED) --Bug8467307
2283: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2284: AND lines.process_status <> 'NOT_VALID'
2285: AND ldets.line_index=lines.line_index
2286: AND (nvl(ldets.automatic_flag,'N') = 'Y')

Line 2283: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

2279: , QP_LIST_HEADERS_B QH
2280: where
2281: ldets.LIST_HEADER_ID = qh.list_header_id
2282: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED) --Bug8467307
2283: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2284: AND lines.process_status <> 'NOT_VALID'
2285: AND ldets.line_index=lines.line_index
2286: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2287: -- or

Line 2328: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then

2324: Elsif l_insert.LIST_LINE_TYPE_CODE = 'IUE' Then
2325: l_Line_Adj_rec.modified_from := to_char(l_insert.inventory_item_id);
2326: l_Line_Adj_rec.modified_to := to_char(l_insert.related_item_id);
2327: End If;
2328: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2329: l_Line_Adj_rec.UPDATED_FLAG := 'N';
2330: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2331: l_Line_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
2332: l_Line_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;

Line 2330: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then

2326: l_Line_Adj_rec.modified_to := to_char(l_insert.related_item_id);
2327: End If;
2328: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2329: l_Line_Adj_rec.UPDATED_FLAG := 'N';
2330: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2331: l_Line_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
2332: l_Line_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;
2333: End If;
2334: l_Line_Adj_rec.UPDATE_ALLOWED := l_insert.override_flag;

Line 2340: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then

2336: IF l_insert.operand_calculation_code = '%' or
2337: l_insert.operand_calculation_code = 'LUMPSUM' then
2338: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
2339: ELSE
2340: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2341: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
2342: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2343: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*nvl(l_insert.priced_quantity,l_insert.lquantity)/l_insert.lquantity);
2344: END IF;

Line 2342: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then

2338: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
2339: ELSE
2340: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2341: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
2342: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2343: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*nvl(l_insert.priced_quantity,l_insert.lquantity)/l_insert.lquantity);
2344: END IF;
2345: END IF;
2346: l_Line_Adj_rec.arithmetic_operator := l_insert.operand_calculation_code;

Line 2372: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then

2368: l_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := l_insert.adjustment_amount;
2369:
2370: l_Line_Adj_rec.line_index := l_insert.line_index;
2371: l_Line_Adj_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2372: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2373: l_Line_Adj_rec.db_flag := FND_API.G_FALSE;
2374: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2375: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2376: p_old_line_adj_rec => NULL,

Line 2381: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then

2377: p_line_adj_rec =>l_line_adj_rec,
2378: p_line_adj_id => l_line_adj_rec.price_adjustment_id,
2379: x_index => l_index,
2380: x_return_status => l_return_status);
2381: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2382: l_Line_Adj_rec.db_flag := FND_API.G_TRUE;
2383: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2384:
2385: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

Line 2391: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UNCHANGED Then

2387: p_line_adj_id => l_line_adj_rec.price_adjustment_id,
2388: x_index => l_index,
2389: x_return_status => l_return_status);
2390: --Start of bug#8467307
2391: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UNCHANGED Then
2392: IF l_debug_level > 0 THEN
2393: oe_debug_pub.add ('Adj ID=' ||l_insert.price_adjustment_id);
2394: END IF;
2395: -- To find the old line quantity

Line 2446: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then

2442: Elsif l_insert.LIST_LINE_TYPE_CODE = 'IUE' Then
2443: l_Header_Adj_rec.modified_from := to_char(l_insert.inventory_item_id);
2444: l_Header_Adj_rec.modified_to := to_char(l_insert.related_item_id);
2445: End If;
2446: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2447: l_Header_Adj_rec.UPDATED_FLAG := 'N';
2448: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2449: l_Header_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
2450: l_Header_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;

Line 2448: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then

2444: l_Header_Adj_rec.modified_to := to_char(l_insert.related_item_id);
2445: End If;
2446: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2447: l_Header_Adj_rec.UPDATED_FLAG := 'N';
2448: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2449: l_Header_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
2450: l_Header_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;
2451: End If;
2452: l_Header_Adj_rec.UPDATE_ALLOWED := l_insert.override_flag;

Line 2458: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then

2454: IF l_insert.operand_calculation_code = '%' or
2455: l_insert.operand_calculation_code = 'LUMPSUM' then
2456: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
2457: ELSE
2458: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2459: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
2460: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2461: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*nvl(l_insert.priced_quantity,l_insert.lquantity)/l_insert.lquantity);
2462: END IF;

Line 2460: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then

2456: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
2457: ELSE
2458: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2459: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
2460: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2461: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*nvl(l_insert.priced_quantity,l_insert.lquantity)/l_insert.lquantity);
2462: END IF;
2463: END IF;
2464: l_Header_Adj_rec.arithmetic_operator := l_insert.operand_calculation_code;

Line 2490: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then

2486: l_Header_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := l_insert.adjustment_amount;
2487:
2488: --l_Header_Adj_rec.line_index := l_insert.line_index;
2489: l_Header_Adj_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2490: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2491: l_Header_Adj_rec.db_flag := FND_API.G_FALSE;
2492: l_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2493: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2494: p_old_hdr_adj_rec => NULL,

Line 2499: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then

2495: p_hdr_adj_rec =>l_header_adj_rec,
2496: p_hdr_adj_id => l_header_adj_rec.price_adjustment_id,
2497: x_index => l_index,
2498: x_return_status => l_return_status);
2499: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2500: l_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2501: l_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2502:
2503: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

Line 2556: ( QP_PREQ_GRP.G_STATUS_UPDATED

2552: FROM
2553: QP_PREQ_LINES_TMP lines
2554: ,OE_ORDER_LINES l
2555: WHERE lines.pricing_status_code IN
2556: ( QP_PREQ_GRP.G_STATUS_UPDATED
2557: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2558: AND lines.process_status <> 'NOT_VALID'
2559: AND lines.line_type_code='LINE'
2560: AND nvl(decode(lines.price_list_header_id,-9999,NULL,lines.price_list_header_id),0) <> nvl(l.price_list_id,0)

Line 2557: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

2553: QP_PREQ_LINES_TMP lines
2554: ,OE_ORDER_LINES l
2555: WHERE lines.pricing_status_code IN
2556: ( QP_PREQ_GRP.G_STATUS_UPDATED
2557: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2558: AND lines.process_status <> 'NOT_VALID'
2559: AND lines.line_type_code='LINE'
2560: AND nvl(decode(lines.price_list_header_id,-9999,NULL,lines.price_list_header_id),0) <> nvl(l.price_list_id,0)
2561: AND l.line_id = lines.line_id

Line 2617: IF p_control_rec.p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY

2613: G_DEBUG := FALSE;
2614: End If;
2615:
2616: -- not need to process prg, iue, tsn, limits for calculate only call
2617: IF p_control_rec.p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY
2618: THEN
2619:
2620: IF l_debug_level > 0 THEN
2621: oe_debug_pub.add( 'INSIDE OE_ORDER_ADV_PVT.PROCESS_ADV_MODIFIERS' , 1 ) ;

Line 2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

2888: , QP_PREQ_LINES_TMP lines
2889: , QP_LIST_HEADERS_B QH
2890: WHERE
2891: ldets.list_header_id=qh.list_header_id
2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2893: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2894: AND lines.process_status <> 'NOT_VALID'
2895: AND ldets.line_index=lines.line_index
2896: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2893: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

2889: , QP_LIST_HEADERS_B QH
2890: WHERE
2891: ldets.list_header_id=qh.list_header_id
2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2893: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2894: AND lines.process_status <> 'NOT_VALID'
2895: AND ldets.line_index=lines.line_index
2896: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2897: AND (nvl(ldets.automatic_flag,'N') = 'Y')

Line 2896: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2893: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2894: AND lines.process_status <> 'NOT_VALID'
2895: AND ldets.line_index=lines.line_index
2896: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2897: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2898: -- or
2899: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
2900: AND ldets.created_from_list_type_code not in ('PRL','AGR')