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_SH_QUOTE_ACCESS

Line 39: from ibe_sh_quote_access

35: p_retrieval_number NUMBER) is
36:
37: cursor c_find_party(c_retrieval_num NUMBER) is
38: select quote_sharee_id,quote_header_id,party_id, cust_account_id
39: from ibe_sh_quote_access
40: where quote_sharee_number = c_retrieval_num ;
41:
42: cursor c_get_sold_to(c_quote_header_id NUMBER) is
43: select cust_account_id, party_type

Line 75: IBE_SH_QUOTE_ACCESS_PKG.update_Row(

71: END LOOP;
72: IF(((l_party_type = 'PARTY_RELATIONSHIP')
73: and (p_cust_account_id = l_sold_to_cust))or (l_party_type = 'PERSON')) THEN
74:
75: IBE_SH_QUOTE_ACCESS_PKG.update_Row(
76: p_QUOTE_SHAREE_ID => l_recip_id
77: ,p_party_id => p_party_id
78: ,p_cust_account_id => p_cust_account_id);
79: ELSE

Line 487: from ibe_sh_quote_access

483: cursor c_check_recip_row(c_quote_hdr_id number,
484: c_party_id number,
485: c_cust_account_id number) is
486: select quote_header_id, quote_sharee_id, quote_sharee_number
487: from ibe_sh_quote_access
488: where party_id = c_party_id
489: and cust_account_id = c_cust_account_id
490: and quote_header_id = c_quote_hdr_id
491: and nvl(end_date_active, sysdate+1) > sysdate;

Line 504: from ibe_sh_quote_access ibe, fnd_user fnd

500: quote_header_id,
501: quote_sharee_number,
502: quote_sharee_id,
503: fnd.customer_id shared_by_party_id
504: from ibe_sh_quote_access ibe, fnd_user fnd
505: where ibe.created_by = fnd.user_id
506: and (quote_sharee_id = c_recip_id
507: or (quote_header_id = c_quote_header_id
508: and party_id = c_party_id));

Line 519: from ibe_sh_quote_access

515: cursor c_get_created_recip(c_quote_header_id number,
516: c_party_id number,
517: c_created_by number) is
518: select quote_sharee_id
519: from ibe_sh_quote_access
520: where party_id = c_party_id
521: and quote_header_id = c_quote_header_id
522: and created_by = c_created_by;
523:

Line 685: IBE_SH_QUOTE_ACCESS_PKG.update_Row(

681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
682: IBE_UTIL.DEBUG('Record found for the recipient in quote_access table, need to update it');
683: END IF;
684:
685: IBE_SH_QUOTE_ACCESS_PKG.update_Row(
686: p_quote_sharee_id => l_quote_access_rec.quote_sharee_id
687: ,p_quote_header_id => p_quote_header_id
688: ,p_party_id => p_quote_access_tbl(counter).party_id
689: ,p_cust_account_id => p_quote_access_tbl(counter).cust_account_id

Line 709: select IBE_SH_QUOTE_ACCESS_s1.nextval into l_quote_recip_id

705: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
706: IBE_UTIL.DEBUG('Record not found for this recipient in quote_access table');
707: END IF;
708: --Obtain the recipient number here
709: select IBE_SH_QUOTE_ACCESS_s1.nextval into l_quote_recip_id
710: from dual;
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;

Line 787: IBE_SH_QUOTE_ACCESS_PKG.Insert_Row(

783: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
784: IBE_UTIL.DEBUG('calling ins handler ');
785: IBE_UTIL.DEBUG('p_quote_access_tbl(counter).recipient_name: '||p_quote_access_tbl(counter).recipient_name);
786: END IF;
787: IBE_SH_QUOTE_ACCESS_PKG.Insert_Row(
788: p_quote_sharee_id => l_quote_recip_id,
789: p_quote_header_id => p_quote_header_id,
790: p_quote_sharee_number => l_quote_access_rec.quote_sharee_number,
791: p_update_privilege_type_code => p_quote_access_tbl(counter).update_privilege_type_code,

Line 836: IBE_UTIL.DEBUG('Calling IBE_SH_QUOTE_ACCESS_PKG.Update_Row to update the recip record');

832: IF((l_quote_access_rec.update_privilege_type_code is not null) and
833: (l_quote_access_rec.update_privilege_type_code <> FND_API.G_MISS_CHAR) and
834: (l_old_access_level <> l_quote_access_rec.update_privilege_type_code)) then
835: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
836: IBE_UTIL.DEBUG('Calling IBE_SH_QUOTE_ACCESS_PKG.Update_Row to update the recip record');
837: IBE_UTIL.DEBUG('p_quote_access_tbl(counter).quote_sharee_id: '||p_quote_access_tbl(counter).quote_sharee_id);
838: END IF;
839:
840: IBE_SH_QUOTE_ACCESS_PKG.Update_Row(

Line 840: IBE_SH_QUOTE_ACCESS_PKG.Update_Row(

836: IBE_UTIL.DEBUG('Calling IBE_SH_QUOTE_ACCESS_PKG.Update_Row to update the recip record');
837: IBE_UTIL.DEBUG('p_quote_access_tbl(counter).quote_sharee_id: '||p_quote_access_tbl(counter).quote_sharee_id);
838: END IF;
839:
840: IBE_SH_QUOTE_ACCESS_PKG.Update_Row(
841: p_QUOTE_HEADER_ID => p_quote_header_id,
842: p_quote_sharee_id => p_quote_access_tbl(counter).quote_sharee_id,
843: p_UPDATE_PRIVILEGE_TYPE_CODE => p_quote_access_tbl(counter).update_privilege_type_code);
844:

Line 846: IBE_UTIL.DEBUG('Done IBE_SH_QUOTE_ACCESS_PKG.Update_Row ');

842: p_quote_sharee_id => p_quote_access_tbl(counter).quote_sharee_id,
843: p_UPDATE_PRIVILEGE_TYPE_CODE => p_quote_access_tbl(counter).update_privilege_type_code);
844:
845: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
846: IBE_UTIL.DEBUG('Done IBE_SH_QUOTE_ACCESS_PKG.Update_Row ');
847: END IF;
848:
849: /*If access level is being downgraded to 'read-only' */
850: IF(p_quote_access_tbl(counter).UPDATE_PRIVILEGE_TYPE_CODE = 'R') THEN

Line 1484: l_contact_points_rec.owner_table_name := 'IBE_SH_QUOTE_ACCESS';

1480: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1481: IBE_UTIL.debug('Mode of contact point is EMAIL');
1482: END IF;
1483: l_contact_points_rec.contact_point_type := 'EMAIL';
1484: l_contact_points_rec.owner_table_name := 'IBE_SH_QUOTE_ACCESS';
1485: l_email_rec.email_address := P_EMAIL;
1486: elsif (p_mode = 'WEB') THEN
1487: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1488: IBE_UTIL.debug('Mode of contact point is WEB');

Line 1492: l_contact_points_rec.owner_table_name := 'IBE_SH_QUOTE_ACCESS';

1488: IBE_UTIL.debug('Mode of contact point is WEB');
1489: END IF;
1490:
1491: l_contact_points_rec.contact_point_type := 'WEB';
1492: l_contact_points_rec.owner_table_name := 'IBE_SH_QUOTE_ACCESS';
1493: l_web_rec.url := P_URL;
1494: l_web_rec.web_type := 'com';
1495: END IF;
1496:

Line 1638: from ibe_sh_quote_access

1634: l_api_version CONSTANT NUMBER := 1.0;
1635:
1636: cursor c_select_recip(c_qte_hdr_id number) is
1637: select party_id, cust_account_id
1638: from ibe_sh_quote_access
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;

Line 2013: from IBE_SH_QUOTE_ACCESS SH,

2009: SH.contact_point_id,
2010: quote_sharee_number,
2011: HZ.EMAIL_ADDRESS,
2012: FND.customer_id shared_by_party_id
2013: from IBE_SH_QUOTE_ACCESS SH,
2014: HZ_CONTACT_POINTS HZ,
2015: FND_USER FND
2016: where SH.contact_point_id = HZ.Contact_point_id
2017: and quote_header_id = c_qte_hdr_id

Line 2029: from IBE_SH_QUOTE_ACCESS SH,

2025: SH.contact_point_id,
2026: quote_sharee_number,
2027: HZ.EMAIL_ADDRESS,
2028: FND.customer_id shared_by_party_id
2029: from IBE_SH_QUOTE_ACCESS SH,
2030: HZ_CONTACT_POINTS HZ,
2031: FND_USER FND
2032: where SH.contact_point_id = HZ.Contact_point_id
2033: and quote_sharee_id = c_recipient_id

Line 2308: FROM IBE_SH_QUOTE_ACCESS

2304: c_party_id NUMBER,
2305: c_cust_account_id NUMBER,
2306: c_quote_header_id NUMBER) is
2307: SELECT quote_sharee_id, quote_header_id
2308: FROM IBE_SH_QUOTE_ACCESS
2309: WHERE quote_sharee_number = c_retrieval_num
2310: OR (party_id = c_party_id and cust_account_id = c_cust_account_id)
2311: AND quote_header_id = c_quote_header_id
2312: AND nvl(end_date_active, sysdate+1) > sysdate;

Line 2326: FROM ibe_sh_quote_access

2322: quote_sharee_number,
2323: quote_header_id,
2324: update_privilege_type_code,
2325: contact_point_id
2326: FROM ibe_sh_quote_access
2327: where quote_sharee_id = c_recipient_id;
2328:
2329: rec_get_recipient_party c_get_recipient_party%rowtype;
2330:

Line 2519: from IBE_SH_QUOTE_ACCESS

2515: select quote_sharee_id,
2516: party_id,
2517: cust_account_id,
2518: quote_header_id
2519: from IBE_SH_QUOTE_ACCESS
2520: where quote_header_id = c_qte_hdr_id
2521: and nvl(end_date_active,sysdate+1) > sysdate;
2522:
2523: rec_get_recipients c_get_recipients%rowtype;

Line 2676: from IBE_ACTIVE_QUOTES a, ibe_sh_quote_access b

2672:
2673: /* Fixed the query for the bug 4860734 */
2674: cursor c_find_active_cart is
2675: select a.quote_header_id, a.party_id ,a.cust_account_id
2676: from IBE_ACTIVE_QUOTES a, ibe_sh_quote_access b
2677: where a.party_id = b.party_id
2678: and a.cust_account_id = b.cust_account_id
2679: and b.quote_sharee_id = P_Quote_access_rec.quote_sharee_id
2680: and nvl(b.end_date_active, sysdate+1) > sysdate

Line 2691: from hz_contact_points CNTCT_POINTS, ibe_sh_quote_access QUOTE_ACCESS

2687: where quote_header_id = c_quote_id;
2688:
2689: cursor c_get_contact_point_ovn(c_quote_sharee_id Number) IS
2690: select QUOTE_ACCESS.party_id, CNTCT_POINTS.contact_point_id, CNTCT_POINTS.object_version_number
2691: from hz_contact_points CNTCT_POINTS, ibe_sh_quote_access QUOTE_ACCESS
2692: where CNTCT_POINTS.contact_point_id = QUOTE_ACCESS.contact_point_id
2693: and quote_sharee_id = c_quote_sharee_id;
2694:
2695: rec_find_active_cart c_find_active_cart%rowtype;

Line 2775: IBE_SH_QUOTE_ACCESS_PKG.update_Row(

2771: RAISE FND_API.G_EXC_ERROR;
2772: END IF;
2773: END IF;
2774:
2775: IBE_SH_QUOTE_ACCESS_PKG.update_Row(
2776: p_quote_sharee_id => P_Quote_access_rec.quote_sharee_id
2777: ,p_end_date_active => sysdate);
2778: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2779: IBE_UTIL.DEBUG('Done calling Update row handler on sh_quote_access table to end-date recipient row');

Line 2938: from ibe_sh_quote_access

2934: rec_get_owner_partyid c_get_owner_partyid%rowtype;
2935:
2936: cursor c_get_role_by_retr_num(c_retrieval_number number, c_party_id number, c_acct_id number) is
2937: select update_privilege_type_code
2938: from ibe_sh_quote_access
2939: where quote_sharee_number = c_retrieval_number
2940: and (party_id is null or party_id = c_party_id)
2941: and (cust_account_id is null or cust_account_id = c_acct_id);
2942:

Line 2947: from ibe_sh_quote_access

2943: rec_get_role_by_retr_num c_get_role_by_retr_num%rowtype;
2944:
2945: cursor c_get_role_by_user(c_party_id number, c_account_id number, c_qte_hdr_id number) is
2946: select update_privilege_type_code
2947: from ibe_sh_quote_access
2948: where quote_header_id = c_qte_hdr_id
2949: and party_id = c_party_id
2950: and cust_account_id = c_account_id
2951: AND nvl(end_date_active, sysdate+1) > sysdate;

Line 2958: from ibe_sh_quote_access

2954: rec_get_role_by_user c_get_role_by_user%rowtype;
2955:
2956: cursor c_get_recipient_info(c_recipient_id number) is
2957: select last_update_date, last_updated_by, end_date_active, update_privilege_type_code
2958: from ibe_sh_quote_access
2959: where quote_sharee_id = c_recipient_id;
2960:
2961: rec_get_recipient_info c_get_recipient_info%rowtype;
2962: