14: P_Api_Version_Number IN NUMBER,
15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: )
24: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: )
26: IS
27:
28: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
29: l_qte_line_rec aso_quote_pub.qte_line_rec_type := aso_quote_pub.g_miss_qte_line_rec;
30: l_control_rec aso_quote_pub.control_rec_type := aso_quote_pub.g_miss_control_rec;
31:
32: cursor c_qte_header_id is
25: )
26: IS
27:
28: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
29: l_qte_line_rec aso_quote_pub.qte_line_rec_type := aso_quote_pub.g_miss_qte_line_rec;
30: l_control_rec aso_quote_pub.control_rec_type := aso_quote_pub.g_miss_control_rec;
31:
32: cursor c_qte_header_id is
33: select quote_header_id
26: IS
27:
28: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
29: l_qte_line_rec aso_quote_pub.qte_line_rec_type := aso_quote_pub.g_miss_qte_line_rec;
30: l_control_rec aso_quote_pub.control_rec_type := aso_quote_pub.g_miss_control_rec;
31:
32: cursor c_qte_header_id is
33: select quote_header_id
34: from aso_quote_lines_all
96: PROCEDURE split_quote_line(
97: p_api_version_number IN number,
98: p_init_msg_list IN varchar2 := fnd_api.g_false,
99: p_commit IN varchar2 := fnd_api.g_false,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
97: p_api_version_number IN number,
98: p_init_msg_list IN varchar2 := fnd_api.g_false,
99: p_commit IN varchar2 := fnd_api.g_false,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
98: p_init_msg_list IN varchar2 := fnd_api.g_false,
99: p_commit IN varchar2 := fnd_api.g_false,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
99: p_commit IN varchar2 := fnd_api.g_false,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
107: := aso_quote_pub.g_miss_shipment_tbl,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
107: := aso_quote_pub.g_miss_shipment_tbl,
108: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
107: := aso_quote_pub.g_miss_shipment_tbl,
108: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
109: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
107: := aso_quote_pub.g_miss_shipment_tbl,
108: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
109: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
110: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
103: := aso_quote_pub.g_miss_qte_header_rec,
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
107: := aso_quote_pub.g_miss_shipment_tbl,
108: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
109: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
110: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
111: x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2
104: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
105: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
106: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
107: := aso_quote_pub.g_miss_shipment_tbl,
108: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
109: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
110: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
111: x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2
112: )
121: l_quote_header_id NUMBER;
122: l_call_lock_exist VARCHAR2(1) := FND_API.G_FALSE;
123: l_x_status VARCHAR2(1);
124:
125: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
126: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
127:
128: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
129:
122: l_call_lock_exist VARCHAR2(1) := FND_API.G_FALSE;
123: l_x_status VARCHAR2(1);
124:
125: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
126: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
127:
128: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
129:
130: l_split_model_line VARCHAR2(1) := FND_API.G_FALSE;
124:
125: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
126: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
127:
128: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
129:
130: l_split_model_line VARCHAR2(1) := FND_API.G_FALSE;
131:
132: Cursor c_config_exist is
579: End Split_Quote_line;
580:
581:
582: PROCEDURE Do_Split_line (
583: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
584: p_control_rec IN aso_quote_pub.control_rec_type,
585: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
580:
581:
582: PROCEDURE Do_Split_line (
583: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
584: p_control_rec IN aso_quote_pub.control_rec_type,
585: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
588: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
581:
582: PROCEDURE Do_Split_line (
583: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
584: p_control_rec IN aso_quote_pub.control_rec_type,
585: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
588: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
589: p_commit IN VARCHAR2,
583: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
584: p_control_rec IN aso_quote_pub.control_rec_type,
585: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
588: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
589: p_commit IN VARCHAR2,
590: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
591: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
584: p_control_rec IN aso_quote_pub.control_rec_type,
585: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
588: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
589: p_commit IN VARCHAR2,
590: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
591: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
592: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
588: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
589: p_commit IN VARCHAR2,
590: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
591: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
592: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
593: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
594: )
599: where service_ref_line_id = p_service_ref_line_id
600: and service_ref_type_code = 'QUOTE';
601:
602:
603: --l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
604: --l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
605: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := p_original_qte_line_rec;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
600: and service_ref_type_code = 'QUOTE';
601:
602:
603: --l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
604: --l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
605: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := p_original_qte_line_rec;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
601:
602:
603: --l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
604: --l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
605: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := p_original_qte_line_rec;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
602:
603: --l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
604: --l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
605: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := p_original_qte_line_rec;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
603: --l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
604: --l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
605: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := p_original_qte_line_rec;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
604: --l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
605: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := p_original_qte_line_rec;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
606: l_srv_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
607: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
608: l_map_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
609:
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
610: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
611: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
612: l_srv_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
613: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
614: l_srv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
615: l_qte_line_dtl_rec ASO_QUOTE_PUB.qte_line_dtl_rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_REC;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
616: l_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
617: l_srv_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
618: l_payment_rec ASO_QUOTE_PUB.payment_rec_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_REC;
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
619: l_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
620: l_srv_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
621: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_REC;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
622: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
623: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
624: l_srv_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
625: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
626: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type
627: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
628: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
635:
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
629: l_srv_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
635:
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
630: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_REC;
631:
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
635:
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
632: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
635:
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
633: l_srv_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
635:
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
634: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC;
635:
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
636: l_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
637: l_srv_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
638: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_REC;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
639:
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
640: l_to_create_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type := ASO_QUOTE_PUB.G_MISS_SALES_CREDIT_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
641: l_to_create_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
642: l_to_create_quote_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
650: l_create_price_adj_rltn_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
643: l_to_create_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
650: l_create_price_adj_rltn_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
651: l_create_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
644: l_to_create_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
650: l_create_price_adj_rltn_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
651: l_create_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
652:
645: l_to_create_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
650: l_create_price_adj_rltn_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
651: l_create_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
652:
653: l_search_index search_tbl_type;
646: l_to_create_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
650: l_create_price_adj_rltn_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
651: l_create_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
652:
653: l_search_index search_tbl_type;
654:
647: l_to_create_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
648: := ASO_QUOTE_PUB.G_MISS_PRICE_ATTRIBUTES_TBL;
649: l_to_create_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_TBL;
650: l_create_price_adj_rltn_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_TBL;
651: l_create_price_adj_attr_tbl ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_TBL;
652:
653: l_search_index search_tbl_type;
654:
655: l_ln_quantity_before_spilt NUMBER;
654:
655: l_ln_quantity_before_spilt NUMBER;
656:
657: -- Output parameters
658: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
659: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
655: l_ln_quantity_before_spilt NUMBER;
656:
657: -- Output parameters
658: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
659: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
656:
657: -- Output parameters
658: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
659: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
657: -- Output parameters
658: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
659: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
658: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
659: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
659: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
660: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
661: lx_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_tbl_Type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
662: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
663: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
664: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
665: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
666: lx_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
667: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
668: lx_price_adjustment_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
669: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
670: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_rltship_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
671: lx_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
679: lx_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
672: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
679: lx_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
680: lx_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
673: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
679: lx_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
680: lx_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
681:
674: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
679: lx_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
680: lx_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
681:
682: l_srv_line_index NUMBER := P_Qte_Line_Tbl.count + 1;
675: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_type;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
679: lx_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
680: lx_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
681:
682: l_srv_line_index NUMBER := P_Qte_Line_Tbl.count + 1;
683: l_line_count NUMBER := P_Qte_Line_Tbl.count + 1;
676: lx_ln_sales_credit_tbl ASO_QUOTE_PUB.sales_credit_tbl_Type;
677: lx_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
678: lx_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
679: lx_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
680: lx_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
681:
682: l_srv_line_index NUMBER := P_Qte_Line_Tbl.count + 1;
683: l_line_count NUMBER := P_Qte_Line_Tbl.count + 1;
684: l_api_name CONSTANT VARCHAR2(30) := 'Do_Split_line';
683: l_line_count NUMBER := P_Qte_Line_Tbl.count + 1;
684: l_api_name CONSTANT VARCHAR2(30) := 'Do_Split_line';
685:
686: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
687: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
688: l_orig_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
689: l_orig_line_deleted varchar2(1) := 'N';
690:
691: Begin
684: l_api_name CONSTANT VARCHAR2(30) := 'Do_Split_line';
685:
686: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
687: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
688: l_orig_payment_tbl ASO_QUOTE_PUB.payment_tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
689: l_orig_line_deleted varchar2(1) := 'N';
690:
691: Begin
692:
1314: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1315: aso_debug_pub.add('Do_Split_Line: Before call to Update Quote', 1, 'Y');
1316: END IF;
1317:
1318: ASO_QUOTE_PUB.Update_quote(
1319: P_Api_Version_Number => 1.0,
1320: P_Init_Msg_List => FND_API.G_FALSE,
1321: P_Commit => P_Commit,
1322: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
1321: P_Commit => P_Commit,
1322: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
1323: P_Control_Rec => l_control_rec,
1324: P_Qte_Header_Rec => p_qte_header_rec,
1325: P_hd_Price_Attributes_Tbl => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
1326: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1322: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
1323: P_Control_Rec => l_control_rec,
1324: P_Qte_Header_Rec => p_qte_header_rec,
1325: P_hd_Price_Attributes_Tbl => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
1326: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1323: P_Control_Rec => l_control_rec,
1324: P_Qte_Header_Rec => p_qte_header_rec,
1325: P_hd_Price_Attributes_Tbl => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
1326: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1324: P_Qte_Header_Rec => p_qte_header_rec,
1325: P_hd_Price_Attributes_Tbl => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
1326: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1325: P_hd_Price_Attributes_Tbl => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
1326: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1333: P_Qte_Line_Tbl => l_to_create_quote_line_tbl,
1326: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1333: P_Qte_Line_Tbl => l_to_create_quote_line_tbl,
1334: P_Qte_Line_Dtl_Tbl => l_to_create_qte_line_dtl_tbl,
1327: P_hd_Shipment_Tbl => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1333: P_Qte_Line_Tbl => l_to_create_quote_line_tbl,
1334: P_Qte_Line_Dtl_Tbl => l_to_create_qte_line_dtl_tbl,
1335: P_Line_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1328: P_hd_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1329: P_hd_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1330: P_hd_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1333: P_Qte_Line_Tbl => l_to_create_quote_line_tbl,
1334: P_Qte_Line_Dtl_Tbl => l_to_create_qte_line_dtl_tbl,
1335: P_Line_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1336: P_line_rltship_tbl => ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
1331: P_hd_Sales_Credit_Tbl => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1333: P_Qte_Line_Tbl => l_to_create_quote_line_tbl,
1334: P_Qte_Line_Dtl_Tbl => l_to_create_qte_line_dtl_tbl,
1335: P_Line_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1336: P_line_rltship_tbl => ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
1337: P_Price_Adjustment_Tbl => l_to_create_price_adj_tbl,
1338: P_Price_Adj_Attr_Tbl => l_create_price_adj_attr_tbl,
1339: P_Price_Adj_Rltship_Tbl => l_create_price_adj_rltn_tbl,
1332: P_hd_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1333: P_Qte_Line_Tbl => l_to_create_quote_line_tbl,
1334: P_Qte_Line_Dtl_Tbl => l_to_create_qte_line_dtl_tbl,
1335: P_Line_Attr_Ext_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1336: P_line_rltship_tbl => ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
1337: P_Price_Adjustment_Tbl => l_to_create_price_adj_tbl,
1338: P_Price_Adj_Attr_Tbl => l_create_price_adj_attr_tbl,
1339: P_Price_Adj_Rltship_Tbl => l_create_price_adj_rltn_tbl,
1340: P_Ln_Price_Attributes_Tbl => l_to_create_price_attr_tbl,
1337: P_Price_Adjustment_Tbl => l_to_create_price_adj_tbl,
1338: P_Price_Adj_Attr_Tbl => l_create_price_adj_attr_tbl,
1339: P_Price_Adj_Rltship_Tbl => l_create_price_adj_rltn_tbl,
1340: P_Ln_Price_Attributes_Tbl => l_to_create_price_attr_tbl,
1341: P_Ln_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1342: P_Ln_Shipment_Tbl => l_to_create_shipment_tbl,
1343: P_Ln_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1344: P_Ln_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1345: P_ln_Sales_Credit_Tbl => l_to_create_sales_credit_tbl,
1339: P_Price_Adj_Rltship_Tbl => l_create_price_adj_rltn_tbl,
1340: P_Ln_Price_Attributes_Tbl => l_to_create_price_attr_tbl,
1341: P_Ln_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1342: P_Ln_Shipment_Tbl => l_to_create_shipment_tbl,
1343: P_Ln_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1344: P_Ln_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1345: P_ln_Sales_Credit_Tbl => l_to_create_sales_credit_tbl,
1346: P_ln_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1347: x_Qte_Header_Rec => lx_qte_header_rec,
1340: P_Ln_Price_Attributes_Tbl => l_to_create_price_attr_tbl,
1341: P_Ln_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
1342: P_Ln_Shipment_Tbl => l_to_create_shipment_tbl,
1343: P_Ln_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1344: P_Ln_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1345: P_ln_Sales_Credit_Tbl => l_to_create_sales_credit_tbl,
1346: P_ln_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1347: x_Qte_Header_Rec => lx_qte_header_rec,
1348: X_Qte_Line_Tbl => lx_Qte_Line_Tbl,
1342: P_Ln_Shipment_Tbl => l_to_create_shipment_tbl,
1343: P_Ln_Freight_Charge_Tbl => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
1344: P_Ln_Tax_Detail_Tbl => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
1345: P_ln_Sales_Credit_Tbl => l_to_create_sales_credit_tbl,
1346: P_ln_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1347: x_Qte_Header_Rec => lx_qte_header_rec,
1348: X_Qte_Line_Tbl => lx_Qte_Line_Tbl,
1349: X_Qte_Line_Dtl_Tbl => lx_Qte_Line_Dtl_Tbl,
1350: X_Hd_Price_Attributes_Tbl => lx_hd_price_attr_tbl,