APPS.IBE_ORDER_SAVE_PVT dependencies on IBE_ACTIVE_QUOTES

Line 175: IBE_ACTIVE_QUOTES_ALL_PKG.Update_row(

171: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Deactivate Order: ' || p_party_id || ' : '||p_cust_account_id);
172: END IF;
173:
174:
175: IBE_ACTIVE_QUOTES_ALL_PKG.Update_row(
176: X_OBJECT_VERSION_NUMBER => 1,
177: X_ORDER_HEADER_ID => null ,
178: X_PARTY_ID => p_party_id,
179: X_CUST_ACCOUNT_ID => p_cust_account_id,

Line 208: from ibe_active_quotes aq

204: c_cust_account_id number,
205: c_currency_code varchar2
206: ) is
207: select aq.order_header_id,aq.party_id
208: from ibe_active_quotes aq
209: where cust_account_id = c_cust_account_id
210: and party_id = c_party_id
211: and currency_code = c_currency_code
212: and record_type = 'ORDER';

Line 230: IBE_ACTIVE_QUOTES_ALL_PKG.Insert_row(

226:
227: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
228: Ibe_Util.debug('Pending Return Not Exists');
229: END IF;
230: IBE_ACTIVE_QUOTES_ALL_PKG.Insert_row(
231: X_OBJECT_VERSION_NUMBER => 1,
232: X_ORDER_HEADER_ID => p_order_header_id,
233: X_PARTY_ID => p_party_id,
234: X_CUST_ACCOUNT_ID => p_cust_account_id,

Line 250: IBE_ACTIVE_QUOTES_ALL_PKG.update_row(

246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
247: Ibe_Util.debug('Pending Return Already Exists');
248: END IF;
249:
250: IBE_ACTIVE_QUOTES_ALL_PKG.update_row(
251: X_OBJECT_VERSION_NUMBER => 1,
252: X_LAST_UPDATE_DATE => sysdate,
253: X_LAST_UPDATED_BY => fnd_global.user_id,
254: X_LAST_UPDATE_LOGIN => 1,

Line 618: SELECT aq.order_header_id FROM ibe_active_quotes aq, oe_order_headers_all oh

614: ,p_party_id IN NUMBER
615: ,x_order_header_id OUT NOCOPY NUMBER)
616: IS
617: CURSOR c_getactive_pendret(custAcctId number,currencyCode varchar2,partyId number) IS
618: SELECT aq.order_header_id FROM ibe_active_quotes aq, oe_order_headers_all oh
619: WHERE aq.party_id = partyId
620: AND aq.cust_account_id = custAcctId
621: AND aq.currency_code = currencyCode
622: AND aq.record_type = 'ORDER'

Line 3337: IBE_UTIL.DEBUG('calling ibe_active_quotes_all package handler: ' || l_cancel_flow);

3333:
3334: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3335: IBE_UTIL.DEBUG('header id returned from OE: ' || x_order_header_id );
3336: IBE_UTIL.DEBUG('x_flow_status_code: ' || x_flow_status_code );
3337: IBE_UTIL.DEBUG('calling ibe_active_quotes_all package handler: ' || l_cancel_flow);
3338: END IF;
3339:
3340: IF (FND_API.to_Boolean(l_cancel_flow)
3341: OR ((p_save_type = SAVE_NORMAL AND p_submit_control_rec.submit_flag = 'Y')

Line 3352: IBE_UTIL.DEBUG('back from ibe_active_quotes_all package handler');

3348: l_order_header_rec.transactional_curr_code);
3349: END IF;
3350:
3351: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3352: IBE_UTIL.DEBUG('back from ibe_active_quotes_all package handler');
3353: END IF;
3354:
3355: -- Calling Notification to the user After successfully booking the order.
3356: -- This would send a notification to the user about the conformation of the Return.