60: P_party_id IN NUMBER ,
61: P_cust_account_id IN NUMBER ,
62: P_retrieval_number IN NUMBER ,
63: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
64: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
65: := ibe_quote_saveshare_pvt.G_MISS_QUOTE_ACCESS_TBL,
66: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
67: P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,
68: p_minisite_id IN NUMBER ,
61: P_cust_account_id IN NUMBER ,
62: P_retrieval_number IN NUMBER ,
63: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
64: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
65: := ibe_quote_saveshare_pvt.G_MISS_QUOTE_ACCESS_TBL,
66: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
67: P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,
68: p_minisite_id IN NUMBER ,
69: p_URL IN VARCHAR2 ,
75: x_msg_count OUT NOCOPY NUMBER ,
76: x_msg_data OUT NOCOPY VARCHAR2 );
77:
78: Procedure SAVE_RECIPIENTS (
79: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
80: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
81: P_Quote_header_id IN Number ,
82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
76: x_msg_data OUT NOCOPY VARCHAR2 );
77:
78: Procedure SAVE_RECIPIENTS (
79: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
80: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
81: P_Quote_header_id IN Number ,
82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
139: p_quote_header_id IN NUMBER ,
140: p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
141: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
142: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
143: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145: p_api_version IN NUMBER := 1 ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
140: p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
141: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
142: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
143: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145: p_api_version IN NUMBER := 1 ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148: x_return_status OUT NOCOPY VARCHAR2 ,
149: x_msg_count OUT NOCOPY NUMBER ,
150: x_msg_data OUT NOCOPY VARCHAR2 );
151:
152: Procedure END_WORKING (
153: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
154: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
155: P_Quote_header_id IN Number ,
156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
150: x_msg_data OUT NOCOPY VARCHAR2 );
151:
152: Procedure END_WORKING (
153: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
154: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
155: P_Quote_header_id IN Number ,
156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
178: x_msg_count OUT NOCOPY NUMBER ,
179: x_msg_data OUT NOCOPY VARCHAR2 );
180:
181: Procedure DELETE_RECIPIENT (
182: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
183: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC,
184: p_minisite_id IN NUMBER ,
185: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
179: x_msg_data OUT NOCOPY VARCHAR2 );
180:
181: Procedure DELETE_RECIPIENT (
182: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
183: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC,
184: p_minisite_id IN NUMBER ,
185: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
187: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
195: PROCEDURE Validate_share_Update(
196: p_api_version_number IN NUMBER := 1.0
197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
199: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
200: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
201: -- partyid and accountid cannot be gmiss coming in
202: ,p_party_id IN NUMBER
203: ,p_cust_account_id IN NUMBER
196: p_api_version_number IN NUMBER := 1.0
197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
199: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
200: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
201: -- partyid and accountid cannot be gmiss coming in
202: ,p_party_id IN NUMBER
203: ,p_cust_account_id IN NUMBER
204: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM