17:
18:
19: PROCEDURE Copy_Quote(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
24: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
25: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
18:
19: PROCEDURE Copy_Quote(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
24: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
25: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
26: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
32:
33:
34: PROCEDURE Copy_Header_Rows(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
39: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
40: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
33:
34: PROCEDURE Copy_Header_Rows(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
39: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
40: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
44: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
45:
46: PROCEDURE Copy_Line_Rows(
47: P_Api_Version_Number IN NUMBER,
48: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
49: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
50: P_Qte_Header_Id IN NUMBER,
51: P_New_Qte_Header_Id IN NUMBER,
52: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
45:
46: PROCEDURE Copy_Line_Rows(
47: P_Api_Version_Number IN NUMBER,
48: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
49: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
50: P_Qte_Header_Id IN NUMBER,
51: P_New_Qte_Header_Id IN NUMBER,
52: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
53: P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
48: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
49: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
50: P_Qte_Header_Id IN NUMBER,
51: P_New_Qte_Header_Id IN NUMBER,
52: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
53: P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
54: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
55: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
56: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
74: lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
75: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
76: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
77: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
78: p_line_quantity IN NUMBER := FND_API.G_MISS_NUM );
79:
80: PROCEDURE service_copy(
81: p_qte_line_id IN NUMBER,
82: p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
87: lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
88: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
89: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
90: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
91: p_line_quantity IN NUMBER := FND_API.G_MISS_NUM);
92:
93: PROCEDURE Get_Quote_Exp_Date(
94: X_Quote_Exp_Date OUT NOCOPY /* file.sql.39 change */ DATE,
95: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
98:
99: PROCEDURE COPY_SALES_SUPPLEMENT
100: (
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_old_quote_header_id IN NUMBER,
105: p_new_quote_header_id IN NUMBER,
106: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
99: PROCEDURE COPY_SALES_SUPPLEMENT
100: (
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_old_quote_header_id IN NUMBER,
105: p_new_quote_header_id IN NUMBER,
106: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
118:
119:
120: PROCEDURE Split_Model_Line (
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
125: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
126: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
119:
120: PROCEDURE Split_Model_Line (
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
125: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
126: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
127: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
134: -- added for sales supp enhancements as per bug 2940126
135: PROCEDURE INSERT_SALES_SUPP_DATA
136: (
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: P_OLD_QUOTE_LINE_ID IN NUMBER,
141: P_NEW_QUOTE_LINE_ID IN NUMBER,
142: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
135: PROCEDURE INSERT_SALES_SUPP_DATA
136: (
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: P_OLD_QUOTE_LINE_ID IN NUMBER,
141: P_NEW_QUOTE_LINE_ID IN NUMBER,
142: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
143: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,