eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.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 1323: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

1319: END IF;
1320: IF l_qte_line_dtl_tbl.count = 1 THEN
1321: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
1322: ELSE
1323: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
1324: END IF;
1325:
1326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1327: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 1334: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

1330: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
1331: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1332: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'||NVL(l_shipment_tbl.count,0),1,'Y');
1333: END IF;
1334: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
1335: IF l_shipment_tbl.count = 1 THEN
1336: l_shipment_rec := l_shipment_tbl(1);
1337: END IF;
1338:

Line 1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1659: P_Api_Version_Number IN NUMBER,
1660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1661: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1662: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1666: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1667: p_internal_call_flag IN VARCHAR2 := 'N',

Line 1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

1660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1661: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1662: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1666: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1667: p_internal_call_flag IN VARCHAR2 := 'N',
1668: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

1661: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1662: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1666: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1667: p_internal_call_flag IN VARCHAR2 := 'N',
1668: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1669: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1666: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

1662: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1666: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1667: p_internal_call_flag IN VARCHAR2 := 'N',
1668: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1669: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1670: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
1666: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1667: p_internal_call_flag IN VARCHAR2 := 'N',
1668: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1669: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1670: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1671: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1672: IS

Line 1678: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1674: l_api_version_number CONSTANT NUMBER := 1.0;
1675: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1676: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
1677: l_qte_line_id NUMBER;
1678: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1679: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1680: l_return_status VARCHAR2(1);
1681: l_return_status_text VARCHAR2(2000);
1682: l_message_text VARCHAR2(2000);

Line 1679: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1675: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1676: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
1677: l_qte_line_id NUMBER;
1678: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1679: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1680: l_return_status VARCHAR2(1);
1681: l_return_status_text VARCHAR2(2000);
1682: l_message_text VARCHAR2(2000);
1683: i BINARY_INTEGER;

Line 1685: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1681: l_return_status_text VARCHAR2(2000);
1682: l_message_text VARCHAR2(2000);
1683: i BINARY_INTEGER;
1684: j BINARY_INTEGER;
1685: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1686: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1687: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1688: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1689: x_pass_line VARCHAR2(10);

Line 1686: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1682: l_message_text VARCHAR2(2000);
1683: i BINARY_INTEGER;
1684: j BINARY_INTEGER;
1685: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1686: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1687: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1688: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1689: x_pass_line VARCHAR2(10);
1690: l_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 1687: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1683: i BINARY_INTEGER;
1684: j BINARY_INTEGER;
1685: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1686: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1687: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1688: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1689: x_pass_line VARCHAR2(10);
1690: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1691: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

Line 1688: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1684: j BINARY_INTEGER;
1685: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1686: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1687: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1688: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1689: x_pass_line VARCHAR2(10);
1690: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1691: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
1692: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

Line 1702: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1698: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
1699: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
1700: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
1701:
1702: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1703: l_changed_line_index NUMBER;
1704: l_check_line_flag VARCHAR2(1);
1705: l_complete_qte_flag VARCHAR2(1);
1706: l_db_ln_counter NUMBER;

Line 1717: ls_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1713:
1714: l_item_type_code VARCHAR2(30);
1715:
1716: -- bug 13482837
1717: ls_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1718: ls number:=0;
1719:
1720:
1721: BEGIN

Line 2039: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

2035: END IF;
2036: IF l_qte_line_dtl_tbl.count = 1 THEN
2037: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
2038: ELSE
2039: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
2040: END IF;
2041:
2042: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2043: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 2054: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

2050: END IF;
2051: IF l_shipment_tbl.count = 1 THEN
2052: l_shipment_rec := l_shipment_tbl(1);
2053: else
2054: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
2055: END IF;
2056: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2057: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Line Level...', 1, 'Y');
2058: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:These values will be defaulted from header for pricing qualification only:',1,'Y');

Line 2653: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

2649: P_Api_Version_Number IN NUMBER,
2650: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2651: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2652: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2653: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2654: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2655: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2656: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2657: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

2651: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2652: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2653: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2654: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2655: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2656: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2657: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2658: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2659: IS

Line 2666: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

2662: l_price_index NUMBER;
2663: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2664: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
2665: x_pass_line VARCHAR2(10);
2666: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2667: l_qte_line_id NUMBER;
2668: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2669: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2670: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 2668: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

2664: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
2665: x_pass_line VARCHAR2(10);
2666: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2667: l_qte_line_id NUMBER;
2668: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2669: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2670: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2671: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2672: lx_index_counter Number;

Line 2669: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2665: x_pass_line VARCHAR2(10);
2666: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2667: l_qte_line_id NUMBER;
2668: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2669: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2670: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2671: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2672: lx_index_counter Number;
2673: l_index_counter Number;

Line 2670: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

2666: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2667: l_qte_line_id NUMBER;
2668: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2669: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2670: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2671: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2672: lx_index_counter Number;
2673: l_index_counter Number;
2674: l_return_status_text VARCHAR2(2000);

Line 2671: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

2667: l_qte_line_id NUMBER;
2668: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2669: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2670: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2671: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2672: lx_index_counter Number;
2673: l_index_counter Number;
2674: l_return_status_text VARCHAR2(2000);
2675: l_message_text VARCHAR2(2000);

Line 2834: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

2830: END IF;
2831: IF l_qte_line_dtl_tbl.count = 1 THEN
2832: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
2833: ELSE
2834: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
2835: END IF;
2836:
2837: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2838: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');

Line 2849: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

2845: END IF;
2846: IF l_shipment_tbl.count = 1 THEN
2847: l_shipment_rec := l_shipment_tbl(1);
2848: else
2849: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
2850: END IF;
2851:
2852:
2853: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN