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 1951: QP_PREQ_PUB.G_STATUS_UNCHANGED

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

Line 3571: (QP_PREQ_PUB.G_STATUS_UPDATED,

3567:
3568: BEGIN
3569:
3570: IF p_hdr_price_flag in ('Y', 'P') AND p_hdr_pricing_status_code IN
3571: (QP_PREQ_PUB.G_STATUS_UPDATED,
3572: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3573: )
3574: THEN
3575: DELETE FROM OE_PRICE_ADJUSTMENTS

Line 3572: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION

3568: BEGIN
3569:
3570: IF p_hdr_price_flag in ('Y', 'P') AND p_hdr_pricing_status_code IN
3571: (QP_PREQ_PUB.G_STATUS_UPDATED,
3572: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3573: )
3574: THEN
3575: DELETE FROM OE_PRICE_ADJUSTMENTS
3576: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

Line 3629: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED

3625: select line_id, price_flag, line_index from qp_preq_lines_tmp
3626: where price_flag IN ('Y','P')
3627: and line_type_code = l_line_type_code
3628: and process_status <> 'NOT_VALID'
3629: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED
3630: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3631:
3632: l_adj_id_tbl Number_Type;
3633: --bug 3882620

Line 3630: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);

3626: where price_flag IN ('Y','P')
3627: and line_type_code = l_line_type_code
3628: and process_status <> 'NOT_VALID'
3629: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED
3630: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3631:
3632: l_adj_id_tbl Number_Type;
3633: --bug 3882620
3634: l_line_id_tbl Number_Type;

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

3658: and b.pricing_phase_id = a.pricing_phase_id
3659: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3660: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3661: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3662: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3663: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3664: QP_PREQ_PUB.G_STATUS_NEW)
3665: and ld.line_index = one_line.line_index
3666: and (ld.applied_flag = decode(one_line.price_flag, 'Y', 'Y', 'P', ld.applied_flag)

Line 3663: QP_PREQ_PUB.G_STATUS_UNCHANGED,

3659: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3660: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3661: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3662: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3663: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3664: QP_PREQ_PUB.G_STATUS_NEW)
3665: and ld.line_index = one_line.line_index
3666: and (ld.applied_flag = decode(one_line.price_flag, 'Y', 'Y', 'P', ld.applied_flag)
3667: OR

Line 3664: QP_PREQ_PUB.G_STATUS_NEW)

3660: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3661: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3662: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3663: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3664: QP_PREQ_PUB.G_STATUS_NEW)
3665: and ld.line_index = one_line.line_index
3666: and (ld.applied_flag = decode(one_line.price_flag, 'Y', 'Y', 'P', ld.applied_flag)
3667: OR
3668: ((nvl(ld.applied_flag,'N') = decode(one_line.price_flag, 'Y', 'N', 'P', nvl(ld.applied_flag,'N'))

Line 3728: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,

3724: where line_id = p_line_id
3725: and line_type_code = 'LINE'
3726: and price_flag in ('Y', 'P')
3727: and process_status <> 'NOT_VALID'
3728: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3729: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3730:
3731: DELETE FROM OE_PRICE_ADJUSTMENTS
3732: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

Line 3729: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);

3725: and line_type_code = 'LINE'
3726: and price_flag in ('Y', 'P')
3727: and process_status <> 'NOT_VALID'
3728: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3729: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3730:
3731: DELETE FROM OE_PRICE_ADJUSTMENTS
3732: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3733: AND LINE_ID=p_line_id

Line 3749: QP_PREQ_PUB.G_STATUS_NEW)

3745: from qp_ldets_v ld
3746: where ld.process_code in
3747: (QP_PREQ_GRP.G_STATUS_UPDATED,
3748: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3749: QP_PREQ_PUB.G_STATUS_NEW)
3750: and (ld.applied_flag = 'Y'
3751: OR
3752: (nvl(ld.applied_flag,'N') = 'N'
3753: AND

Line 4613: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4609: , qplat.setup_value_to
4610: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4611: -- , QP_PREQ_LDETS_TMP LDETS
4612: -- , OE_PRICE_ADJUSTMENTS ADJ
4613: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4614: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4615: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4616: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4617: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

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

4616: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4617: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4618: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4619: --AND LDETS.LIST_LINE_ID = l_list_line_id_tbl(i)
4620: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4621: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4622: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4623: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)
4624: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)

Line 4621: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4617: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4618: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4619: --AND LDETS.LIST_LINE_ID = l_list_line_id_tbl(i)
4620: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4621: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4622: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4623: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)
4624: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4625: ) ;

Line 4675: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4671: ,1
4672: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4673: -- , QP_LDETS_v LDETS
4674: -- , OE_PRICE_ADJUSTMENTS ADJ
4675: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4676: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4677: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4678: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4679: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

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

4677: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4678: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4679: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4680: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4681: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4682: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4683: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4684: AND ( qplat.context
4685: , qplat.attribute

Line 4682: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4678: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4679: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4680: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4681: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4682: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4683: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4684: AND ( qplat.context
4685: , qplat.attribute
4686: , qplat.setup_value_from

Line 4721: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4717: , qplat.setup_value_to
4718: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4719: -- , QP_LDETS_v LDETS
4720: -- , OE_PRICE_ADJUSTMENTS ADJ
4721: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4722: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4723: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4724: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4725: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

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

4723: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4724: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4725: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4726: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4727: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4728: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4729: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4730: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4731: ) ;

Line 4728: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4724: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4725: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4726: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4727: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4728: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4729: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4730: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4731: ) ;
4732: IF l_debug_level > 0 THEN

Line 4782: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4778: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4779: --, QP_LDETS_v LDETS
4780: --, OE_PRICE_ADJUSTMENTS ADJ
4781: --, QP_PREQ_LINES_TMP QPL
4782: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4783: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4784: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4785: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4786: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID

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

4783: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4784: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4785: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4786: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4787: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4788: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4789: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4790: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4791: AND ( qplat.context

Line 4788: -- QP_PREQ_PUB.G_STATUS_UPDATED)

4784: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4785: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4786: --AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4787: --AND LDETS.PROCESS_CODE in (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4788: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4789: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4790: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4791: AND ( qplat.context
4792: , qplat.attribute

Line 4875: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4871: ,1
4872: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4873: , QP_LDETS_v LDETS
4874: , OE_PRICE_ADJUSTMENTS ADJ
4875: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4876: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4877: AND ADJ.LINE_ID IS NULL
4878: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4879: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4882: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

4878: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4879: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4880: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4881: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4882: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4883: AND LDETS.LINE_INDEX = l_hdr_line_index
4884: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
4885: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4886: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

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

4881: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4882: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4883: AND LDETS.LINE_INDEX = l_hdr_line_index
4884: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
4885: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4886: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
4887: );
4888: l_stmt:=14;
4889: INSERT INTO OE_PRICE_ADJ_ATTRIBS

Line 4886: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

4882: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4883: AND LDETS.LINE_INDEX = l_hdr_line_index
4884: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
4885: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4886: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
4887: );
4888: l_stmt:=14;
4889: INSERT INTO OE_PRICE_ADJ_ATTRIBS
4890: ( PRICE_ADJUSTMENT_ID

Line 4933: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

4929: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4930: , QP_LDETS_v LDETS
4931: , OE_PRICE_ADJUSTMENTS ADJ
4932: , QP_PREQ_LINES_TMP QPLINE
4933: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4934: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)
4935: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4936: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4937: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID

Line 4938: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

4934: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)
4935: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4936: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4937: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4938: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4939: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
4940: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4941: AND QPLINE.LINE_ID = ADJ.LINE_ID
4942: AND QPLINE.LINE_TYPE_CODE = 'LINE'

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

4939: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
4940: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4941: AND QPLINE.LINE_ID = ADJ.LINE_ID
4942: AND QPLINE.LINE_TYPE_CODE = 'LINE'
4943: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4944: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
4945: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
4946: );
4947: IF l_debug_level > 0 THEN

Line 4944: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

4940: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4941: AND QPLINE.LINE_ID = ADJ.LINE_ID
4942: AND QPLINE.LINE_TYPE_CODE = 'LINE'
4943: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4944: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
4945: AND QPLINE.PROCESS_STATUS <> 'NOT_VALID'
4946: );
4947: IF l_debug_level > 0 THEN
4948: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ATTRIBS' , 3 ) ;

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

6685: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6686: --
6687: BEGIN
6688: IF l_debug_level > 0 THEN
6689: oe_debug_pub.add( 'BEFORE QP_PREQ_PUB.PRICE_REQUEST' , 1 ) ;
6690: END IF;
6691:
6692: l_control_rec.calculate_flag := p_control_rec.p_calculate_flag;
6693: l_control_rec.simulation_flag := p_control_rec.p_simulation_flag;

Line 6729: QP_PREQ_PUB.PRICE_REQUEST

6725: l_control_rec.manual_adjustments_call_flag := 'N';
6726: END IF;
6727:
6728: G_STMT_NO := 'QP_PRICE_REQUEST_GRP';
6729: QP_PREQ_PUB.PRICE_REQUEST
6730: (p_control_rec => l_control_rec
6731: --,p_line_tbl => l_Req_line_tbl
6732: --,p_qual_tbl => l_Req_qual_tbl
6733: --,p_line_attr_tbl => l_Req_line_attr_tbl

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

6920: or lines.adjusted_unit_price is NULL
6921: or lines.price_list_header_id is NULL)
6922: and lines.process_status <> 'NOT_VALID'
6923: --bug 3968023
6924: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED
6925: ;
6926: -- Bug 2079138: booked lines should always have price
6927: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
6928: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION