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.12010000.5 2010/04/30 05:21:32 rassharm 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.12010000.5 2010/04/30 05:21:32 rassharm 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: /* Code change for Quoting Usability Sun ER Start */

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: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,

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: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
26: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,

Line 154: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

150: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
151: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
152: P_Qte_Header_Id IN NUMBER,
153: P_Qte_Line_Id IN NUMBER := NULL,
154: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
155: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
156: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
157: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
158: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 168: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;

164:
165: l_api_version NUMBER := 1.0;
166: l_api_name VARCHAR2(50) := 'Copy_Line';
167: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
168: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
169:
170: -- ER 3177722
171: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
172: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');

Line 363: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

359: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
361: P_Qte_Header_Id IN NUMBER,
362: P_Qte_Line_Id IN NUMBER := NULL,
363: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
364: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
365: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
366: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
367: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 381: ASO_COPY_QUOTE_PUB.Copy_Line(

377: from aso_quote_lines_all
378: where quote_line_id = l_line_id;
379: BEGIN
380:
381: ASO_COPY_QUOTE_PUB.Copy_Line(
382: P_Api_Version_Number => P_Api_Version_Number,
383: P_Init_Msg_List => P_Init_Msg_List,
384: P_Commit => P_Commit,
385: P_Qte_Header_Id => P_Qte_Header_Id,

Line 406: End ASO_COPY_QUOTE_PUB;

402: END IF;
403:
404: END Copy_Line;
405:
406: End ASO_COPY_QUOTE_PUB;