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 2300: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2296: *Usages:
2297: -"End Working" button
2298: */
2299: Procedure end_working (
2300: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2301: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
2302: P_Quote_header_id IN Number ,
2303: P_Party_id IN Number := FND_API.G_MISS_NUM ,
2304: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

Line 2301: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,

2297: -"End Working" button
2298: */
2299: Procedure end_working (
2300: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2301: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
2302: P_Quote_header_id IN Number ,
2303: P_Party_id IN Number := FND_API.G_MISS_NUM ,
2304: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
2305: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,

Line 2320: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2316: l_api_name CONSTANT VARCHAR2(30) := 'ENDWORKING_V2';
2317: l_api_version CONSTANT NUMBER := 1.0;
2318: l_recip_id NUMBER;
2319: l_initiator_id NUMBER;
2320: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2321: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl;
2322: END_WORKING NUMBER := 4;
2323:
2324: CURSOR c_get_recip_id(c_retrieval_num NUMBER,

Line 2321: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl;

2317: l_api_version CONSTANT NUMBER := 1.0;
2318: l_recip_id NUMBER;
2319: l_initiator_id NUMBER;
2320: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2321: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl;
2322: END_WORKING NUMBER := 4;
2323:
2324: CURSOR c_get_recip_id(c_retrieval_num NUMBER,
2325: c_party_id NUMBER,

Line 2336: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE

2332: AND quote_header_id = c_quote_header_id
2333: AND nvl(end_date_active, sysdate+1) > sysdate;
2334:
2335: rec_get_recip_id c_get_recip_id%rowtype;
2336: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2337: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2338: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2339: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2340:

Line 2337: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;

2333: AND nvl(end_date_active, sysdate+1) > sysdate;
2334:
2335: rec_get_recip_id c_get_recip_id%rowtype;
2336: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2337: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2338: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2339: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2340:
2341: cursor c_get_recipient_party(c_recipient_id NUMBER) is

Line 2338: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE

2334:
2335: rec_get_recip_id c_get_recip_id%rowtype;
2336: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2337: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2338: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2339: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2340:
2341: cursor c_get_recipient_party(c_recipient_id NUMBER) is
2342: SELECT party_id,

Line 2339: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;

2335: rec_get_recip_id c_get_recip_id%rowtype;
2336: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2337: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2338: l_quote_access_rec_recip IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2339: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
2340:
2341: cursor c_get_recipient_party(c_recipient_id NUMBER) is
2342: SELECT party_id,
2343: quote_sharee_number,

Line 2532: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2528: l_api_version CONSTANT NUMBER := 1.0;
2529: tbl_counter NUMBER := 1;
2530: l_initiator_id NUMBER;
2531:
2532: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2533: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2534:
2535: cursor c_get_recipients(c_qte_hdr_id NUMBER) is
2536: select quote_sharee_id,

Line 2533: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;

2529: tbl_counter NUMBER := 1;
2530: l_initiator_id NUMBER;
2531:
2532: l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2533: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
2534:
2535: cursor c_get_recipients(c_qte_hdr_id NUMBER) is
2536: select quote_sharee_id,
2537: party_id,

Line 2670: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE

2666: -All deletes for a recipient should be done using this api.
2667: -As of IBE.P - p_quote_access_rec must have the shared_by_party_id set
2668: */
2669: Procedure DELETE_RECIPIENT (
2670: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2671: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC ,
2672: P_minisite_id IN NUMBER ,
2673: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
2674: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 2671: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC ,

2667: -As of IBE.P - p_quote_access_rec must have the shared_by_party_id set
2668: */
2669: Procedure DELETE_RECIPIENT (
2670: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
2671: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC ,
2672: P_minisite_id IN NUMBER ,
2673: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
2674: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2675: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 2922: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type

2918: PROCEDURE Validate_share_Update(
2919: p_api_version_number IN NUMBER := 1.0
2920: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2921: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2922: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2923: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
2924: -- partyid and accountid cannot be gmiss coming in
2925: ,p_party_id IN NUMBER
2926: ,p_cust_account_id IN NUMBER

Line 2923: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl

2919: p_api_version_number IN NUMBER := 1.0
2920: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2921: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2922: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2923: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
2924: -- partyid and accountid cannot be gmiss coming in
2925: ,p_party_id IN NUMBER
2926: ,p_cust_account_id IN NUMBER
2927: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

Line 2947: l_db_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type;

2943: l_access_level VARCHAR2(30) := null;
2944: l_db_last_update_date DATE;
2945: l_db_end_date_active DATE;
2946: l_db_access_level VARCHAR2(30) := null;
2947: l_db_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type;
2948: l_env_user_id NUMBER;
2949:
2950: cursor c_get_owner_partyid(c_quote_id number) is
2951: select party_id