21:
22:
23: TYPE Copy_Quote_Control_Rec_Type IS RECORD
24: (
25: Copy_Header_Only VARCHAR2(1) := FND_API.G_FALSE,
26: New_Version VARCHAR2(1) := FND_API.G_FALSE,
27: Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28: Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
22:
23: TYPE Copy_Quote_Control_Rec_Type IS RECORD
24: (
25: Copy_Header_Only VARCHAR2(1) := FND_API.G_FALSE,
26: New_Version VARCHAR2(1) := FND_API.G_FALSE,
27: Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28: Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
23: TYPE Copy_Quote_Control_Rec_Type IS RECORD
24: (
25: Copy_Header_Only VARCHAR2(1) := FND_API.G_FALSE,
26: New_Version VARCHAR2(1) := FND_API.G_FALSE,
27: Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28: Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
31: Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: (
25: Copy_Header_Only VARCHAR2(1) := FND_API.G_FALSE,
26: New_Version VARCHAR2(1) := FND_API.G_FALSE,
27: Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28: Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
31: Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: Price_Mode VARCHAR2(30) := 'ENTIRE_QUOTE',
25: Copy_Header_Only VARCHAR2(1) := FND_API.G_FALSE,
26: New_Version VARCHAR2(1) := FND_API.G_FALSE,
27: Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28: Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
31: Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: Price_Mode VARCHAR2(30) := 'ENTIRE_QUOTE',
33: Calculate_Freight_Charge_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28: Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
31: Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: Price_Mode VARCHAR2(30) := 'ENTIRE_QUOTE',
33: Calculate_Freight_Charge_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
34: Calculate_Tax_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: );
29: Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
31: Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: Price_Mode VARCHAR2(30) := 'ENTIRE_QUOTE',
33: Calculate_Freight_Charge_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
34: Calculate_Tax_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: );
36:
37: G_MISS_Copy_Quote_Control_Rec Copy_Quote_Control_Rec_Type;
30: Pricing_Request_Type VARCHAR2(30) := 'ASO',
31: Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: Price_Mode VARCHAR2(30) := 'ENTIRE_QUOTE',
33: Calculate_Freight_Charge_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
34: Calculate_Tax_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: );
36:
37: G_MISS_Copy_Quote_Control_Rec Copy_Quote_Control_Rec_Type;
38:
38:
39:
40: TYPE Copy_Quote_Header_Rec_Type IS RECORD
41: (
42: Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
43: Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
39:
40: TYPE Copy_Quote_Header_Rec_Type IS RECORD
41: (
42: Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
43: Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
40: TYPE Copy_Quote_Header_Rec_Type IS RECORD
41: (
42: Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
43: Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
41: (
42: Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
43: Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
42: Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
43: Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
43: Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
44: Quote_Number NUMBER := FND_API.G_MISS_NUM,
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
52: TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
45: Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
52: TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
53: );
46: Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
52: TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
53: );
54:
47: Resource_Id NUMBER := FND_API.G_MISS_NUM,
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
52: TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
53: );
54:
55: G_MISS_Copy_Quote_Header_Rec Copy_Quote_Header_Rec_Type;
48: Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49: PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50: TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
52: TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
53: );
54:
55: G_MISS_Copy_Quote_Header_Rec Copy_Quote_Header_Rec_Type;
56:
63: -- Pre-Req :
64: -- Parameters:
65: -- IN
66: -- p_api_version_number IN NUMBER Required
67: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
68: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
69: -- P_Copy_Quote_Header_Rec IN Copy_Quote_Header_Rec_Type Default = G_MISS_Copy_Quote_Header_Rec
70: -- P_Copy_Quote_Control_Rec IN Copy_Quote_Control_Rec_Type Default = G_MISS_Copy_Quote_Control_Rec
71: --
64: -- Parameters:
65: -- IN
66: -- p_api_version_number IN NUMBER Required
67: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
68: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
69: -- P_Copy_Quote_Header_Rec IN Copy_Quote_Header_Rec_Type Default = G_MISS_Copy_Quote_Header_Rec
70: -- P_Copy_Quote_Control_Rec IN Copy_Quote_Control_Rec_Type Default = G_MISS_Copy_Quote_Control_Rec
71: --
72: -- OUT:
82: --
83:
84: PROCEDURE Copy_Quote(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
89: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
90: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
83:
84: PROCEDURE Copy_Quote(
85: P_Api_Version_Number IN NUMBER,
86: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
89: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
90: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
91: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
98:
99:
100: PROCEDURE Copy_Line(
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_Qte_Header_Id IN NUMBER,
105: P_Qte_Line_Id IN NUMBER := NULL,
106: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
99:
100: PROCEDURE Copy_Line(
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_Qte_Header_Id IN NUMBER,
105: P_Qte_Line_Id IN NUMBER := NULL,
106: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
107: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
113:
114: -- Overloaded Copy Line created for bug 4339146
115: PROCEDURE Copy_Line(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: P_Qte_Header_Id IN NUMBER,
120: P_Qte_Line_Id IN NUMBER := NULL,
121: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
114: -- Overloaded Copy Line created for bug 4339146
115: PROCEDURE Copy_Line(
116: P_Api_Version_Number IN NUMBER,
117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119: P_Qte_Header_Id IN NUMBER,
120: P_Qte_Line_Id IN NUMBER := NULL,
121: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
122: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,