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_ORDER_PRICE_PVT dependencies on QP_PREQ_PUB

Line 1952: QP_PREQ_PUB.G_STATUS_UNCHANGED

1948: p_line_tbl_index /*px_line_tbl(p_line_tbl_index).header_id
1949: + px_line_tbl(p_line_tbl_index).line_id*/,
1950: NULL,
1951: 'NULL',
1952: QP_PREQ_PUB.G_STATUS_UNCHANGED
1953: );
1954: END IF;
1955: End If;
1956: EXCEPTION

Line 3684: (QP_PREQ_PUB.G_STATUS_UPDATED,

3680:
3681: BEGIN
3682:
3683: IF p_hdr_price_flag in ('Y', 'P') AND p_hdr_pricing_status_code IN
3684: (QP_PREQ_PUB.G_STATUS_UPDATED,
3685: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3686: )
3687: THEN
3688: DELETE FROM OE_PRICE_ADJUSTMENTS

Line 3685: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION

3681: BEGIN
3682:
3683: IF p_hdr_price_flag in ('Y', 'P') AND p_hdr_pricing_status_code IN
3684: (QP_PREQ_PUB.G_STATUS_UPDATED,
3685: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3686: )
3687: THEN
3688: DELETE FROM OE_PRICE_ADJUSTMENTS
3689: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

Line 3743: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED

3739: select line_id, price_flag, line_index from qp_preq_lines_tmp
3740: where price_flag IN ('Y','P')
3741: and line_type_code = l_line_type_code
3742: and process_status <> 'NOT_VALID'
3743: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED
3744: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3745:
3746: l_adj_id_tbl Number_Type;
3747: --bug 3882620

Line 3744: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);

3740: where price_flag IN ('Y','P')
3741: and line_type_code = l_line_type_code
3742: and process_status <> 'NOT_VALID'
3743: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED
3744: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3745:
3746: l_adj_id_tbl Number_Type;
3747: --bug 3882620
3748: l_line_id_tbl Number_Type;

Line 3777: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,

3773: and b.pricing_phase_id = a.pricing_phase_id
3774: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3775: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3776: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3777: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3778: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3779: QP_PREQ_PUB.G_STATUS_NEW)
3780: and ld.line_index = one_line.line_index
3781: and (ld.applied_flag = decode(one_line.price_flag, 'Y', 'Y', 'P', ld.applied_flag)

Line 3778: QP_PREQ_PUB.G_STATUS_UNCHANGED,

3774: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3775: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3776: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3777: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3778: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3779: QP_PREQ_PUB.G_STATUS_NEW)
3780: and ld.line_index = one_line.line_index
3781: and (ld.applied_flag = decode(one_line.price_flag, 'Y', 'Y', 'P', ld.applied_flag)
3782: OR

Line 3779: QP_PREQ_PUB.G_STATUS_NEW)

3775: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3776: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3777: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3778: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3779: QP_PREQ_PUB.G_STATUS_NEW)
3780: and ld.line_index = one_line.line_index
3781: and (ld.applied_flag = decode(one_line.price_flag, 'Y', 'Y', 'P', ld.applied_flag)
3782: OR
3783: ((nvl(ld.applied_flag,'N') = decode(one_line.price_flag, 'Y', 'N', 'P', nvl(ld.applied_flag,'N'))

Line 3843: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,

3839: where line_id = p_line_id
3840: and line_type_code = 'LINE'
3841: and price_flag in ('Y', 'P')
3842: and process_status <> 'NOT_VALID'
3843: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3844: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3845:
3846: DELETE FROM OE_PRICE_ADJUSTMENTS
3847: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

Line 3844: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);

3840: and line_type_code = 'LINE'
3841: and price_flag in ('Y', 'P')
3842: and process_status <> 'NOT_VALID'
3843: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3844: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3845:
3846: DELETE FROM OE_PRICE_ADJUSTMENTS
3847: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3848: AND LINE_ID=p_line_id

Line 3865: QP_PREQ_PUB.G_STATUS_NEW)

3861: from qp_ldets_v ld
3862: where ld.process_code in
3863: (QP_PREQ_GRP.G_STATUS_UPDATED,
3864: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3865: QP_PREQ_PUB.G_STATUS_NEW)
3866: and (ld.applied_flag = 'Y'
3867: OR
3868: (nvl(ld.applied_flag,'N') = 'N'
3869: AND

Line 4728: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4724: , qplat.setup_value_to
4725: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4726: -- , QP_PREQ_LDETS_TMP LDETS
4727: -- , OE_PRICE_ADJUSTMENTS ADJ
4728: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4729: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4730: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4731: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4732: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 4735: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,

4731: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4732: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4733: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4734: --AND LDETS.LIST_LINE_ID = l_list_line_id_tbl(i)
4735: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4736: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4737: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4738: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)
4739: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)

Line 4736: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4732: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4733: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4734: --AND LDETS.LIST_LINE_ID = l_list_line_id_tbl(i)
4735: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4736: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4737: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4738: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)
4739: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4740: ) ;

Line 4790: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4786: ,1
4787: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4788: -- , QP_LDETS_v LDETS
4789: -- , OE_PRICE_ADJUSTMENTS ADJ
4790: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4791: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4792: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4793: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4794: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 4796: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,

4792: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4793: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4794: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4795: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4796: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4797: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4798: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4799: AND ( qplat.context
4800: , qplat.attribute

Line 4797: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4793: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4794: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4795: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4796: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4797: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4798: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4799: AND ( qplat.context
4800: , qplat.attribute
4801: , qplat.setup_value_from

Line 4836: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4832: , qplat.setup_value_to
4833: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4834: -- , QP_LDETS_v LDETS
4835: -- , OE_PRICE_ADJUSTMENTS ADJ
4836: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4837: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4838: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4839: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4840: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 4842: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,

4838: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4839: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4840: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4841: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4842: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4843: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4844: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4845: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4846: ) ;

Line 4843: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4839: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4840: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4841: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4842: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4843: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4844: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4845: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4846: ) ;
4847: IF l_debug_level > 0 THEN

Line 4897: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4893: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4894: --, QP_LDETS_v LDETS
4895: --, OE_PRICE_ADJUSTMENTS ADJ
4896: --, QP_PREQ_LINES_TMP QPL
4897: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4898: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4899: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4900: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4901: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID

Line 4902: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,

4898: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4899: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4900: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4901: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4902: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4903: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4904: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4905: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4906: AND ( qplat.context

Line 4903: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4899: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4900: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4901: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4902: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4903: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4904: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4905: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4906: AND ( qplat.context
4907: , qplat.attribute

Line 4990: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4986: ,1
4987: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4988: , QP_LDETS_v LDETS
4989: , OE_PRICE_ADJUSTMENTS ADJ
4990: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4991: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4992: AND ADJ.LINE_ID IS NULL
4993: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4994: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4997: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

4993: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4994: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4995: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4996: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4997: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4998: AND LDETS.LINE_INDEX = l_hdr_line_index
4999: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
5000: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5001: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

Line 5000: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,

4996: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4997: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4998: AND LDETS.LINE_INDEX = l_hdr_line_index
4999: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
5000: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5001: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5002: );
5003: l_stmt:=14;
5004: --13582129 Start

Line 5001: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

4997: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4998: AND LDETS.LINE_INDEX = l_hdr_line_index
4999: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
5000: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5001: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5002: );
5003: l_stmt:=14;
5004: --13582129 Start
5005: /*

Line 5050: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

5046: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5047: , QP_LDETS_v LDETS
5048: , OE_PRICE_ADJUSTMENTS ADJ
5049: , QP_PREQ_LINES_TMP QPLINE
5050: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5051: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)
5052: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5053: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
5054: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID

Line 5055: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

5051: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)
5052: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5053: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
5054: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
5055: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
5056: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
5057: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
5058: AND QPLINE.LINE_ID = ADJ.LINE_ID
5059: AND QPLINE.LINE_TYPE_CODE = 'LINE'

Line 5060: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,

5056: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
5057: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
5058: AND QPLINE.LINE_ID = ADJ.LINE_ID
5059: AND QPLINE.LINE_TYPE_CODE = 'LINE'
5060: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5061: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5062: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
5063: );
5064: */

Line 5061: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

5057: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
5058: AND QPLINE.LINE_ID = ADJ.LINE_ID
5059: AND QPLINE.LINE_TYPE_CODE = 'LINE'
5060: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5061: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5062: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
5063: );
5064: */
5065: INSERT INTO OE_PRICE_ADJ_ATTRIBS

Line 5110: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5107: , QP_PREQ_LDETS_TMP LDETS
5108: , OE_PRICE_ADJUSTMENTS ADJ
5109: , QP_PREQ_LINES_TMP QPLINE
5110: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5111: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5112: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
5113: AND LDETS.CREATED_FROM_LIST_LINE_ID=ADJ.LIST_LINE_ID
5114: AND LDETS.PRICING_STATUS_CODE = 'N'

Line 5115: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

5111: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5112: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
5113: AND LDETS.CREATED_FROM_LIST_LINE_ID=ADJ.LIST_LINE_ID
5114: AND LDETS.PRICING_STATUS_CODE = 'N'
5115: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
5116: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
5117: AND QPLINE.LINE_ID = ADJ.LINE_ID
5118: AND QPLINE.LINE_ID = Nvl(p_line_id,QPLINE.LINE_ID) --15845679
5119: AND QPLINE.LINE_TYPE_CODE = 'LINE'

Line 5120: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,

5116: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
5117: AND QPLINE.LINE_ID = ADJ.LINE_ID
5118: AND QPLINE.LINE_ID = Nvl(p_line_id,QPLINE.LINE_ID) --15845679
5119: AND QPLINE.LINE_TYPE_CODE = 'LINE'
5120: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5121: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5122: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
5123: );
5124: --13582129 End

Line 5121: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

5117: AND QPLINE.LINE_ID = ADJ.LINE_ID
5118: AND QPLINE.LINE_ID = Nvl(p_line_id,QPLINE.LINE_ID) --15845679
5119: AND QPLINE.LINE_TYPE_CODE = 'LINE'
5120: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5121: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5122: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
5123: );
5124: --13582129 End
5125: IF l_debug_level > 0 THEN

Line 6968: oe_debug_pub.add( 'BEFORE QP_PREQ_PUB.PRICE_REQUEST' , 1 ) ;

6964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6965: --
6966: BEGIN
6967: IF l_debug_level > 0 THEN
6968: oe_debug_pub.add( 'BEFORE QP_PREQ_PUB.PRICE_REQUEST' , 1 ) ;
6969: END IF;
6970:
6971: l_control_rec.calculate_flag := p_control_rec.p_calculate_flag;
6972: l_control_rec.simulation_flag := p_control_rec.p_simulation_flag;

Line 7008: QP_PREQ_PUB.PRICE_REQUEST

7004: l_control_rec.manual_adjustments_call_flag := 'N';
7005: END IF;
7006:
7007: G_STMT_NO := 'QP_PRICE_REQUEST_GRP';
7008: QP_PREQ_PUB.PRICE_REQUEST
7009: (p_control_rec => l_control_rec
7010: --,p_line_tbl => l_Req_line_tbl
7011: --,p_qual_tbl => l_Req_qual_tbl
7012: --,p_line_attr_tbl => l_Req_line_attr_tbl

Line 7204: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED

7200: or lines.adjusted_unit_price is NULL
7201: or lines.price_list_header_id is NULL)
7202: and lines.process_status <> 'NOT_VALID'
7203: --bug 3968023
7204: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED
7205: ;
7206: -- Bug 2079138: booked lines should always have price
7207: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
7208: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION