APPS.ASO_QUOTE_TMPL_INT dependencies on ASO_QUOTE_PUB

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

17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
20: P_QUOTE_HEADER_ID IN NUMBER,
21: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
22: P_LAST_UPDATE_DATE IN DATE,
23: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
24: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
25: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 29: l_QTE_HEADER_REC ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

25: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26: )
27: IS
28:
29: l_QTE_HEADER_REC ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
30:
31: Begin
32:
33: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_quote_header_id);

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

53: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
55: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
57: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
58: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
59: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
61: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

54: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
55: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
57: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
58: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
59: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
61: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: )

Line 64: x_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;

60: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
61: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: )
63: IS
64: x_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
65: x_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
66: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
67: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
68:

Line 65: x_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;

61: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: )
63: IS
64: x_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
65: x_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
66: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
67: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
68:
69: L_API_NAME VARCHAR2(50) := 'Add_Template_To_Quote';