APPS.ASO_PRICING_CALLBACK_PVT dependencies on FND_API

Line 17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

13:
14:
15: PROCEDURE Config_Callback_Pricing_Order(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

Line 18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

14:
15: PROCEDURE Config_Callback_Pricing_Order(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

99: -- Standard Start of API savepoint
100: SAVEPOINT ASO_PRICING_CALLBACK_PVT;
101:
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
104: p_api_version_number,
105: l_api_name,
106: G_PKG_NAME)
107: THEN

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: p_api_version_number,
105: l_api_name,
106: G_PKG_NAME)
107: THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )

Line 112: IF FND_API.to_Boolean( p_init_msg_list )

108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )
113: THEN
114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
115: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');
116: END IF;

Line 115: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');

111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )
113: THEN
114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
115: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');
116: END IF;
117: FND_MSG_PUB.initialize;
118: END IF;
119:

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: END IF;
117: FND_MSG_PUB.initialize;
118: END IF;
119:
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
123: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:p_control_rec.request_type:'||p_control_rec.request_type,1,'N');
124: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'N');

Line 188: OR l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) Then

184: FOR i IN 1..l_qte_line_tbl.count LOOP/*Main Loop for preparing Lines from Quote in the Price Req Strcture*/
185: l_qte_line_tbl(i).currency_code := p_qte_header_rec.currency_code;
186:
187: If (l_qte_line_tbl(i).price_list_id is null
188: OR l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) Then
189: l_qte_line_tbl(i).price_list_id := p_qte_header_rec.price_list_id;
190: End if;
191:
192: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303:
304: i := lx_req_line_tbl.FIRST;
305: WHILE i IS NOT NULL LOOP
306: lx_req_line_rec := lx_req_line_tbl(i);
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,

Line 311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,

307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
315: QP_PREQ_GRP.g_status_best_price_eval_error,

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
315: QP_PREQ_GRP.g_status_best_price_eval_error,
316: QP_PREQ_PUB.g_back_calculation_sts) THEN
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: END IF;
319: If lx_req_line_rec.status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
320: IF FND_PROFILE.value('ASO_GSA_PRICING') = 'ERROR' THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: x_return_status := FND_API.G_RET_STS_ERROR;
318: END IF;
319: If lx_req_line_rec.status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
320: IF FND_PROFILE.value('ASO_GSA_PRICING') = 'ERROR' THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: FND_MESSAGE.Set_Name('ASO', 'GSA Violation in Pricing');
323: FND_MSG_PUB.ADD;
324: END IF;
325:

Line 333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

329: END IF;
330: End if;
331:
332: If lx_req_line_rec.status_code <>QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
337: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

Line 334: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

330: End if;
331:
332: If lx_req_line_rec.status_code <>QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
337: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
338: FND_MESSAGE.Set_Token('ROW', 'ASO_PRICING_CALLBACK_PVT AFTER PRICING CALL', TRUE);

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331:
332: If lx_req_line_rec.status_code <>QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
337: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
338: FND_MESSAGE.Set_Token('ROW', 'ASO_PRICING_CALLBACK_PVT AFTER PRICING CALL', TRUE);
339: FND_MSG_PUB.ADD;

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
338: FND_MESSAGE.Set_Token('ROW', 'ASO_PRICING_CALLBACK_PVT AFTER PRICING CALL', TRUE);
339: FND_MSG_PUB.ADD;
340: END IF;
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: ELSE
343: l_message_text := lx_req_line_rec.status_code || ': '||lx_req_line_rec.status_text;
344: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
345: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:After GSA Violation QP ERROR '||l_message_text, 1, 'Y');

Line 385: IF lv_return_status <> FND_API.G_RET_STS_SUCCESS THEN

381: END IF;
382:
383: x_qte_line_tbl := lx_qte_line_tbl;
384:
385: IF lv_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: x_return_status := lv_return_status;
387: RAISE FND_API.G_EXC_ERROR;
388: End If;
389:

Line 387: RAISE FND_API.G_EXC_ERROR;

383: x_qte_line_tbl := lx_qte_line_tbl;
384:
385: IF lv_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: x_return_status := lv_return_status;
387: RAISE FND_API.G_EXC_ERROR;
388: End If;
389:
390: End If; --l_qte_line_tbl.count
391:

Line 394: IF FND_API.to_Boolean( p_commit ) THEN

390: End If; --l_qte_line_tbl.count
391:
392:
393: -- Standard check for p_commit
394: IF FND_API.to_Boolean( p_commit ) THEN
395: COMMIT WORK;
396: END IF;
397:
398: FND_MSG_PUB.Count_And_Get

Line 413: WHEN FND_API.G_EXC_ERROR THEN

409: END IF;
410: end loop;
411:
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
415: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:After inside EXCEPTION return status'||x_return_status, 1, 'N');
416: END IF;
417: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME
431: ,P_PKG_NAME => G_PKG_NAME
432: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 457: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

453:
454:
455: PROCEDURE Config_Callback_Pricing_Order (
456: P_Api_Version_Number IN NUMBER,
457: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
458: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
460: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
461: p_qte_header_id IN NUMBER,

Line 458: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

454:
455: PROCEDURE Config_Callback_Pricing_Order (
456: P_Api_Version_Number IN NUMBER,
457: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
458: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
460: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
461: p_qte_header_id IN NUMBER,
462: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 528: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

524: -- Standard Start of API savepoint
525: SAVEPOINT ASO_PRICING_CALLBACK_PVT;
526:
527: -- Standard call to check for call compatibility.
528: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
529: p_api_version_number,
530: l_api_name,
531: G_PKG_NAME)
532: THEN

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: p_api_version_number,
530: l_api_name,
531: G_PKG_NAME)
532: THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;
535:
536:
537: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 538: IF FND_API.to_Boolean( p_init_msg_list )

534: END IF;
535:
536:
537: -- Initialize message list if p_init_msg_list is set to TRUE.
538: IF FND_API.to_Boolean( p_init_msg_list )
539: THEN
540: FND_MSG_PUB.initialize;
541: END IF;
542:

Line 543: x_return_status := FND_API.G_RET_STS_SUCCESS;

539: THEN
540: FND_MSG_PUB.initialize;
541: END IF;
542:
543: x_return_status := FND_API.G_RET_STS_SUCCESS;
544: l_request_type := p_control_rec.request_type;
545: l_pricing_event := p_control_rec.pricing_event;
546:
547: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

Line 555: P_Init_Msg_List => FND_API.G_FALSE,

551: END IF;
552: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);
553: ASO_PRICING_CALLBACK_PVT.Config_Callback_Pricing_Order(
554: P_Api_Version_Number => 1.0,
555: P_Init_Msg_List => FND_API.G_FALSE,
556: P_Commit => FND_API.G_FALSE,
557: p_control_rec => p_control_rec,
558: p_qte_header_rec => l_qte_header_rec,
559: p_hd_shipment_rec => l_shipment_rec,

Line 556: P_Commit => FND_API.G_FALSE,

552: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);
553: ASO_PRICING_CALLBACK_PVT.Config_Callback_Pricing_Order(
554: P_Api_Version_Number => 1.0,
555: P_Init_Msg_List => FND_API.G_FALSE,
556: P_Commit => FND_API.G_FALSE,
557: p_control_rec => p_control_rec,
558: p_qte_header_rec => l_qte_header_rec,
559: p_hd_shipment_rec => l_shipment_rec,
560: p_hd_price_attr_tbl => l_price_attr_tbl,

Line 577: IF FND_API.to_Boolean( p_commit )

573: x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data );
575:
576: -- Standard check for p_commit
577: IF FND_API.to_Boolean( p_commit )
578: THEN
579: COMMIT WORK;
580: END IF;
581:

Line 588: WHEN FND_API.G_EXC_ERROR THEN

584: p_data => x_msg_data
585: );
586:
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

596: ,X_MSG_COUNT => X_MSG_COUNT
597: ,X_MSG_DATA => X_MSG_DATA
598: ,X_RETURN_STATUS => X_RETURN_STATUS);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 643: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

639: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
640: END IF;
641: for i in 1..p_pricing_contexts_Tbl.count loop
642: l_attr_index := l_attr_index +1;
643: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
644: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'N';
645: ELSE
646: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'Y';
647: END IF;

Line 660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

656: end loop;
657: -- Copy the qualifiers
658: for i in 1..p_qualifier_contexts_Tbl.count loop
659: l_qual_index := l_qual_index +1;
660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
661: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'N';
662: ELSE
663: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'Y';
664: END IF;

Line 692: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

688: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
689: END IF;
690: for i in 1..p_pricing_contexts_Tbl.count loop
691: l_attr_index := l_attr_index +1;
692: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
693: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'N';
694: ELSE
695: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'Y';
696: END IF;

Line 720: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

716: end loop;
717:
718: if copy_hdr_rec_to_line_flag then
719: l_qual_index := l_qual_index +1;
720: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
721: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'N';
722: ELSE
723: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'Y';
724: END IF;

Line 776: and (p_header_id is not null and p_header_id <> FND_API.G_MISS_NUM)

772: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
773: ,Override_Flag
774: from aso_price_attributes a
775: where ( a.QUOTE_HEADER_ID = p_header_id )
776: and (p_header_id is not null and p_header_id <> FND_API.G_MISS_NUM)
777: and a.quote_line_id is null
778: /*
779: * New Code - Union is changed to union all
780: */

Line 811: and (p_line_id is not null and p_line_id <> FND_API.G_MISS_NUM);

807: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
808: ,Override_Flag
809: from aso_price_attributes a
810: where ( a.QUOTE_line_id = p_line_id )
811: and (p_line_id is not null and p_line_id <> FND_API.G_MISS_NUM);
812:
813: begin
814: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
815: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT: In PL/SQL tbl,append_asked_for - Global_Header_Rec quote_status_id'

Line 1634: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1630: else -- Copy the Qualifiers
1631: if asked_for_rec.PRICING_ATTRIBUTE1 is not null then -- Promotion
1632: i := px_Req_Qual_Tbl.count+1;
1633: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
1634: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1635: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
1636: ELSE
1637: px_Req_Qual_Tbl(i).Validated_Flag := 'Y';
1638: END IF;

Line 1647: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1643: if asked_for_rec.PRICING_ATTRIBUTE2 is not null then --Deal Component
1644: i := px_Req_Qual_Tbl.count+1;
1645: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
1646: --px_Req_Qual_Tbl(i).Validated_Flag := nvl(asked_for_rec.Override_Flag,'N');
1647: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1648: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
1649: ELSE
1650: px_Req_Qual_Tbl(i).Validated_Flag := 'Y';
1651: END IF;

Line 1660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1656: if asked_for_rec.PRICING_ATTRIBUTE3 is not null then -- Coupons
1657: i := px_Req_Qual_Tbl.count+1;
1658: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
1659: --px_Req_Qual_Tbl(i).Validated_Flag := nvl(asked_for_rec.Override_Flag,'N');
1660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1661: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
1662: ELSE
1663: px_Req_Qual_Tbl(i).Validated_Flag := 'Y';
1664: END IF;

Line 1688: if l_pricing_attr_rec.PRICING_ATTRIBUTE1 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE1 <> FND_API.G_MISS_CHAR then

1684: BEGIN
1685: FOR j IN 1..p_pricing_attr_tbl.count LOOP
1686: l_pricing_attr_rec := p_pricing_attr_tbl(j);
1687: IF l_pricing_attr_rec.flex_title = 'QP_ATTR_DEFNS_PRICING' THEN
1688: if l_pricing_attr_rec.PRICING_ATTRIBUTE1 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE1 <> FND_API.G_MISS_CHAR then
1689: i := px_Req_line_attr_tbl.count+1;
1690: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1691: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1692: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1696: if l_pricing_attr_rec.PRICING_ATTRIBUTE2 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE2 <> FND_API.G_MISS_CHAR then

1692: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1693: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE1';
1694: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE1;
1695: end if;
1696: if l_pricing_attr_rec.PRICING_ATTRIBUTE2 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE2 <> FND_API.G_MISS_CHAR then
1697: i := px_Req_line_attr_tbl.count+1;
1698: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1699: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1700: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1704: if l_pricing_attr_rec.PRICING_ATTRIBUTE3 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE3 <> FND_API.G_MISS_CHAR then

1700: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1701: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE2';
1702: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE2;
1703: end if;
1704: if l_pricing_attr_rec.PRICING_ATTRIBUTE3 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE3 <> FND_API.G_MISS_CHAR then
1705: i := px_Req_line_attr_tbl.count+1;
1706: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1707: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1708: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1712: if l_pricing_attr_rec.PRICING_ATTRIBUTE4 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE4 <> FND_API.G_MISS_CHAR then

1708: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1709: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE3';
1710: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE3;
1711: end if;
1712: if l_pricing_attr_rec.PRICING_ATTRIBUTE4 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE4 <> FND_API.G_MISS_CHAR then
1713: i := px_Req_line_attr_tbl.count+1;
1714: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1715: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1716: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1720: if l_pricing_attr_rec.PRICING_ATTRIBUTE5 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE5 <> FND_API.G_MISS_CHAR then

1716: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1717: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE4';
1718: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE4;
1719: end if;
1720: if l_pricing_attr_rec.PRICING_ATTRIBUTE5 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE5 <> FND_API.G_MISS_CHAR then
1721: i := px_Req_line_attr_tbl.count+1;
1722: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1723: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1724: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1728: if l_pricing_attr_rec.PRICING_ATTRIBUTE6 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE6 <> FND_API.G_MISS_CHAR then

1724: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1725: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE5';
1726: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE5;
1727: end if;
1728: if l_pricing_attr_rec.PRICING_ATTRIBUTE6 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE6 <> FND_API.G_MISS_CHAR then
1729: i := px_Req_line_attr_tbl.count+1;
1730: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1731: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1732: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1736: if l_pricing_attr_rec.PRICING_ATTRIBUTE7 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE7 <> FND_API.G_MISS_CHAR then

1732: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1733: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE6';
1734: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE6;
1735: end if;
1736: if l_pricing_attr_rec.PRICING_ATTRIBUTE7 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE7 <> FND_API.G_MISS_CHAR then
1737: i := px_Req_line_attr_tbl.count+1;
1738: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1739: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1740: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1744: if l_pricing_attr_rec.PRICING_ATTRIBUTE8 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE8 <> FND_API.G_MISS_CHAR then

1740: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1741: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE7';
1742: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE7;
1743: end if;
1744: if l_pricing_attr_rec.PRICING_ATTRIBUTE8 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE8 <> FND_API.G_MISS_CHAR then
1745: i := px_Req_line_attr_tbl.count+1;
1746: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1747: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1748: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1752: if l_pricing_attr_rec.PRICING_ATTRIBUTE9 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE9 <> FND_API.G_MISS_CHAR then

1748: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1749: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE8';
1750: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE8;
1751: end if;
1752: if l_pricing_attr_rec.PRICING_ATTRIBUTE9 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE9 <> FND_API.G_MISS_CHAR then
1753: i := px_Req_line_attr_tbl.count+1;
1754: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1755: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1756: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1761: if l_pricing_attr_rec.PRICING_ATTRIBUTE10 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE10 <> FND_API.G_MISS_CHAR then

1757: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE9';
1758: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE9;
1759: end if;
1760:
1761: if l_pricing_attr_rec.PRICING_ATTRIBUTE10 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE10 <> FND_API.G_MISS_CHAR then
1762: i := px_Req_line_attr_tbl.count+1;
1763: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1764: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1765: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1769: if l_pricing_attr_rec.PRICING_ATTRIBUTE11 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE11 <> FND_API.G_MISS_CHAR then

1765: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1766: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE10';
1767: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE10;
1768: end if;
1769: if l_pricing_attr_rec.PRICING_ATTRIBUTE11 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE11 <> FND_API.G_MISS_CHAR then
1770: i := px_Req_line_attr_tbl.count+1;
1771: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1772: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1773: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1777: if l_pricing_attr_rec.PRICING_ATTRIBUTE12 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE12 <> FND_API.G_MISS_CHAR then

1773: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1774: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE11';
1775: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE11;
1776: end if;
1777: if l_pricing_attr_rec.PRICING_ATTRIBUTE12 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE12 <> FND_API.G_MISS_CHAR then
1778: i := px_Req_line_attr_tbl.count+1;
1779: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1780: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1781: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1785: if l_pricing_attr_rec.PRICING_ATTRIBUTE13 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE13 <> FND_API.G_MISS_CHAR then

1781: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1782: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE12';
1783: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE12;
1784: end if;
1785: if l_pricing_attr_rec.PRICING_ATTRIBUTE13 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE13 <> FND_API.G_MISS_CHAR then
1786: i := px_Req_line_attr_tbl.count+1;
1787: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1788: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1789: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1793: if l_pricing_attr_rec.PRICING_ATTRIBUTE14 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE14 <> FND_API.G_MISS_CHAR then

1789: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1790: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE13';
1791: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE13;
1792: end if;
1793: if l_pricing_attr_rec.PRICING_ATTRIBUTE14 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE14 <> FND_API.G_MISS_CHAR then
1794: i := px_Req_line_attr_tbl.count+1;
1795: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1796: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1797: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1801: if l_pricing_attr_rec.PRICING_ATTRIBUTE15 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE15 <> FND_API.G_MISS_CHAR then

1797: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1798: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE14';
1799: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE14;
1800: end if;
1801: if l_pricing_attr_rec.PRICING_ATTRIBUTE15 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE15 <> FND_API.G_MISS_CHAR then
1802: i := px_Req_line_attr_tbl.count+1;
1803: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1804: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1805: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1809: if l_pricing_attr_rec.PRICING_ATTRIBUTE16 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE16 <> FND_API.G_MISS_CHAR then

1805: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1806: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE15';
1807: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE15;
1808: end if;
1809: if l_pricing_attr_rec.PRICING_ATTRIBUTE16 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE16 <> FND_API.G_MISS_CHAR then
1810: i := px_Req_line_attr_tbl.count+1;
1811: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1812: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1813: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1817: if l_pricing_attr_rec.PRICING_ATTRIBUTE17 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE17 <> FND_API.G_MISS_CHAR then

1813: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1814: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE16';
1815: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE16;
1816: end if;
1817: if l_pricing_attr_rec.PRICING_ATTRIBUTE17 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE17 <> FND_API.G_MISS_CHAR then
1818: i := px_Req_line_attr_tbl.count+1;
1819: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1820: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1821: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1825: if l_pricing_attr_rec.PRICING_ATTRIBUTE18 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE18 <> FND_API.G_MISS_CHAR then

1821: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1822: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE17';
1823: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE17;
1824: end if;
1825: if l_pricing_attr_rec.PRICING_ATTRIBUTE18 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE18 <> FND_API.G_MISS_CHAR then
1826: i := px_Req_line_attr_tbl.count+1;
1827: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1828: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1829: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1833: if l_pricing_attr_rec.PRICING_ATTRIBUTE19 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE19 <> FND_API.G_MISS_CHAR then

1829: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1830: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE18';
1831: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE18;
1832: end if;
1833: if l_pricing_attr_rec.PRICING_ATTRIBUTE19 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE19 <> FND_API.G_MISS_CHAR then
1834: i := px_Req_line_attr_tbl.count+1;
1835: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1836: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1837: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1842: if l_pricing_attr_rec.PRICING_ATTRIBUTE20 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE20 <> FND_API.G_MISS_CHAR then

1838: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE19';
1839: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE19;
1840: end if;
1841:
1842: if l_pricing_attr_rec.PRICING_ATTRIBUTE20 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE20 <> FND_API.G_MISS_CHAR then
1843: i := px_Req_line_attr_tbl.count+1;
1844: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1845: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1846: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1850: if l_pricing_attr_rec.PRICING_ATTRIBUTE21 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE21 <> FND_API.G_MISS_CHAR then

1846: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1847: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE20';
1848: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE20;
1849: end if;
1850: if l_pricing_attr_rec.PRICING_ATTRIBUTE21 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE21 <> FND_API.G_MISS_CHAR then
1851: i := px_Req_line_attr_tbl.count+1;
1852: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1853: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1854: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1858: if l_pricing_attr_rec.PRICING_ATTRIBUTE22 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE22 <> FND_API.G_MISS_CHAR then

1854: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1855: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE21';
1856: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE21;
1857: end if;
1858: if l_pricing_attr_rec.PRICING_ATTRIBUTE22 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE22 <> FND_API.G_MISS_CHAR then
1859: i := px_Req_line_attr_tbl.count+1;
1860: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1861: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1862: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1866: if l_pricing_attr_rec.PRICING_ATTRIBUTE23 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE23 <> FND_API.G_MISS_CHAR then

1862: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1863: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE22';
1864: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE22;
1865: end if;
1866: if l_pricing_attr_rec.PRICING_ATTRIBUTE23 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE23 <> FND_API.G_MISS_CHAR then
1867: i := px_Req_line_attr_tbl.count+1;
1868: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1869: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1870: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1874: if l_pricing_attr_rec.PRICING_ATTRIBUTE24 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE24 <> FND_API.G_MISS_CHAR then

1870: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1871: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE23';
1872: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE23;
1873: end if;
1874: if l_pricing_attr_rec.PRICING_ATTRIBUTE24 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE24 <> FND_API.G_MISS_CHAR then
1875: i := px_Req_line_attr_tbl.count+1;
1876: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1877: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1878: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1882: if l_pricing_attr_rec.PRICING_ATTRIBUTE25 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE25 <> FND_API.G_MISS_CHAR then

1878: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1879: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE24';
1880: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE24;
1881: end if;
1882: if l_pricing_attr_rec.PRICING_ATTRIBUTE25 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE25 <> FND_API.G_MISS_CHAR then
1883: i := px_Req_line_attr_tbl.count+1;
1884: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1885: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1886: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1890: if l_pricing_attr_rec.PRICING_ATTRIBUTE26 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE26 <> FND_API.G_MISS_CHAR then

1886: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1887: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE25';
1888: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE25;
1889: end if;
1890: if l_pricing_attr_rec.PRICING_ATTRIBUTE26 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE26 <> FND_API.G_MISS_CHAR then
1891: i := px_Req_line_attr_tbl.count+1;
1892: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1893: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1894: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1898: if l_pricing_attr_rec.PRICING_ATTRIBUTE27 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE27 <> FND_API.G_MISS_CHAR then

1894: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1895: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE26';
1896: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE26;
1897: end if;
1898: if l_pricing_attr_rec.PRICING_ATTRIBUTE27 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE27 <> FND_API.G_MISS_CHAR then
1899: i := px_Req_line_attr_tbl.count+1;
1900: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1901: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1902: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1906: if l_pricing_attr_rec.PRICING_ATTRIBUTE28 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE28 <> FND_API.G_MISS_CHAR then

1902: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1903: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE27';
1904: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE27;
1905: end if;
1906: if l_pricing_attr_rec.PRICING_ATTRIBUTE28 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE28 <> FND_API.G_MISS_CHAR then
1907: i := px_Req_line_attr_tbl.count+1;
1908: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1909: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1910: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1914: if l_pricing_attr_rec.PRICING_ATTRIBUTE29 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE29 <> FND_API.G_MISS_CHAR then

1910: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1911: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE28';
1912: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE28;
1913: end if;
1914: if l_pricing_attr_rec.PRICING_ATTRIBUTE29 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE29 <> FND_API.G_MISS_CHAR then
1915: i := px_Req_line_attr_tbl.count+1;
1916: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1917: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1918: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1923: if l_pricing_attr_rec.PRICING_ATTRIBUTE30 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE30 <> FND_API.G_MISS_CHAR then

1919: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE29';
1920: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE29;
1921: end if;
1922:
1923: if l_pricing_attr_rec.PRICING_ATTRIBUTE30 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE30 <> FND_API.G_MISS_CHAR then
1924: i := px_Req_line_attr_tbl.count+1;
1925: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1926: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1927: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1931: if l_pricing_attr_rec.PRICING_ATTRIBUTE31 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE31 <> FND_API.G_MISS_CHAR then

1927: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1928: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE30';
1929: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE30;
1930: end if;
1931: if l_pricing_attr_rec.PRICING_ATTRIBUTE31 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE31 <> FND_API.G_MISS_CHAR then
1932: i := px_Req_line_attr_tbl.count+1;
1933: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1934: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1935: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1939: if l_pricing_attr_rec.PRICING_ATTRIBUTE32 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE32 <> FND_API.G_MISS_CHAR then

1935: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1936: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE31';
1937: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE31;
1938: end if;
1939: if l_pricing_attr_rec.PRICING_ATTRIBUTE32 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE32 <> FND_API.G_MISS_CHAR then
1940: i := px_Req_line_attr_tbl.count+1;
1941: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1942: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1943: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1947: if l_pricing_attr_rec.PRICING_ATTRIBUTE33 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE33 <> FND_API.G_MISS_CHAR then

1943: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1944: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE32';
1945: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE32;
1946: end if;
1947: if l_pricing_attr_rec.PRICING_ATTRIBUTE33 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE33 <> FND_API.G_MISS_CHAR then
1948: i := px_Req_line_attr_tbl.count+1;
1949: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1950: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1951: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1955: if l_pricing_attr_rec.PRICING_ATTRIBUTE34 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE34 <> FND_API.G_MISS_CHAR then

1951: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1952: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE33';
1953: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE33;
1954: end if;
1955: if l_pricing_attr_rec.PRICING_ATTRIBUTE34 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE34 <> FND_API.G_MISS_CHAR then
1956: i := px_Req_line_attr_tbl.count+1;
1957: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1958: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1959: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1963: if l_pricing_attr_rec.PRICING_ATTRIBUTE35 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE35 <> FND_API.G_MISS_CHAR then

1959: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1960: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE34';
1961: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE34;
1962: end if;
1963: if l_pricing_attr_rec.PRICING_ATTRIBUTE35 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE35 <> FND_API.G_MISS_CHAR then
1964: i := px_Req_line_attr_tbl.count+1;
1965: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1966: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1967: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1971: if l_pricing_attr_rec.PRICING_ATTRIBUTE36 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE36 <> FND_API.G_MISS_CHAR then

1967: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1968: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE35';
1969: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE35;
1970: end if;
1971: if l_pricing_attr_rec.PRICING_ATTRIBUTE36 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE36 <> FND_API.G_MISS_CHAR then
1972: i := px_Req_line_attr_tbl.count+1;
1973: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1974: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1975: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1979: if l_pricing_attr_rec.PRICING_ATTRIBUTE37 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE37 <> FND_API.G_MISS_CHAR then

1975: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1976: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE36';
1977: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE36;
1978: end if;
1979: if l_pricing_attr_rec.PRICING_ATTRIBUTE37 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE37 <> FND_API.G_MISS_CHAR then
1980: i := px_Req_line_attr_tbl.count+1;
1981: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1982: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1983: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1987: if l_pricing_attr_rec.PRICING_ATTRIBUTE38 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE38 <> FND_API.G_MISS_CHAR then

1983: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1984: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE37';
1985: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE37;
1986: end if;
1987: if l_pricing_attr_rec.PRICING_ATTRIBUTE38 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE38 <> FND_API.G_MISS_CHAR then
1988: i := px_Req_line_attr_tbl.count+1;
1989: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1990: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1991: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 1995: if l_pricing_attr_rec.PRICING_ATTRIBUTE39 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE39 <> FND_API.G_MISS_CHAR then

1991: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
1992: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE38';
1993: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE38;
1994: end if;
1995: if l_pricing_attr_rec.PRICING_ATTRIBUTE39 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE39 <> FND_API.G_MISS_CHAR then
1996: i := px_Req_line_attr_tbl.count+1;
1997: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
1998: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
1999: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2004: if l_pricing_attr_rec.PRICING_ATTRIBUTE40 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE40 <> FND_API.G_MISS_CHAR then

2000: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE39';
2001: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE39;
2002: end if;
2003:
2004: if l_pricing_attr_rec.PRICING_ATTRIBUTE40 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE40 <> FND_API.G_MISS_CHAR then
2005: i := px_Req_line_attr_tbl.count+1;
2006: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2007: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2008: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2012: if l_pricing_attr_rec.PRICING_ATTRIBUTE41 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE41 <> FND_API.G_MISS_CHAR then

2008: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2009: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE40';
2010: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE40;
2011: end if;
2012: if l_pricing_attr_rec.PRICING_ATTRIBUTE41 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE41 <> FND_API.G_MISS_CHAR then
2013: i := px_Req_line_attr_tbl.count+1;
2014: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2015: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2016: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2020: if l_pricing_attr_rec.PRICING_ATTRIBUTE42 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE42 <> FND_API.G_MISS_CHAR then

2016: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2017: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE41';
2018: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE41;
2019: end if;
2020: if l_pricing_attr_rec.PRICING_ATTRIBUTE42 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE42 <> FND_API.G_MISS_CHAR then
2021: i := px_Req_line_attr_tbl.count+1;
2022: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2023: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2024: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2028: if l_pricing_attr_rec.PRICING_ATTRIBUTE43 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE43 <> FND_API.G_MISS_CHAR then

2024: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2025: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE42';
2026: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE42;
2027: end if;
2028: if l_pricing_attr_rec.PRICING_ATTRIBUTE43 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE43 <> FND_API.G_MISS_CHAR then
2029: i := px_Req_line_attr_tbl.count+1;
2030: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2031: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2032: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2036: if l_pricing_attr_rec.PRICING_ATTRIBUTE44 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE44 <> FND_API.G_MISS_CHAR then

2032: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2033: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE43';
2034: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE43;
2035: end if;
2036: if l_pricing_attr_rec.PRICING_ATTRIBUTE44 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE44 <> FND_API.G_MISS_CHAR then
2037: i := px_Req_line_attr_tbl.count+1;
2038: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2039: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2040: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2044: if l_pricing_attr_rec.PRICING_ATTRIBUTE45 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE45 <> FND_API.G_MISS_CHAR then

2040: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2041: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE44';
2042: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE44;
2043: end if;
2044: if l_pricing_attr_rec.PRICING_ATTRIBUTE45 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE45 <> FND_API.G_MISS_CHAR then
2045: i := px_Req_line_attr_tbl.count+1;
2046: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2047: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2048: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2052: if l_pricing_attr_rec.PRICING_ATTRIBUTE46 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE46 <> FND_API.G_MISS_CHAR then

2048: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2049: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE45';
2050: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE45;
2051: end if;
2052: if l_pricing_attr_rec.PRICING_ATTRIBUTE46 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE46 <> FND_API.G_MISS_CHAR then
2053: i := px_Req_line_attr_tbl.count+1;
2054: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2055: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2056: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2060: if l_pricing_attr_rec.PRICING_ATTRIBUTE47 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE47 <> FND_API.G_MISS_CHAR then

2056: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2057: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE46';
2058: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE46;
2059: end if;
2060: if l_pricing_attr_rec.PRICING_ATTRIBUTE47 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE47 <> FND_API.G_MISS_CHAR then
2061: i := px_Req_line_attr_tbl.count+1;
2062: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2063: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2064: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2068: if l_pricing_attr_rec.PRICING_ATTRIBUTE48 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE48 <> FND_API.G_MISS_CHAR then

2064: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2065: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE47';
2066: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE47;
2067: end if;
2068: if l_pricing_attr_rec.PRICING_ATTRIBUTE48 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE48 <> FND_API.G_MISS_CHAR then
2069: i := px_Req_line_attr_tbl.count+1;
2070: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2071: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2072: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2076: if l_pricing_attr_rec.PRICING_ATTRIBUTE49 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE49 <> FND_API.G_MISS_CHAR then

2072: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2073: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE48';
2074: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE48;
2075: end if;
2076: if l_pricing_attr_rec.PRICING_ATTRIBUTE49 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE49 <> FND_API.G_MISS_CHAR then
2077: i := px_Req_line_attr_tbl.count+1;
2078: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2079: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2080: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2085: if l_pricing_attr_rec.PRICING_ATTRIBUTE50 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE50 <> FND_API.G_MISS_CHAR then

2081: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE49';
2082: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE49;
2083: end if;
2084:
2085: if l_pricing_attr_rec.PRICING_ATTRIBUTE50 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE50 <> FND_API.G_MISS_CHAR then
2086: i := px_Req_line_attr_tbl.count+1;
2087: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2088: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2089: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2093: if l_pricing_attr_rec.PRICING_ATTRIBUTE51 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE51 <> FND_API.G_MISS_CHAR then

2089: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2090: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE50';
2091: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE50;
2092: end if;
2093: if l_pricing_attr_rec.PRICING_ATTRIBUTE51 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE51 <> FND_API.G_MISS_CHAR then
2094: i := px_Req_line_attr_tbl.count+1;
2095: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2096: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2097: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2101: if l_pricing_attr_rec.PRICING_ATTRIBUTE52 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE52 <> FND_API.G_MISS_CHAR then

2097: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2098: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE51';
2099: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE51;
2100: end if;
2101: if l_pricing_attr_rec.PRICING_ATTRIBUTE52 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE52 <> FND_API.G_MISS_CHAR then
2102: i := px_Req_line_attr_tbl.count+1;
2103: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2104: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2105: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2109: if l_pricing_attr_rec.PRICING_ATTRIBUTE53 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE53 <> FND_API.G_MISS_CHAR then

2105: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2106: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE52';
2107: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE52;
2108: end if;
2109: if l_pricing_attr_rec.PRICING_ATTRIBUTE53 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE53 <> FND_API.G_MISS_CHAR then
2110: i := px_Req_line_attr_tbl.count+1;
2111: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2112: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2113: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2117: if l_pricing_attr_rec.PRICING_ATTRIBUTE54 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE54 <> FND_API.G_MISS_CHAR then

2113: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2114: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE53';
2115: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE53;
2116: end if;
2117: if l_pricing_attr_rec.PRICING_ATTRIBUTE54 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE54 <> FND_API.G_MISS_CHAR then
2118: i := px_Req_line_attr_tbl.count+1;
2119: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2120: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2121: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2125: if l_pricing_attr_rec.PRICING_ATTRIBUTE55 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE55 <> FND_API.G_MISS_CHAR then

2121: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2122: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE54';
2123: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE54;
2124: end if;
2125: if l_pricing_attr_rec.PRICING_ATTRIBUTE55 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE55 <> FND_API.G_MISS_CHAR then
2126: i := px_Req_line_attr_tbl.count+1;
2127: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2128: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2129: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2133: if l_pricing_attr_rec.PRICING_ATTRIBUTE56 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE56 <> FND_API.G_MISS_CHAR then

2129: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2130: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE55';
2131: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE55;
2132: end if;
2133: if l_pricing_attr_rec.PRICING_ATTRIBUTE56 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE56 <> FND_API.G_MISS_CHAR then
2134: i := px_Req_line_attr_tbl.count+1;
2135: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2136: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2137: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2141: if l_pricing_attr_rec.PRICING_ATTRIBUTE57 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE57 <> FND_API.G_MISS_CHAR then

2137: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2138: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE56';
2139: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE56;
2140: end if;
2141: if l_pricing_attr_rec.PRICING_ATTRIBUTE57 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE57 <> FND_API.G_MISS_CHAR then
2142: i := px_Req_line_attr_tbl.count+1;
2143: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2144: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2145: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2149: if l_pricing_attr_rec.PRICING_ATTRIBUTE58 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE58 <> FND_API.G_MISS_CHAR then

2145: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2146: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE57';
2147: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE57;
2148: end if;
2149: if l_pricing_attr_rec.PRICING_ATTRIBUTE58 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE58 <> FND_API.G_MISS_CHAR then
2150: i := px_Req_line_attr_tbl.count+1;
2151: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2152: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2153: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2157: if l_pricing_attr_rec.PRICING_ATTRIBUTE59 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE59 <> FND_API.G_MISS_CHAR then

2153: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2154: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE58';
2155: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE58;
2156: end if;
2157: if l_pricing_attr_rec.PRICING_ATTRIBUTE59 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE59 <> FND_API.G_MISS_CHAR then
2158: i := px_Req_line_attr_tbl.count+1;
2159: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2160: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2161: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2166: if l_pricing_attr_rec.PRICING_ATTRIBUTE60 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE60 <> FND_API.G_MISS_CHAR then

2162: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE59';
2163: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE59;
2164: end if;
2165:
2166: if l_pricing_attr_rec.PRICING_ATTRIBUTE60 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE60 <> FND_API.G_MISS_CHAR then
2167: i := px_Req_line_attr_tbl.count+1;
2168: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2169: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2170: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2174: if l_pricing_attr_rec.PRICING_ATTRIBUTE61 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE61 <> FND_API.G_MISS_CHAR then

2170: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2171: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE60';
2172: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE60;
2173: end if;
2174: if l_pricing_attr_rec.PRICING_ATTRIBUTE61 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE61 <> FND_API.G_MISS_CHAR then
2175: i := px_Req_line_attr_tbl.count+1;
2176: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2177: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2178: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2182: if l_pricing_attr_rec.PRICING_ATTRIBUTE62 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE62 <> FND_API.G_MISS_CHAR then

2178: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2179: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE61';
2180: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE61;
2181: end if;
2182: if l_pricing_attr_rec.PRICING_ATTRIBUTE62 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE62 <> FND_API.G_MISS_CHAR then
2183: i := px_Req_line_attr_tbl.count+1;
2184: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2185: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2186: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2190: if l_pricing_attr_rec.PRICING_ATTRIBUTE63 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE63 <> FND_API.G_MISS_CHAR then

2186: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2187: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE62';
2188: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE62;
2189: end if;
2190: if l_pricing_attr_rec.PRICING_ATTRIBUTE63 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE63 <> FND_API.G_MISS_CHAR then
2191: i := px_Req_line_attr_tbl.count+1;
2192: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2193: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2194: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2198: if l_pricing_attr_rec.PRICING_ATTRIBUTE64 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE64 <> FND_API.G_MISS_CHAR then

2194: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2195: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE63';
2196: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE63;
2197: end if;
2198: if l_pricing_attr_rec.PRICING_ATTRIBUTE64 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE64 <> FND_API.G_MISS_CHAR then
2199: i := px_Req_line_attr_tbl.count+1;
2200: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2201: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2202: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2206: if l_pricing_attr_rec.PRICING_ATTRIBUTE65 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE65 <> FND_API.G_MISS_CHAR then

2202: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2203: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE64';
2204: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE64;
2205: end if;
2206: if l_pricing_attr_rec.PRICING_ATTRIBUTE65 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE65 <> FND_API.G_MISS_CHAR then
2207: i := px_Req_line_attr_tbl.count+1;
2208: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2209: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2210: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2214: if l_pricing_attr_rec.PRICING_ATTRIBUTE66 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE66 <> FND_API.G_MISS_CHAR then

2210: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2211: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE65';
2212: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE65;
2213: end if;
2214: if l_pricing_attr_rec.PRICING_ATTRIBUTE66 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE66 <> FND_API.G_MISS_CHAR then
2215: i := px_Req_line_attr_tbl.count+1;
2216: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2217: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2218: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2222: if l_pricing_attr_rec.PRICING_ATTRIBUTE67 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE67 <> FND_API.G_MISS_CHAR then

2218: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2219: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE66';
2220: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE66;
2221: end if;
2222: if l_pricing_attr_rec.PRICING_ATTRIBUTE67 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE67 <> FND_API.G_MISS_CHAR then
2223: i := px_Req_line_attr_tbl.count+1;
2224: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2225: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2226: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2230: if l_pricing_attr_rec.PRICING_ATTRIBUTE68 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE68 <> FND_API.G_MISS_CHAR then

2226: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2227: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE67';
2228: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE67;
2229: end if;
2230: if l_pricing_attr_rec.PRICING_ATTRIBUTE68 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE68 <> FND_API.G_MISS_CHAR then
2231: i := px_Req_line_attr_tbl.count+1;
2232: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2233: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2234: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2238: if l_pricing_attr_rec.PRICING_ATTRIBUTE69 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE69 <> FND_API.G_MISS_CHAR then

2234: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2235: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE68';
2236: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE68;
2237: end if;
2238: if l_pricing_attr_rec.PRICING_ATTRIBUTE69 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE69 <> FND_API.G_MISS_CHAR then
2239: i := px_Req_line_attr_tbl.count+1;
2240: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2241: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2242: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2247: if l_pricing_attr_rec.PRICING_ATTRIBUTE70 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE70 <> FND_API.G_MISS_CHAR then

2243: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE69';
2244: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE69;
2245: end if;
2246:
2247: if l_pricing_attr_rec.PRICING_ATTRIBUTE70 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE70 <> FND_API.G_MISS_CHAR then
2248: i := px_Req_line_attr_tbl.count+1;
2249: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2250: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2251: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2255: if l_pricing_attr_rec.PRICING_ATTRIBUTE71 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE71 <> FND_API.G_MISS_CHAR then

2251: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2252: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE70';
2253: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE70;
2254: end if;
2255: if l_pricing_attr_rec.PRICING_ATTRIBUTE71 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE71 <> FND_API.G_MISS_CHAR then
2256: i := px_Req_line_attr_tbl.count+1;
2257: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2258: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2259: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2263: if l_pricing_attr_rec.PRICING_ATTRIBUTE72 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE72 <> FND_API.G_MISS_CHAR then

2259: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2260: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE71';
2261: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE71;
2262: end if;
2263: if l_pricing_attr_rec.PRICING_ATTRIBUTE72 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE72 <> FND_API.G_MISS_CHAR then
2264: i := px_Req_line_attr_tbl.count+1;
2265: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2266: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2267: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2271: if l_pricing_attr_rec.PRICING_ATTRIBUTE73 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE73 <> FND_API.G_MISS_CHAR then

2267: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2268: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE72';
2269: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE72;
2270: end if;
2271: if l_pricing_attr_rec.PRICING_ATTRIBUTE73 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE73 <> FND_API.G_MISS_CHAR then
2272: i := px_Req_line_attr_tbl.count+1;
2273: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2274: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2275: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2279: if l_pricing_attr_rec.PRICING_ATTRIBUTE74 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE74 <> FND_API.G_MISS_CHAR then

2275: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2276: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE73';
2277: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE73;
2278: end if;
2279: if l_pricing_attr_rec.PRICING_ATTRIBUTE74 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE74 <> FND_API.G_MISS_CHAR then
2280: i := px_Req_line_attr_tbl.count+1;
2281: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2282: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2283: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2287: if l_pricing_attr_rec.PRICING_ATTRIBUTE75 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE75 <> FND_API.G_MISS_CHAR then

2283: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2284: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE74';
2285: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE74;
2286: end if;
2287: if l_pricing_attr_rec.PRICING_ATTRIBUTE75 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE75 <> FND_API.G_MISS_CHAR then
2288: i := px_Req_line_attr_tbl.count+1;
2289: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2290: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2291: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2295: if l_pricing_attr_rec.PRICING_ATTRIBUTE76 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE76 <> FND_API.G_MISS_CHAR then

2291: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2292: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE75';
2293: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE75;
2294: end if;
2295: if l_pricing_attr_rec.PRICING_ATTRIBUTE76 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE76 <> FND_API.G_MISS_CHAR then
2296: i := px_Req_line_attr_tbl.count+1;
2297: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2298: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2299: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2303: if l_pricing_attr_rec.PRICING_ATTRIBUTE77 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE77 <> FND_API.G_MISS_CHAR then

2299: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2300: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE76';
2301: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE76;
2302: end if;
2303: if l_pricing_attr_rec.PRICING_ATTRIBUTE77 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE77 <> FND_API.G_MISS_CHAR then
2304: i := px_Req_line_attr_tbl.count+1;
2305: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2306: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2307: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2311: if l_pricing_attr_rec.PRICING_ATTRIBUTE78 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE78 <> FND_API.G_MISS_CHAR then

2307: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2308: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE77';
2309: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE77;
2310: end if;
2311: if l_pricing_attr_rec.PRICING_ATTRIBUTE78 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE78 <> FND_API.G_MISS_CHAR then
2312: i := px_Req_line_attr_tbl.count+1;
2313: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2314: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2315: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2319: if l_pricing_attr_rec.PRICING_ATTRIBUTE79 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE79 <> FND_API.G_MISS_CHAR then

2315: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2316: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE78';
2317: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE78;
2318: end if;
2319: if l_pricing_attr_rec.PRICING_ATTRIBUTE79 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE79 <> FND_API.G_MISS_CHAR then
2320: i := px_Req_line_attr_tbl.count+1;
2321: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2322: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2323: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2328: if l_pricing_attr_rec.PRICING_ATTRIBUTE80 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE80 <> FND_API.G_MISS_CHAR then

2324: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE79';
2325: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE79;
2326: end if;
2327:
2328: if l_pricing_attr_rec.PRICING_ATTRIBUTE80 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE80 <> FND_API.G_MISS_CHAR then
2329: i := px_Req_line_attr_tbl.count+1;
2330: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2331: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2332: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2336: if l_pricing_attr_rec.PRICING_ATTRIBUTE81 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE81 <> FND_API.G_MISS_CHAR then

2332: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2333: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE80';
2334: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE80;
2335: end if;
2336: if l_pricing_attr_rec.PRICING_ATTRIBUTE81 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE81 <> FND_API.G_MISS_CHAR then
2337: i := px_Req_line_attr_tbl.count+1;
2338: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2339: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2340: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2344: if l_pricing_attr_rec.PRICING_ATTRIBUTE82 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE82 <> FND_API.G_MISS_CHAR then

2340: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2341: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE81';
2342: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE81;
2343: end if;
2344: if l_pricing_attr_rec.PRICING_ATTRIBUTE82 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE82 <> FND_API.G_MISS_CHAR then
2345: i := px_Req_line_attr_tbl.count+1;
2346: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2347: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2348: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2352: if l_pricing_attr_rec.PRICING_ATTRIBUTE83 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE83 <> FND_API.G_MISS_CHAR then

2348: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2349: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE82';
2350: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE82;
2351: end if;
2352: if l_pricing_attr_rec.PRICING_ATTRIBUTE83 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE83 <> FND_API.G_MISS_CHAR then
2353: i := px_Req_line_attr_tbl.count+1;
2354: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2355: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2356: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2360: if l_pricing_attr_rec.PRICING_ATTRIBUTE84 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE84 <> FND_API.G_MISS_CHAR then

2356: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2357: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE83';
2358: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE83;
2359: end if;
2360: if l_pricing_attr_rec.PRICING_ATTRIBUTE84 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE84 <> FND_API.G_MISS_CHAR then
2361: i := px_Req_line_attr_tbl.count+1;
2362: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2363: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2364: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2368: if l_pricing_attr_rec.PRICING_ATTRIBUTE85 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE85 <> FND_API.G_MISS_CHAR then

2364: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2365: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE84';
2366: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE84;
2367: end if;
2368: if l_pricing_attr_rec.PRICING_ATTRIBUTE85 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE85 <> FND_API.G_MISS_CHAR then
2369: i := px_Req_line_attr_tbl.count+1;
2370: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2371: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2372: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2376: if l_pricing_attr_rec.PRICING_ATTRIBUTE86 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE86 <> FND_API.G_MISS_CHAR then

2372: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2373: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE85';
2374: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE85;
2375: end if;
2376: if l_pricing_attr_rec.PRICING_ATTRIBUTE86 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE86 <> FND_API.G_MISS_CHAR then
2377: i := px_Req_line_attr_tbl.count+1;
2378: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2379: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2380: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2384: if l_pricing_attr_rec.PRICING_ATTRIBUTE87 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE87 <> FND_API.G_MISS_CHAR then

2380: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2381: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE86';
2382: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE86;
2383: end if;
2384: if l_pricing_attr_rec.PRICING_ATTRIBUTE87 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE87 <> FND_API.G_MISS_CHAR then
2385: i := px_Req_line_attr_tbl.count+1;
2386: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2387: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2388: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2392: if l_pricing_attr_rec.PRICING_ATTRIBUTE88 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE88 <> FND_API.G_MISS_CHAR then

2388: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2389: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE87';
2390: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE87;
2391: end if;
2392: if l_pricing_attr_rec.PRICING_ATTRIBUTE88 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE88 <> FND_API.G_MISS_CHAR then
2393: i := px_Req_line_attr_tbl.count+1;
2394: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2395: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2396: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2400: if l_pricing_attr_rec.PRICING_ATTRIBUTE89 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE89 <> FND_API.G_MISS_CHAR then

2396: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2397: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE88';
2398: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE88;
2399: end if;
2400: if l_pricing_attr_rec.PRICING_ATTRIBUTE89 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE89 <> FND_API.G_MISS_CHAR then
2401: i := px_Req_line_attr_tbl.count+1;
2402: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2403: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2404: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2409: if l_pricing_attr_rec.PRICING_ATTRIBUTE90 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE90 <> FND_API.G_MISS_CHAR then

2405: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE89';
2406: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE89;
2407: end if;
2408:
2409: if l_pricing_attr_rec.PRICING_ATTRIBUTE90 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE90 <> FND_API.G_MISS_CHAR then
2410: i := px_Req_line_attr_tbl.count+1;
2411: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2412: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2413: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2417: if l_pricing_attr_rec.PRICING_ATTRIBUTE91 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE91 <> FND_API.G_MISS_CHAR then

2413: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2414: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE90';
2415: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE90;
2416: end if;
2417: if l_pricing_attr_rec.PRICING_ATTRIBUTE91 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE91 <> FND_API.G_MISS_CHAR then
2418: i := px_Req_line_attr_tbl.count+1;
2419: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2420: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2421: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2425: if l_pricing_attr_rec.PRICING_ATTRIBUTE92 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE92 <> FND_API.G_MISS_CHAR then

2421: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2422: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE91';
2423: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE91;
2424: end if;
2425: if l_pricing_attr_rec.PRICING_ATTRIBUTE92 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE92 <> FND_API.G_MISS_CHAR then
2426: i := px_Req_line_attr_tbl.count+1;
2427: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2428: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2429: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2433: if l_pricing_attr_rec.PRICING_ATTRIBUTE93 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE93 <> FND_API.G_MISS_CHAR then

2429: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2430: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE92';
2431: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE92;
2432: end if;
2433: if l_pricing_attr_rec.PRICING_ATTRIBUTE93 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE93 <> FND_API.G_MISS_CHAR then
2434: i := px_Req_line_attr_tbl.count+1;
2435: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2436: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2437: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2441: if l_pricing_attr_rec.PRICING_ATTRIBUTE94 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE94 <> FND_API.G_MISS_CHAR then

2437: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2438: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE93';
2439: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE93;
2440: end if;
2441: if l_pricing_attr_rec.PRICING_ATTRIBUTE94 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE94 <> FND_API.G_MISS_CHAR then
2442: i := px_Req_line_attr_tbl.count+1;
2443: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2444: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2445: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2449: if l_pricing_attr_rec.PRICING_ATTRIBUTE95 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE95 <> FND_API.G_MISS_CHAR then

2445: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2446: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE94';
2447: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE94;
2448: end if;
2449: if l_pricing_attr_rec.PRICING_ATTRIBUTE95 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE95 <> FND_API.G_MISS_CHAR then
2450: i := px_Req_line_attr_tbl.count+1;
2451: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2452: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2453: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2457: if l_pricing_attr_rec.PRICING_ATTRIBUTE96 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE96 <> FND_API.G_MISS_CHAR then

2453: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2454: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE95';
2455: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE95;
2456: end if;
2457: if l_pricing_attr_rec.PRICING_ATTRIBUTE96 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE96 <> FND_API.G_MISS_CHAR then
2458: i := px_Req_line_attr_tbl.count+1;
2459: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2460: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2461: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2465: if l_pricing_attr_rec.PRICING_ATTRIBUTE97 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE97 <> FND_API.G_MISS_CHAR then

2461: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2462: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE96';
2463: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE96;
2464: end if;
2465: if l_pricing_attr_rec.PRICING_ATTRIBUTE97 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE97 <> FND_API.G_MISS_CHAR then
2466: i := px_Req_line_attr_tbl.count+1;
2467: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2468: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2469: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2473: if l_pricing_attr_rec.PRICING_ATTRIBUTE98 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE98 <> FND_API.G_MISS_CHAR then

2469: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2470: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE97';
2471: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE97;
2472: end if;
2473: if l_pricing_attr_rec.PRICING_ATTRIBUTE98 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE98 <> FND_API.G_MISS_CHAR then
2474: i := px_Req_line_attr_tbl.count+1;
2475: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2476: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2477: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2481: if l_pricing_attr_rec.PRICING_ATTRIBUTE99 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE99 <> FND_API.G_MISS_CHAR then

2477: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2478: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE98';
2479: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE98;
2480: end if;
2481: if l_pricing_attr_rec.PRICING_ATTRIBUTE99 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE99 <> FND_API.G_MISS_CHAR then
2482: i := px_Req_line_attr_tbl.count+1;
2483: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2484: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2485: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2489: if l_pricing_attr_rec.PRICING_ATTRIBUTE100 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE100 <> FND_API.G_MISS_CHAR then

2485: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;
2486: px_Req_line_attr_tbl(i).Pricing_Attribute := 'PRICING_ATTRIBUTE99';
2487: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From :=l_pricing_attr_rec.PRICING_ATTRIBUTE99;
2488: end if;
2489: if l_pricing_attr_rec.PRICING_ATTRIBUTE100 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE100 <> FND_API.G_MISS_CHAR then
2490: i := px_Req_line_attr_tbl.count+1;
2491: px_Req_line_attr_tbl(i).Line_Index := p_Line_Index;
2492: px_Req_line_attr_tbl(i).Validated_Flag := 'N';
2493: px_Req_line_attr_tbl(i).pricing_context := l_pricing_attr_rec.pricing_context;

Line 2500: if ( l_pricing_attr_rec.PRICING_ATTRIBUTE1 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE1 <> FND_API.G_MISS_CHAR )then -- Promotion

2496: end if;
2497:
2498: ELSE -- Copy the Qualifiers
2499:
2500: if ( l_pricing_attr_rec.PRICING_ATTRIBUTE1 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE1 <> FND_API.G_MISS_CHAR )then -- Promotion
2501: i := px_Req_Qual_Tbl.count+1;
2502: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
2503: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
2504: px_Req_Qual_Tbl(i).Qualifier_Context := l_pricing_attr_rec.pricing_context;

Line 2509: if (l_pricing_attr_rec.PRICING_ATTRIBUTE2 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE2 <> FND_API.G_MISS_CHAR ) then --Deal Component

2505: px_Req_Qual_Tbl(i).Qualifier_Attribute := 'QUALIFIER_ATTRIBUTE1';
2506: px_Req_Qual_Tbl(i).Qualifier_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE1;
2507: end if;
2508:
2509: if (l_pricing_attr_rec.PRICING_ATTRIBUTE2 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE2 <> FND_API.G_MISS_CHAR ) then --Deal Component
2510: i := px_Req_Qual_Tbl.count+1;
2511: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
2512: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
2513: px_Req_Qual_Tbl(i).Qualifier_Context := l_pricing_attr_rec.pricing_context;

Line 2517: if (l_pricing_attr_rec.PRICING_ATTRIBUTE3 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE3 <> FND_API.G_MISS_CHAR ) then -- Coupons

2513: px_Req_Qual_Tbl(i).Qualifier_Context := l_pricing_attr_rec.pricing_context;
2514: px_Req_Qual_Tbl(i).Qualifier_Attribute := 'QUALIFIER_ATTRIBUTE2';
2515: px_Req_Qual_Tbl(i).Qualifier_Attr_Value_From := l_pricing_attr_rec.PRICING_ATTRIBUTE2;
2516: end if;
2517: if (l_pricing_attr_rec.PRICING_ATTRIBUTE3 is not null and l_pricing_attr_rec.PRICING_ATTRIBUTE3 <> FND_API.G_MISS_CHAR ) then -- Coupons
2518: i := px_Req_Qual_Tbl.count+1;
2519: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
2520: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
2521: px_Req_Qual_Tbl(i).Qualifier_Context := l_pricing_attr_rec.pricing_context;

Line 2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE

2544: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2545: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:g_header_rec.PRICE_FROZEN_DATE '||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'N');
2546: END IF;
2547: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2549: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2550: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
2551: else
2552: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

Line 2586: If p_Line_rec.line_list_price <> FND_API.G_MISS_NUM Then

2582: l_req_line_rec.LINE_TYPE_CODE := 'LINE';
2583: l_req_line_rec.LINE_QUANTITY := p_Line_rec.quantity;
2584: l_req_line_rec.LINE_UOM_CODE := p_Line_rec.uom_code;
2585: l_req_line_rec.CURRENCY_CODE := p_Line_rec.currency_code;
2586: If p_Line_rec.line_list_price <> FND_API.G_MISS_NUM Then
2587: l_req_line_rec.UNIT_PRICE := p_Line_rec.line_list_price;
2588: Else
2589: l_req_line_rec.UNIT_PRICE := Null;
2590: End If;

Line 2593: AND p_line_dtl_rec.service_period <> fnd_api.g_miss_char then

2589: l_req_line_rec.UNIT_PRICE := Null;
2590: End If;
2591: -- Added for Service Item after pathcset E
2592: If p_line_dtl_rec.service_period is not null
2593: AND p_line_dtl_rec.service_period <> fnd_api.g_miss_char then
2594: If (p_line_dtl_rec.service_period = p_Line_rec.uom_code) Then
2595: l_req_line_rec.UOM_QUANTITY := p_line_dtl_rec.service_duration;
2596: Else
2597: INV_CONVERT.INV_UM_CONVERSION(

Line 2627: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE

2623: ELSE
2624: l_req_line_rec.PRICE_FLAG := 'Y';
2625: END IF;
2626: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2627: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2628: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2629: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
2630: else
2631: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

Line 2672: l_base_price NUMBER := FND_API.G_MISS_NUM;

2668: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
2669: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2670: i BINARY_INTEGER;
2671: j BINARY_INTEGER;
2672: l_base_price NUMBER := FND_API.G_MISS_NUM;
2673: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
2674: l_qte_line_prcd Index_Link_Tbl_Type;
2675: l_price_adj_prcd Index_Link_Tbl_Type;
2676: lx_price_adj_prcd Index_Link_Tbl_Type;

Line 3119: l_base_price NUMBER := FND_API.G_MISS_NUM;

3115: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
3116: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3117: i BINARY_INTEGER;
3118: j BINARY_INTEGER;
3119: l_base_price NUMBER := FND_API.G_MISS_NUM;
3120: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
3121: l_qte_line_prcd Index_Link_Tbl_Type;
3122: l_price_adj_prcd Index_Link_Tbl_Type;
3123: l_message_text VARCHAR2(2000);

Line 3183: l_req_line_rec.percent_price <> FND_API.G_MISS_NUM THEN

3179: aso_debug_pub.add('ASO_PRICING_CORE_PVT:after Copy Req to line ',1,'Y');
3180: END IF;
3181: -- handle the percent price
3182: IF NVL(l_req_line_rec.percent_price, 0) <> 0 OR
3183: l_req_line_rec.percent_price <> FND_API.G_MISS_NUM THEN
3184: j := p_req_related_lines_tbl.first;
3185: WHILE j IS NOT NULL AND l_base_price = FND_API.G_MISS_NUM LOOP
3186: IF p_req_related_lines_tbl(j).line_index = i AND
3187: p_req_related_lines_tbl(j).relationship_type_code =

Line 3185: WHILE j IS NOT NULL AND l_base_price = FND_API.G_MISS_NUM LOOP

3181: -- handle the percent price
3182: IF NVL(l_req_line_rec.percent_price, 0) <> 0 OR
3183: l_req_line_rec.percent_price <> FND_API.G_MISS_NUM THEN
3184: j := p_req_related_lines_tbl.first;
3185: WHILE j IS NOT NULL AND l_base_price = FND_API.G_MISS_NUM LOOP
3186: IF p_req_related_lines_tbl(j).line_index = i AND
3187: p_req_related_lines_tbl(j).relationship_type_code =
3188: QP_PREQ_GRP.G_RELATED_ITEM_PRICE THEN
3189: l_base_price := p_req_line_tbl(p_req_related_lines_tbl(j).related_line_index).unit_price;