eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on IBE_QUOTE_SAVESHARE_PVT

Line 105: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

101: P_party_id IN Number ,
102: P_cust_account_id IN Number ,
103: P_retrieval_number IN Number ,
104: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
105: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
106: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
107: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
108: P_source_last_update_date IN Date := FND_API.G_MISS_DATE ,
109: p_minisite_id IN NUMBER ,

Line 106: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,

102: P_cust_account_id IN Number ,
103: P_retrieval_number IN Number ,
104: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
105: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
106: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
107: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
108: P_source_last_update_date IN Date := FND_API.G_MISS_DATE ,
109: p_minisite_id IN NUMBER ,
110: p_URL IN VARCHAR2 ,

Line 467: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE

463: -"Remove" button on the "List of Saved Carts" page for recipients.
464: -Possibly other api's to do single removes, adds, or updates. */
465:
466: Procedure save_recipients (
467: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
468: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
469: P_Quote_header_id IN Number ,
470: P_Party_id IN Number := FND_API.G_MISS_NUM ,
471: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

Line 468: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,

464: -Possibly other api's to do single removes, adds, or updates. */
465:
466: Procedure save_recipients (
467: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
468: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
469: P_Quote_header_id IN Number ,
470: P_Party_id IN Number := FND_API.G_MISS_NUM ,
471: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
472: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,

Line 540: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_rec_TYPE;

536: l_contact_point_id NUMBER;
537: l_api_name CONSTANT VARCHAR2(30) := 'SAVERECIPIENTS_V2';
538: l_api_version CONSTANT NUMBER := 1.0;
539: l_call_save_contact_point VARCHAR2(1) := FND_API.G_FALSE;
540: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_rec_TYPE;
541: l_quote_access_rec_owr IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_rec_TYPE;
542: l_call_insert_handler VARCHAR2(1) := FND_API.G_FALSE;
543: l_recip_party_id NUMBER;
544: l_recip_cust_account_id NUMBER;

Line 541: l_quote_access_rec_owr IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_rec_TYPE;

537: l_api_name CONSTANT VARCHAR2(30) := 'SAVERECIPIENTS_V2';
538: l_api_version CONSTANT NUMBER := 1.0;
539: l_call_save_contact_point VARCHAR2(1) := FND_API.G_FALSE;
540: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_rec_TYPE;
541: l_quote_access_rec_owr IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_rec_TYPE;
542: l_call_insert_handler VARCHAR2(1) := FND_API.G_FALSE;
543: l_recip_party_id NUMBER;
544: l_recip_cust_account_id NUMBER;
545: l_sharing_partyid NUMBER;

Line 715: IBE_QUOTE_SAVESHARE_pvt.GenerateShareeNumber(

711: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
712: IBE_UTIL.DEBUG('sharee id from the sequence is '||l_quote_recip_id );
713: END IF;
714:
715: IBE_QUOTE_SAVESHARE_pvt.GenerateShareeNumber(
716: p_quote_header_id => p_quote_header_id,
717: p_recip_id => l_quote_recip_id,
718: x_sharee_number => l_quote_access_rec.quote_sharee_number);
719:

Line 1643: l_party_cust_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

1639: where quote_header_id = c_qte_hdr_id
1640: and nvl(end_date_active, sysdate+1) > sysdate ;
1641:
1642: rec_select_recip c_select_recip%rowtype;
1643: l_party_cust_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1644: := IBE_QUOTE_SAVESHARE_pvt.g_miss_QUOTE_ACCESS_Tbl;
1645: counter NUMBER := 1;
1646:
1647: BEGIN

Line 1644: := IBE_QUOTE_SAVESHARE_pvt.g_miss_QUOTE_ACCESS_Tbl;

1640: and nvl(end_date_active, sysdate+1) > sysdate ;
1641:
1642: rec_select_recip c_select_recip%rowtype;
1643: l_party_cust_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1644: := IBE_QUOTE_SAVESHARE_pvt.g_miss_QUOTE_ACCESS_Tbl;
1645: counter NUMBER := 1;
1646:
1647: BEGIN
1648:

Line 1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');

1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');
1836: END IF;
1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');
1838:
1839: IBE_QUOTE_SAVESHARE_pvt.COPY_LINES(

Line 1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');

1833:
1834: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');
1836: END IF;
1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');
1838:
1839: IBE_QUOTE_SAVESHARE_pvt.COPY_LINES(
1840: p_api_version_number => p_api_version ,
1841: p_init_msg_list => FND_API.G_FALSE ,

Line 1839: IBE_QUOTE_SAVESHARE_pvt.COPY_LINES(

1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');
1836: END IF;
1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');
1838:
1839: IBE_QUOTE_SAVESHARE_pvt.COPY_LINES(
1840: p_api_version_number => p_api_version ,
1841: p_init_msg_list => FND_API.G_FALSE ,
1842: p_commit => FND_API.G_FALSE ,
1843:

Line 1872: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:IBE_QUOTE_SAVESHARE_pvt.Copy_lines End');

1868: --p_to_hd_shipment_rec?? $$
1869: -- l_hd_shipment_tbl(1).quote_header_id := P_target_header_rec.quote_header_id;
1870:
1871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1872: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:IBE_QUOTE_SAVESHARE_pvt.Copy_lines End');
1873: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart');
1874: END IF;
1875: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart ');
1876: --DBMS_OUTPUT.PUT_LINE('before save p_target_header_rec.quote_header_id '||p_target_header_rec.quote_header_id);

Line 1984: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

1980: p_quote_header_id IN Number ,
1981: p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
1982: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
1983: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
1984: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1985: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
1986: p_api_version IN NUMBER := 1 ,
1987: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1988: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 1985: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,

1981: p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
1982: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
1983: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
1984: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1985: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
1986: p_api_version IN NUMBER := 1 ,
1987: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1988: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1989: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1997: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

1993: l_api_name CONSTANT VARCHAR2(30) := 'STOPSHARING_V2';
1994: l_api_version CONSTANT NUMBER := 1.0;
1995: tbl_counter NUMBER := 1;
1996:
1997: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1998: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
1999: l_quote_access_tbl_tmp IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2000: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2001: l_owner_party_id NUMBER;

Line 1998: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;

1994: l_api_version CONSTANT NUMBER := 1.0;
1995: tbl_counter NUMBER := 1;
1996:
1997: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1998: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
1999: l_quote_access_tbl_tmp IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2000: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2001: l_owner_party_id NUMBER;
2002: l_owner_cust_account_id NUMBER;

Line 1999: l_quote_access_tbl_tmp IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

1995: tbl_counter NUMBER := 1;
1996:
1997: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1998: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
1999: l_quote_access_tbl_tmp IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2000: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2001: l_owner_party_id NUMBER;
2002: l_owner_cust_account_id NUMBER;
2003: l_sharing_party_id NUMBER;

Line 2000: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;

1996:
1997: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
1998: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
1999: l_quote_access_tbl_tmp IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2000: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2001: l_owner_party_id NUMBER;
2002: l_owner_cust_account_id NUMBER;
2003: l_sharing_party_id NUMBER;
2004:

Line 2279: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2275: *Usages:
2276: -"End Working" button
2277: */
2278: Procedure end_working (
2279: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2280: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
2281: P_Quote_header_id IN Number ,
2282: P_Party_id IN Number := FND_API.G_MISS_NUM ,
2283: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

Line 2280: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,

2276: -"End Working" button
2277: */
2278: Procedure end_working (
2279: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2280: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
2281: P_Quote_header_id IN Number ,
2282: P_Party_id IN Number := FND_API.G_MISS_NUM ,
2283: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
2284: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,

Line 2299: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2295: l_api_name CONSTANT VARCHAR2(30) := 'ENDWORKING_V2';
2296: l_api_version CONSTANT NUMBER := 1.0;
2297: l_recip_id NUMBER;
2298: l_initiator_id NUMBER;
2299: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2300: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl;
2301: END_WORKING NUMBER := 4;
2302:
2303: CURSOR c_get_recip_id(c_retrieval_num NUMBER,

Line 2300: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl;

2296: l_api_version CONSTANT NUMBER := 1.0;
2297: l_recip_id NUMBER;
2298: l_initiator_id NUMBER;
2299: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2300: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl;
2301: END_WORKING NUMBER := 4;
2302:
2303: CURSOR c_get_recip_id(c_retrieval_num NUMBER,
2304: c_party_id NUMBER,

Line 2315: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE

2311: AND quote_header_id = c_quote_header_id
2312: AND nvl(end_date_active, sysdate+1) > sysdate;
2313:
2314: rec_get_recip_id c_get_recip_id%rowtype;
2315: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2316: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2317: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2318: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2319:

Line 2316: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;

2312: AND nvl(end_date_active, sysdate+1) > sysdate;
2313:
2314: rec_get_recip_id c_get_recip_id%rowtype;
2315: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2316: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2317: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2318: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2319:
2320: cursor c_get_recipient_party(c_recipient_id NUMBER) is

Line 2317: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE

2313:
2314: rec_get_recip_id c_get_recip_id%rowtype;
2315: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2316: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2317: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2318: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2319:
2320: cursor c_get_recipient_party(c_recipient_id NUMBER) is
2321: SELECT party_id,

Line 2318: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;

2314: rec_get_recip_id c_get_recip_id%rowtype;
2315: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2316: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2317: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2318: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2319:
2320: cursor c_get_recipient_party(c_recipient_id NUMBER) is
2321: SELECT party_id,
2322: quote_sharee_number,

Line 2511: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2507: l_api_version CONSTANT NUMBER := 1.0;
2508: tbl_counter NUMBER := 1;
2509: l_initiator_id NUMBER;
2510:
2511: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2512: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2513:
2514: cursor c_get_recipients(c_qte_hdr_id NUMBER) is
2515: select quote_sharee_id,

Line 2512: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;

2508: tbl_counter NUMBER := 1;
2509: l_initiator_id NUMBER;
2510:
2511: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2512: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2513:
2514: cursor c_get_recipients(c_qte_hdr_id NUMBER) is
2515: select quote_sharee_id,
2516: party_id,

Line 2649: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE

2645: -All deletes for a recipient should be done using this api.
2646: -As of IBE.P - p_quote_access_rec must have the shared_by_party_id set
2647: */
2648: Procedure DELETE_RECIPIENT (
2649: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2650: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC ,
2651: P_minisite_id IN NUMBER ,
2652: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
2653: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 2650: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC ,

2646: -As of IBE.P - p_quote_access_rec must have the shared_by_party_id set
2647: */
2648: Procedure DELETE_RECIPIENT (
2649: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2650: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC ,
2651: P_minisite_id IN NUMBER ,
2652: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
2653: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2654: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 2901: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2897: PROCEDURE Validate_share_Update(
2898: p_api_version_number IN NUMBER := 1.0
2899: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2900: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2901: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2902: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
2903: -- partyid and accountid cannot be gmiss coming in
2904: ,p_party_id IN NUMBER
2905: ,p_cust_account_id IN NUMBER

Line 2902: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl

2898: p_api_version_number IN NUMBER := 1.0
2899: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2900: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2901: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2902: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
2903: -- partyid and accountid cannot be gmiss coming in
2904: ,p_party_id IN NUMBER
2905: ,p_cust_account_id IN NUMBER
2906: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

Line 2926: l_db_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type;

2922: l_access_level VARCHAR2(30) := null;
2923: l_db_last_update_date DATE;
2924: l_db_end_date_active DATE;
2925: l_db_access_level VARCHAR2(30) := null;
2926: l_db_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type;
2927: l_env_user_id NUMBER;
2928:
2929: cursor c_get_owner_partyid(c_quote_id number) is
2930: select party_id