[Home] [Help]
PACKAGE: APPS.IBE_QUOTE_W2_PVT
Source
1 PACKAGE IBE_Quote_W2_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVQW2S.pls 120.4 2010/12/13 06:11:27 scnagara ship $ */
3
4 PROCEDURE SAVE_SHARE_V2_WRAPPER
5 (
6 p_api_version_number IN NUMBER := 1 ,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9
10 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
11 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
12 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
13 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
15 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
18 p_ssc_delete_source_cart IN VARCHAR2 := FND_API.G_TRUE ,
19 p_ssc_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
20 p_ssc_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
21 p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
22
23 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
24 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
25 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
26 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
27 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
28 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
29 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
30 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
31 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
32 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
33 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
34 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
35 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
36 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
37 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
38 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
40 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
41 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
44 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
45 p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
46 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
47 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
53 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
54 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
57 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
58 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
59 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
60 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
61 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
62 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
63 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
64 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
65 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
66 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
67 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
68 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
69 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
72 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
75 -- bug 6873117 mgiridha added attribute 16-20
76 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
97 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
98 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
99 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
111 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
113 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
117 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
118 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
121 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
122 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
123 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
124 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
126 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
127 --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
128 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
130
131 p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
132 p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
133 p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
134 p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
135 p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
136 p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
137 p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
138 p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
139 p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
140 p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
141 p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
142 p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
143 p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
144 p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
145 p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
146 p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
147 p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
148 p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
149 p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
150 p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
151 p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
152 p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
153 p_qsh_email_address JTF_VARCHAR2_TABLE_2000 :=NULL,
154 p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
155 p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_party_id NUMBER := FND_API.G_MISS_NUM,
157 P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
158 P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
159 P_minisite_id NUMBER := FND_API.G_MISS_NUM,
160 P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
161 P_source_last_update_date DATE := FND_API.G_MISS_DATE,
162 p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
163 x_return_status OUT NOCOPY VARCHAR2 ,
164 x_msg_count OUT NOCOPY NUMBER ,
165 x_msg_data OUT NOCOPY VARCHAR2 ) ;
166
167
168 END IBE_Quote_W2_PVT;