DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PUB dependencies on ASO_COPY_QUOTE_PUB

Line 1: PACKAGE BODY ASO_COPY_QUOTE_PUB as

1: PACKAGE BODY ASO_COPY_QUOTE_PUB as
2: /* $Header: asopcpyb.pls 120.1 2005/06/29 12:36:39 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_COPY_QUOTE_PUB
5: -- Purpose :

Line 4: -- Package name : ASO_COPY_QUOTE_PUB

1: PACKAGE BODY ASO_COPY_QUOTE_PUB as
2: /* $Header: asopcpyb.pls 120.1 2005/06/29 12:36:39 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_COPY_QUOTE_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_Copy_Quote_PUB';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_Copy_Quote_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asopcpyb.pls';
13:
14:
15: PROCEDURE Copy_Quote(

Line 19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type

15: PROCEDURE Copy_Quote(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,

16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type

17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
25: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,

18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
25: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
26: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 142: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: P_Qte_Header_Id IN NUMBER,
141: P_Qte_Line_Id IN NUMBER := NULL,
142: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
143: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
144: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
145: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
146: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 156: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;

152:
153: l_api_version NUMBER := 1.0;
154: l_api_name VARCHAR2(50) := 'Copy_Line';
155: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
156: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
157:
158: BEGIN
159:
160: -- Standard Start of API savepoint

Line 298: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Id IN NUMBER,
297: P_Qte_Line_Id IN NUMBER := NULL,
298: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
299: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
300: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
301: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
302: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 316: ASO_COPY_QUOTE_PUB.Copy_Line(

312: from aso_quote_lines_all
313: where quote_line_id = l_line_id;
314: BEGIN
315:
316: ASO_COPY_QUOTE_PUB.Copy_Line(
317: P_Api_Version_Number => P_Api_Version_Number,
318: P_Init_Msg_List => P_Init_Msg_List,
319: P_Commit => P_Commit,
320: P_Qte_Header_Id => P_Qte_Header_Id,

Line 341: End ASO_COPY_QUOTE_PUB;

337: END IF;
338:
339: END Copy_Line;
340:
341: End ASO_COPY_QUOTE_PUB;