DBA Data[Home] [Help]

APPS.ASO_QUOTE_TMPL_PVT dependencies on ASO_QUOTE_PUB

Line 15: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

11: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
12: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
14: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
15: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
16: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
17: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
18: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
19: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 16: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,

12: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
14: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
15: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
16: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
17: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
18: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
19: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 17: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

13: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
14: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
15: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
16: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
17: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
18: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
19: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 18: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

14: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
15: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
16: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
17: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
18: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
19: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22: );

Line 27: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

23:
24:
25: -- ER 9433340
26: FUNCTION Validate_Item(
27: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
28: p_quote_line_id IN NUMBER,
29: p_inventory_item_id IN NUMBER,
30: p_quantity IN NUMBER,
31: p_uom_code IN VARCHAR2