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 266: 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)

262: QP_PREQ_LINES_TMP lines
263: WHERE ldets.list_line_Type_code /*created_from_list_line_type list_line_Type_code*/= 'IUE'
264: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,
265: QP_PREQ_PUB.G_STATUS_UPDATED)
266: 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)
267: AND lines.process_status <> 'NOT_VALID'
268: AND ldets.line_index=lines.line_index;
269:
270:

Line 554: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

550: , QP_LIST_HEADERS_B QH
551: WHERE
552: ldets.line_detail_index = i.line_detail_index
553: and ldets.list_header_id=qh.list_header_id
554: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
555: );
556:
557: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
558: IF l_debug_level > 0 THEN

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

553: and ldets.list_header_id=qh.list_header_id
554: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
555: );
556:
557: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'in upgraded items cursor');
560: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
561: END IF;

Line 972: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

968: , QP_LIST_HEADERS_B QH
969: WHERE
970: ldets.line_detail_index = i.line_detail_index
971: and ldets.list_header_id=qh.list_header_id
972: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
973: );
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add( 'in new_terms cursor');
976: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;

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

1624:
1625: Cursor Hold_Lines IS
1626: SELECT line_index, line_id, line_Type_code, hold_code
1627: FROM QP_PREQ_LINES_TMP
1628: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
1629:
1630: Cursor limit_violated_details IS
1631: SELECT ldets.line_index, ldets.limit_text, lines.line_id
1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

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

1629:
1630: Cursor limit_violated_details IS
1631: SELECT ldets.line_index, ldets.limit_text, lines.line_id
1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
1633: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
1634: AND ldets.line_index = lines.line_index;
1635: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
1637:

Line 1668: i.hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED or

1664:
1665: END IF;
1666:
1667: IF (l_limit_hold_action = 'NO_HOLD' or
1668: i.hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED or
1669: nvl(l_TRANSACTION_PHASE_CODE, 'F') <> 'F'
1670: ) THEN
1671: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
1672: OE_MSG_PUB.ADD;

Line 1855: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED)

1851: , QP_PREQ_LINES_TMP lines
1852: , QP_LIST_HEADERS_B QH
1853: where
1854: ldets.LIST_HEADER_ID = qh.list_header_id
1855: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED)
1856: 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)
1857: AND lines.process_status <> 'NOT_VALID'
1858: AND ldets.line_index=lines.line_index
1859: AND (nvl(ldets.automatic_flag,'N') = 'Y')

Line 1856: 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)

1852: , QP_LIST_HEADERS_B QH
1853: where
1854: ldets.LIST_HEADER_ID = qh.list_header_id
1855: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED)
1856: 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)
1857: AND lines.process_status <> 'NOT_VALID'
1858: AND ldets.line_index=lines.line_index
1859: AND (nvl(ldets.automatic_flag,'N') = 'Y')
1860: -- or

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

1894: Elsif l_insert.LIST_LINE_TYPE_CODE = 'IUE' Then
1895: l_Line_Adj_rec.modified_from := to_char(l_insert.inventory_item_id);
1896: l_Line_Adj_rec.modified_to := to_char(l_insert.related_item_id);
1897: End If;
1898: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1899: l_Line_Adj_rec.UPDATED_FLAG := 'N';
1900: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1901: l_Line_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
1902: l_Line_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;

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

1896: l_Line_Adj_rec.modified_to := to_char(l_insert.related_item_id);
1897: End If;
1898: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1899: l_Line_Adj_rec.UPDATED_FLAG := 'N';
1900: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1901: l_Line_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
1902: l_Line_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;
1903: End If;
1904: l_Line_Adj_rec.UPDATE_ALLOWED := l_insert.override_flag;

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

1906: IF l_insert.operand_calculation_code = '%' or
1907: l_insert.operand_calculation_code = 'LUMPSUM' then
1908: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
1909: ELSE
1910: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1911: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
1912: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1913: 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);
1914: END IF;

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

1908: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
1909: ELSE
1910: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1911: l_Line_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
1912: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1913: 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);
1914: END IF;
1915: END IF;
1916: l_Line_Adj_rec.arithmetic_operator := l_insert.operand_calculation_code;

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

1938: l_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := l_insert.adjustment_amount;
1939:
1940: l_Line_Adj_rec.line_index := l_insert.line_index;
1941: l_Line_Adj_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1942: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1943: l_Line_Adj_rec.db_flag := FND_API.G_FALSE;
1944: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1945: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
1946: p_old_line_adj_rec => NULL,

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

1947: p_line_adj_rec =>l_line_adj_rec,
1948: p_line_adj_id => l_line_adj_rec.price_adjustment_id,
1949: x_index => l_index,
1950: x_return_status => l_return_status);
1951: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1952: l_Line_Adj_rec.db_flag := FND_API.G_TRUE;
1953: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1954:
1955: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

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

1977: Elsif l_insert.LIST_LINE_TYPE_CODE = 'IUE' Then
1978: l_Header_Adj_rec.modified_from := to_char(l_insert.inventory_item_id);
1979: l_Header_Adj_rec.modified_to := to_char(l_insert.related_item_id);
1980: End If;
1981: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1982: l_Header_Adj_rec.UPDATED_FLAG := 'N';
1983: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1984: l_Header_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
1985: l_Header_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;

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

1979: l_Header_Adj_rec.modified_to := to_char(l_insert.related_item_id);
1980: End If;
1981: If l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1982: l_Header_Adj_rec.UPDATED_FLAG := 'N';
1983: Elsif l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1984: l_Header_Adj_rec.UPDATED_FLAG := l_insert.updated_flag;
1985: l_Header_Adj_rec.print_on_invoice_flag := l_insert.print_on_invoice_flag;
1986: End If;
1987: l_Header_Adj_rec.UPDATE_ALLOWED := l_insert.override_flag;

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

1989: IF l_insert.operand_calculation_code = '%' or
1990: l_insert.operand_calculation_code = 'LUMPSUM' then
1991: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
1992: ELSE
1993: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1994: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
1995: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1996: 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);
1997: END IF;

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

1991: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value);
1992: ELSE
1993: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
1994: l_Header_Adj_rec.operand := nvl(l_insert.order_qty_operand, l_insert.operand_value*l_insert.priced_quantity/nvl(l_insert.lquantity,1));
1995: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
1996: 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);
1997: END IF;
1998: END IF;
1999: l_Header_Adj_rec.arithmetic_operator := l_insert.operand_calculation_code;

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

2021: l_Header_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := l_insert.adjustment_amount;
2022:
2023: --l_Header_Adj_rec.line_index := l_insert.line_index;
2024: l_Header_Adj_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2025: IF l_insert.process_code = QP_PREQ_GRP.G_STATUS_NEW Then
2026: l_Header_Adj_rec.db_flag := FND_API.G_FALSE;
2027: l_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2028: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2029: p_old_hdr_adj_rec => NULL,

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

2030: p_hdr_adj_rec =>l_header_adj_rec,
2031: p_hdr_adj_id => l_header_adj_rec.price_adjustment_id,
2032: x_index => l_index,
2033: x_return_status => l_return_status);
2034: ELSIF l_insert.process_code = QP_PREQ_GRP.G_STATUS_UPDATED Then
2035: l_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2036: l_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2037:
2038: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

Line 2090: ( QP_PREQ_GRP.G_STATUS_UPDATED

2086: FROM
2087: QP_PREQ_LINES_TMP lines
2088: ,OE_ORDER_LINES l
2089: WHERE lines.pricing_status_code IN
2090: ( QP_PREQ_GRP.G_STATUS_UPDATED
2091: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2092: AND lines.process_status <> 'NOT_VALID'
2093: AND lines.line_type_code='LINE'
2094: AND nvl(decode(lines.price_list_header_id,-9999,NULL,lines.price_list_header_id),0) <> nvl(l.price_list_id,0)

Line 2091: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

2087: QP_PREQ_LINES_TMP lines
2088: ,OE_ORDER_LINES l
2089: WHERE lines.pricing_status_code IN
2090: ( QP_PREQ_GRP.G_STATUS_UPDATED
2091: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2092: AND lines.process_status <> 'NOT_VALID'
2093: AND lines.line_type_code='LINE'
2094: AND nvl(decode(lines.price_list_header_id,-9999,NULL,lines.price_list_header_id),0) <> nvl(l.price_list_id,0)
2095: AND l.line_id = lines.line_id

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

2146: G_DEBUG := FALSE;
2147: End If;
2148:
2149: -- not need to process prg, iue, tsn, limits for calculate only call
2150: IF p_control_rec.p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY
2151: THEN
2152:
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'INSIDE OE_ORDER_ADV_PVT.PROCESS_ADV_MODIFIERS' , 1 ) ;

Line 2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

2420: , QP_PREQ_LINES_TMP lines
2421: , QP_LIST_HEADERS_B QH
2422: WHERE
2423: ldets.list_header_id=qh.list_header_id
2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2425: 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)
2426: AND lines.process_status <> 'NOT_VALID'
2427: AND ldets.line_index=lines.line_index
2428: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2425: 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)

2421: , QP_LIST_HEADERS_B QH
2422: WHERE
2423: ldets.list_header_id=qh.list_header_id
2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2425: 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)
2426: AND lines.process_status <> 'NOT_VALID'
2427: AND ldets.line_index=lines.line_index
2428: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2429: AND (nvl(ldets.automatic_flag,'N') = 'Y')

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

2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2425: 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)
2426: AND lines.process_status <> 'NOT_VALID'
2427: AND ldets.line_index=lines.line_index
2428: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2429: AND (nvl(ldets.automatic_flag,'N') = 'Y')
2430: -- or
2431: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
2432: AND ldets.created_from_list_type_code not in ('PRL','AGR')