APPS.ASO_CFG_INT dependencies on ASO_QUOTE_PUB

Line 53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,

49: PROCEDURE Get_configuration_lines(
50: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
55: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
56: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,

50: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
55: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
56: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
58: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) ;

Line 55: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,

51: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52: p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
55: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
56: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
58: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) ;
59:

Line 104: p_control_rec IN aso_quote_pub.control_rec_type

100: PROCEDURE get_config_details(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
108: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

Line 105: := aso_quote_pub.G_MISS_control_rec,

101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
108: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
109: p_config_hdr_id IN NUMBER ,

Line 106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,

102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
108: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
109: p_config_hdr_id IN NUMBER ,
110: p_config_rev_nbr IN NUMBER,

Line 107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
108: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
109: p_config_hdr_id IN NUMBER ,
110: p_config_rev_nbr IN NUMBER,
111: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 108: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

104: p_control_rec IN aso_quote_pub.control_rec_type
105: := aso_quote_pub.G_MISS_control_rec,
106: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
108: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
109: p_config_hdr_id IN NUMBER ,
110: p_config_rev_nbr IN NUMBER,
111: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 124: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

120:
121: FUNCTION Query_Qte_Line_Rows (
122: P_Qte_Header_Id IN NUMBER ,
123: P_Qte_Line_Id IN NUMBER
124: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
125:
126:
127: PROCEDURE Create_hdr_xml
128: ( p_model_line_id IN NUMBER,

Line 134: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

130: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
131:
132:
133: PROCEDURE Send_input_xml
134: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
135: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
136: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
137: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
138: P_xml_hdr IN VARCHAR2,

Line 135: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

131:
132:
133: PROCEDURE Send_input_xml
134: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
135: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
136: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
137: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
138: P_xml_hdr IN VARCHAR2,
139: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,

Line 136: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

132:
133: PROCEDURE Send_input_xml
134: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
135: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
136: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
137: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
138: P_xml_hdr IN VARCHAR2,
139: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
140: X_config_changed OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- CZ ER

Line 137: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

133: PROCEDURE Send_input_xml
134: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
135: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
136: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
137: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
138: P_xml_hdr IN VARCHAR2,
139: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
140: X_config_changed OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- CZ ER
141: X_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 163: p_control_rec IN aso_quote_pub.control_rec_type

159: PROCEDURE Validate_Configuration
160: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

Line 164: := aso_quote_pub.G_MISS_control_rec,

160: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
168: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

162: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
168: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
169: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
170: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

163: p_control_rec IN aso_quote_pub.control_rec_type
164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
168: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
169: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
170: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
171: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 168: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

164: := aso_quote_pub.G_MISS_control_rec,
165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
168: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
169: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
170: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
171: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
172: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 169: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

165: P_model_line_id IN NUMBER,
166: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
168: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
169: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
170: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
171: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
172: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
173: X_complete_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,