APPS.ASO_PRICING_FLOWS_PVT dependencies on ASO_QUOTE_PUB

Line 26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
29: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
30: p_internal_call_flag IN VARCHAR2 := 'N',

Line 27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
29: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
30: p_internal_call_flag IN VARCHAR2 := 'N',
31: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
29: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
30: p_internal_call_flag IN VARCHAR2 := 'N',
31: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
32: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 29: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

25: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
29: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
30: p_internal_call_flag IN VARCHAR2 := 'N',
31: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
32: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
33: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 31: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
29: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
30: p_internal_call_flag IN VARCHAR2 := 'N',
31: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
32: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
33: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
34: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
35: IS

Line 41: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

37: l_api_version_number CONSTANT NUMBER := 1.0;
38: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
39: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
40: l_qte_line_id NUMBER;
41: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
42: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
43: l_return_status VARCHAR2(1);
44: l_return_status_text VARCHAR2(2000);
45: l_message_text VARCHAR2(2000);

Line 42: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

38: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
39: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
40: l_qte_line_id NUMBER;
41: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
42: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
43: l_return_status VARCHAR2(1);
44: l_return_status_text VARCHAR2(2000);
45: l_message_text VARCHAR2(2000);
46: i BINARY_INTEGER;

Line 48: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

44: l_return_status_text VARCHAR2(2000);
45: l_message_text VARCHAR2(2000);
46: i BINARY_INTEGER;
47: j BINARY_INTEGER;
48: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
49: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: x_pass_line VARCHAR2(10);
52: l_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 49: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

45: l_message_text VARCHAR2(2000);
46: i BINARY_INTEGER;
47: j BINARY_INTEGER;
48: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
49: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: x_pass_line VARCHAR2(10);
52: l_qte_line_id_tbl JTF_NUMBER_TABLE;
53: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

Line 50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

46: i BINARY_INTEGER;
47: j BINARY_INTEGER;
48: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
49: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: x_pass_line VARCHAR2(10);
52: l_qte_line_id_tbl JTF_NUMBER_TABLE;
53: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
54: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 265: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

261: END IF;
262: IF l_qte_line_dtl_tbl.count = 1 THEN
263: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
264: ELSE
265: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
266: END IF;
267:
268: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
269: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 280: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

276: END IF;
277: IF l_shipment_tbl.count = 1 THEN
278: l_shipment_rec := l_shipment_tbl(1);
279: else
280: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
281: END IF;
282:
283: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
284: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Line Level...', 1, 'Y');

Line 694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

690: P_Api_Version_Number IN NUMBER,
691: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
692: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
696: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
697: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
698: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

691: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
692: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
696: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
697: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
698: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
699: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 696: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

692: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
696: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
697: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
698: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
699: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
700: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 697: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

693: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
696: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
697: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
698: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
699: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
700: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
701: IS

Line 709: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

705: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
706: l_qte_line_id NUMBER;
707: l_child_qte_line_id NUMBER;
708: l_found NUMBER;
709: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
710: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
711: l_return_status VARCHAR2(1);
712: l_return_status_text VARCHAR2(2000);
713: l_message_text VARCHAR2(2000);

Line 710: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

706: l_qte_line_id NUMBER;
707: l_child_qte_line_id NUMBER;
708: l_found NUMBER;
709: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
710: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
711: l_return_status VARCHAR2(1);
712: l_return_status_text VARCHAR2(2000);
713: l_message_text VARCHAR2(2000);
714: i BINARY_INTEGER;

Line 716: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

712: l_return_status_text VARCHAR2(2000);
713: l_message_text VARCHAR2(2000);
714: i BINARY_INTEGER;
715: j BINARY_INTEGER;
716: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
717: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 717: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

713: l_message_text VARCHAR2(2000);
714: i BINARY_INTEGER;
715: j BINARY_INTEGER;
716: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
717: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;
721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

Line 718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

714: i BINARY_INTEGER;
715: j BINARY_INTEGER;
716: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
717: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;
721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
722: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 723: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;
721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
722: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
723: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
724: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
725: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
726: l_service_proc_done_flag VARCHAR2(1);
727: l_service_product_id_tbl Index_Link_Tbl_Type;

Line 1145: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

1141: END IF;
1142: IF l_qte_line_dtl_tbl.count = 1 THEN
1143: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
1144: ELSE
1145: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
1146: END IF;
1147:
1148: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 1156: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

1152: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
1153: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1154: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'||NVL(l_shipment_tbl.count,0),1,'Y');
1155: END IF;
1156: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
1157: IF l_shipment_tbl.count = 1 THEN
1158: l_shipment_rec := l_shipment_tbl(1);
1159: END IF;
1160:

Line 1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1481: P_Api_Version_Number IN NUMBER,
1482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1483: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1484: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1488: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1489: p_internal_call_flag IN VARCHAR2 := 'N',

Line 1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

1482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1483: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1484: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1488: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1489: p_internal_call_flag IN VARCHAR2 := 'N',
1490: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

1483: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1484: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1488: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1489: p_internal_call_flag IN VARCHAR2 := 'N',
1490: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1491: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1488: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

1484: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1488: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1489: p_internal_call_flag IN VARCHAR2 := 'N',
1490: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1491: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1492: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1490: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1488: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1489: p_internal_call_flag IN VARCHAR2 := 'N',
1490: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1491: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1492: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1493: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1494: IS

Line 1500: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1496: l_api_version_number CONSTANT NUMBER := 1.0;
1497: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1498: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
1499: l_qte_line_id NUMBER;
1500: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1501: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1502: l_return_status VARCHAR2(1);
1503: l_return_status_text VARCHAR2(2000);
1504: l_message_text VARCHAR2(2000);

Line 1501: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1497: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1498: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
1499: l_qte_line_id NUMBER;
1500: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1501: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1502: l_return_status VARCHAR2(1);
1503: l_return_status_text VARCHAR2(2000);
1504: l_message_text VARCHAR2(2000);
1505: i BINARY_INTEGER;

Line 1507: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1503: l_return_status_text VARCHAR2(2000);
1504: l_message_text VARCHAR2(2000);
1505: i BINARY_INTEGER;
1506: j BINARY_INTEGER;
1507: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1508: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);

Line 1508: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1504: l_message_text VARCHAR2(2000);
1505: i BINARY_INTEGER;
1506: j BINARY_INTEGER;
1507: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1508: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);
1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1505: i BINARY_INTEGER;
1506: j BINARY_INTEGER;
1507: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1508: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);
1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1513: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

Line 1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1506: j BINARY_INTEGER;
1507: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1508: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);
1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1513: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
1514: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 1524: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1520: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
1521: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
1522: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
1523:
1524: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1525: l_changed_line_index NUMBER;
1526: l_check_line_flag VARCHAR2(1);
1527: l_complete_qte_flag VARCHAR2(1);
1528: l_db_ln_counter NUMBER;

Line 1799: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

1795: END IF;
1796: IF l_qte_line_dtl_tbl.count = 1 THEN
1797: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
1798: ELSE
1799: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
1800: END IF;
1801:
1802: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1803: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 1814: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

1810: END IF;
1811: IF l_shipment_tbl.count = 1 THEN
1812: l_shipment_rec := l_shipment_tbl(1);
1813: else
1814: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
1815: END IF;
1816: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1817: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Line Level...', 1, 'Y');
1818: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:These values will be defaulted from header for pricing qualification only:',1,'Y');

Line 2413: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

2409: P_Api_Version_Number IN NUMBER,
2410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2411: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2412: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2413: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2414: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2415: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2416: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2417: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2415: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

2411: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2412: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2413: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2414: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2415: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2416: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2417: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2418: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2419: IS

Line 2426: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

2422: l_price_index NUMBER;
2423: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2424: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
2425: x_pass_line VARCHAR2(10);
2426: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2427: l_qte_line_id NUMBER;
2428: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2429: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2430: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 2428: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

2424: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
2425: x_pass_line VARCHAR2(10);
2426: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2427: l_qte_line_id NUMBER;
2428: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2429: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2430: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2431: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2432: lx_index_counter Number;

Line 2429: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2425: x_pass_line VARCHAR2(10);
2426: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2427: l_qte_line_id NUMBER;
2428: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2429: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2430: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2431: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2432: lx_index_counter Number;
2433: l_index_counter Number;

Line 2430: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

2426: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2427: l_qte_line_id NUMBER;
2428: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2429: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2430: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2431: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2432: lx_index_counter Number;
2433: l_index_counter Number;
2434: l_return_status_text VARCHAR2(2000);

Line 2431: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

2427: l_qte_line_id NUMBER;
2428: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2429: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2430: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2431: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2432: lx_index_counter Number;
2433: l_index_counter Number;
2434: l_return_status_text VARCHAR2(2000);
2435: l_message_text VARCHAR2(2000);

Line 2594: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

2590: END IF;
2591: IF l_qte_line_dtl_tbl.count = 1 THEN
2592: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
2593: ELSE
2594: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
2595: END IF;
2596:
2597: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2598: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 2609: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

2605: END IF;
2606: IF l_shipment_tbl.count = 1 THEN
2607: l_shipment_rec := l_shipment_tbl(1);
2608: else
2609: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
2610: END IF;
2611:
2612:
2613: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN