APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on IBE_ACTIVE_QUOTES

Line 8: from IBE_ACTIVE_QUOTES

4:
5: cursor c_check_active_cart(c_party_id number,
6: c_cust_account_id number) is
7: select quote_header_id
8: from IBE_ACTIVE_QUOTES
9: where party_id = c_party_id
10: and cust_account_id = c_cust_account_id
11: and record_type = 'CART';
12:

Line 869: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(

865: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
866: IBE_UTIL.DEBUG('Calling delete handler of active_quotes_all table');
867: END IF;
868:
869: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(
870: x_object_version_number => 1,
871: x_quote_header_id => null,
872: x_party_id => l_quote_access_rec.party_id ,
873: x_cust_account_id => l_quote_access_rec.cust_account_id,

Line 1108: from ibe_active_quotes aq

1104:
1105: cursor c_check_ac_aqa(c_party_id number,
1106: c_cust_account_id number) is
1107: select aq.quote_header_id ,aq.party_id
1108: from ibe_active_quotes aq
1109: where party_id = c_party_id
1110: and cust_account_id = c_cust_account_id
1111: and record_type = 'CART';
1112:

Line 1282: IBE_ACTIVE_QUOTES_ALL_PKG.update_row(

1278: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:Calling update row hdlr');
1279: END IF;
1280: --DBMS_OUTPUT.PUT_LINE('Calling update row handler for active carts');
1281:
1282: IBE_ACTIVE_QUOTES_ALL_PKG.update_row(
1283: X_OBJECT_VERSION_NUMBER => 1,
1284: x_last_update_date => sysdate,
1285: x_last_updated_by => fnd_global.user_id,
1286: x_last_update_login => 1,

Line 1301: IBE_ACTIVE_QUOTES_ALL_PKG.Insert_row(

1297: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1298: IBE_UTIL.DEBUG('no active carts present for p_party_id hence inserting a new record');
1299: IBE_UTIL.DEBUG('Quote header id of new active active cart is: '||p_quote_header_rec.quote_header_id);
1300: END IF;
1301: IBE_ACTIVE_QUOTES_ALL_PKG.Insert_row(
1302: X_OBJECT_VERSION_NUMBER => 1,
1303: X_QUOTE_HEADER_ID => p_quote_header_rec.quote_header_id,
1304: X_PARTY_ID => p_party_id,
1305: X_CUST_ACCOUNT_ID => p_cust_account_id,

Line 1687: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(

1683: --DBMS_OUTPUT.PUT_LINE('P_quote_header_id '||P_quote_header_id);
1684: --DBMS_OUTPUT.PUT_LINE('p_quote_access_tbl(counter).party_id '||p_party_id);
1685: --DBMS_OUTPUT.PUT_LINE('p_quote_access_tbl(counter).cust_account_id '||p_cust_account_id);
1686:
1687: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(
1688: X_OBJECT_VERSION_NUMBER => 1,
1689: X_QUOTE_HEADER_ID => null,
1690: X_PARTY_ID => p_party_id ,
1691: X_CUST_ACCOUNT_ID => p_cust_account_id,

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 2734: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(

2730: IBE_UTIL.DEBUG('Calling update row handler to deactivate the cart');
2731: END IF;
2732: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2733:
2734: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(
2735: X_OBJECT_VERSION_NUMBER => 1 ,
2736: X_QUOTE_HEADER_ID => null ,
2737: X_PARTY_ID => rec_find_active_cart.party_id ,
2738: X_CUST_ACCOUNT_ID => rec_find_active_cart.cust_account_id,