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 2329: FROM IBE_SH_QUOTE_ACCESS

2325: c_party_id NUMBER,
2326: c_cust_account_id NUMBER,
2327: c_quote_header_id NUMBER) is
2328: SELECT quote_sharee_id, quote_header_id
2329: FROM IBE_SH_QUOTE_ACCESS
2330: WHERE quote_sharee_number = c_retrieval_num
2331: OR (party_id = c_party_id and cust_account_id = c_cust_account_id)
2332: AND quote_header_id = c_quote_header_id
2333: AND nvl(end_date_active, sysdate+1) > sysdate;

Line 2347: FROM ibe_sh_quote_access

2343: quote_sharee_number,
2344: quote_header_id,
2345: update_privilege_type_code,
2346: contact_point_id
2347: FROM ibe_sh_quote_access
2348: where quote_sharee_id = c_recipient_id;
2349:
2350: rec_get_recipient_party c_get_recipient_party%rowtype;
2351:

Line 2540: from IBE_SH_QUOTE_ACCESS

2536: select quote_sharee_id,
2537: party_id,
2538: cust_account_id,
2539: quote_header_id
2540: from IBE_SH_QUOTE_ACCESS
2541: where quote_header_id = c_qte_hdr_id
2542: and nvl(end_date_active,sysdate+1) > sysdate;
2543:
2544: rec_get_recipients c_get_recipients%rowtype;

Line 2697: from IBE_ACTIVE_QUOTES a, ibe_sh_quote_access b

2693:
2694: /* Fixed the query for the bug 4860734 */
2695: cursor c_find_active_cart is
2696: select a.quote_header_id, a.party_id ,a.cust_account_id
2697: from IBE_ACTIVE_QUOTES a, ibe_sh_quote_access b
2698: where a.party_id = b.party_id
2699: and a.cust_account_id = b.cust_account_id
2700: and b.quote_sharee_id = P_Quote_access_rec.quote_sharee_id
2701: and nvl(b.end_date_active, sysdate+1) > sysdate

Line 2712: from hz_contact_points CNTCT_POINTS, ibe_sh_quote_access QUOTE_ACCESS

2708: where quote_header_id = c_quote_id;
2709:
2710: cursor c_get_contact_point_ovn(c_quote_sharee_id Number) IS
2711: select QUOTE_ACCESS.party_id, CNTCT_POINTS.contact_point_id, CNTCT_POINTS.object_version_number
2712: from hz_contact_points CNTCT_POINTS, ibe_sh_quote_access QUOTE_ACCESS
2713: where CNTCT_POINTS.contact_point_id = QUOTE_ACCESS.contact_point_id
2714: and quote_sharee_id = c_quote_sharee_id;
2715:
2716: rec_find_active_cart c_find_active_cart%rowtype;

Line 2796: IBE_SH_QUOTE_ACCESS_PKG.update_Row(

2792: RAISE FND_API.G_EXC_ERROR;
2793: END IF;
2794: END IF;
2795:
2796: IBE_SH_QUOTE_ACCESS_PKG.update_Row(
2797: p_quote_sharee_id => P_Quote_access_rec.quote_sharee_id
2798: ,p_end_date_active => sysdate);
2799: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2800: IBE_UTIL.DEBUG('Done calling Update row handler on sh_quote_access table to end-date recipient row');

Line 2959: from ibe_sh_quote_access

2955: rec_get_owner_partyid c_get_owner_partyid%rowtype;
2956:
2957: cursor c_get_role_by_retr_num(c_retrieval_number number, c_party_id number, c_acct_id number) is
2958: select update_privilege_type_code
2959: from ibe_sh_quote_access
2960: where quote_sharee_number = c_retrieval_number
2961: and (party_id is null or party_id = c_party_id)
2962: and (cust_account_id is null or cust_account_id = c_acct_id);
2963:

Line 2968: from ibe_sh_quote_access

2964: rec_get_role_by_retr_num c_get_role_by_retr_num%rowtype;
2965:
2966: cursor c_get_role_by_user(c_party_id number, c_account_id number, c_qte_hdr_id number) is
2967: select update_privilege_type_code
2968: from ibe_sh_quote_access
2969: where quote_header_id = c_qte_hdr_id
2970: and party_id = c_party_id
2971: and cust_account_id = c_account_id
2972: AND nvl(end_date_active, sysdate+1) > sysdate;

Line 2979: from ibe_sh_quote_access

2975: rec_get_role_by_user c_get_role_by_user%rowtype;
2976:
2977: cursor c_get_recipient_info(c_recipient_id number) is
2978: select last_update_date, last_updated_by, end_date_active, update_privilege_type_code
2979: from ibe_sh_quote_access
2980: where quote_sharee_id = c_recipient_id;
2981:
2982: rec_get_recipient_info c_get_recipient_info%rowtype;
2983: