DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVESHARE_PVT dependencies on IBE_QUOTE_MISC_PVT

Line 255: x_qte_line_tbl := IBE_Quote_Misc_pvt.getLineTbl

251: END IF;
252: END LOOP;
253: END IF;
254: ELSE
255: x_qte_line_tbl := IBE_Quote_Misc_pvt.getLineTbl
256: (p_from_quote_header_id);
257: l_Price_Adjustment_Tbl_ALL := IBE_Quote_Misc_pvt.getAllLinesPrcAdjTbl (p_from_quote_header_id);
258: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
259: ibe_util.debug('reusing x_Price_Adjustment_Tbl -- size='|| x_Price_Adjustment_Tbl.count);

Line 257: l_Price_Adjustment_Tbl_ALL := IBE_Quote_Misc_pvt.getAllLinesPrcAdjTbl (p_from_quote_header_id);

253: END IF;
254: ELSE
255: x_qte_line_tbl := IBE_Quote_Misc_pvt.getLineTbl
256: (p_from_quote_header_id);
257: l_Price_Adjustment_Tbl_ALL := IBE_Quote_Misc_pvt.getAllLinesPrcAdjTbl (p_from_quote_header_id);
258: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
259: ibe_util.debug('reusing x_Price_Adjustment_Tbl -- size='|| x_Price_Adjustment_Tbl.count);
260: ibe_util.debug('reusing x_Price_Adj_Rltship_Tbl -- size='|| x_Price_Adj_Rltship_Tbl.count);
261: ibe_util.debug('l_Price_Adjustment_Tbl_ALL size is='|| l_Price_Adjustment_Tbl_ALL.count);

Line 273: l_qte_line_dtl_tbl := IBE_Quote_Misc_pvt.getlineDetailTbl

269:
270:
271: FOR i IN 1..x_qte_line_tbl.COUNT LOOP
272:
273: l_qte_line_dtl_tbl := IBE_Quote_Misc_pvt.getlineDetailTbl
274: (x_qte_line_tbl(i).quote_line_id);
275: FOR j IN 1..l_qte_line_dtl_tbl.COUNT LOOP
276: IF l_qte_line_dtl_tbl(j).service_ref_line_id <> fnd_api.g_miss_num THEN
277: l_qte_line_dtl_tbl(j).service_ref_qte_line_index :=

Line 278: IBE_Quote_Misc_pvt.getLineIndexFromLineId(l_qte_line_dtl_tbl(j).service_ref_line_id,

274: (x_qte_line_tbl(i).quote_line_id);
275: FOR j IN 1..l_qte_line_dtl_tbl.COUNT LOOP
276: IF l_qte_line_dtl_tbl(j).service_ref_line_id <> fnd_api.g_miss_num THEN
277: l_qte_line_dtl_tbl(j).service_ref_qte_line_index :=
278: IBE_Quote_Misc_pvt.getLineIndexFromLineId(l_qte_line_dtl_tbl(j).service_ref_line_id,
279: x_qte_line_tbl);
280: l_qte_line_dtl_tbl(j).service_ref_line_id := fnd_api.g_miss_num;
281: END IF;
282: l_qte_line_dtl_tbl(j).quote_line_detail_id := fnd_api.g_miss_num;

Line 291: l_line_rltship_tbl := IBE_Quote_Misc_pvt.getlineRelationshipTbl(x_qte_line_tbl(i).quote_line_id);

287: := l_qte_line_dtl_tbl(j);
288: END LOOP;
289:
290:
291: l_line_rltship_tbl := IBE_Quote_Misc_pvt.getlineRelationshipTbl(x_qte_line_tbl(i).quote_line_id);
292:
293: FOR j IN 1..l_line_rltship_tbl.COUNT LOOP
294: IF NVL(l_line_rltship_tbl(j).relationship_type_code, '*') <> 'SERVICE' THEN
295: l_line_rltship_tbl(j).line_relationship_id := fnd_api.g_miss_num;

Line 300: := IBE_Quote_Misc_pvt.getLineIndexFromLineId

296: l_line_rltship_tbl(j).operation_code := 'CREATE';
297:
298: l_line_rltship_tbl(j).qte_line_index := i;
299: l_line_rltship_tbl(j).related_qte_line_index
300: := IBE_Quote_Misc_pvt.getLineIndexFromLineId
301: ( l_line_rltship_tbl(j).related_quote_line_id
302: ,x_qte_line_tbl
303: );
304: l_line_rltship_tbl(j).quote_line_id := fnd_api.g_miss_num;

Line 320: l_line_attr_ext_tbl := IBE_Quote_Misc_pvt.getLineAttrExtTbl

316: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
317: ibe_util.debug('regulat copy lines and copying line attr and price attributes');
318: END IF;
319:
320: l_line_attr_ext_tbl := IBE_Quote_Misc_pvt.getLineAttrExtTbl
321: (x_qte_line_tbl(i).quote_line_id);
322:
323: FOR j IN 1..l_line_attr_ext_tbl.COUNT LOOP
324: l_line_attr_ext_tbl(j).line_attribute_id := fnd_api.g_miss_num;

Line 334: l_ln_price_attributes_tbl := IBE_Quote_Misc_pvt.getlinePrcAttrTbl

330: x_line_attr_ext_tbl(x_line_attr_ext_tbl.count+1)
331: := l_line_attr_ext_tbl(j);
332: END LOOP;
333:
334: l_ln_price_attributes_tbl := IBE_Quote_Misc_pvt.getlinePrcAttrTbl
335: (x_qte_line_tbl(i).quote_line_id);
336:
337: FOR j IN 1..l_ln_price_attributes_tbl.COUNT LOOP
338: l_ln_price_attributes_tbl(j).price_attribute_id := fnd_api.g_miss_num;

Line 349: l_Price_Adjustment_Tbl := IBE_Quote_Misc_pvt.getLinePrcAdjTbl (x_qte_line_tbl(i).quote_line_id);

345: END LOOP;
346:
347: -- added 12/22/03: PRG, no line merge
348: -- for each quote_line_id, get the price adjustment info
349: l_Price_Adjustment_Tbl := IBE_Quote_Misc_pvt.getLinePrcAdjTbl (x_qte_line_tbl(i).quote_line_id);
350: FOR j IN 1..l_Price_Adjustment_Tbl.COUNT LOOP
351:
352: -- if Free Line, for each PRICE_ADJUSTMENT_ID, get the related info
353: if (x_qte_line_tbl(i).pricing_line_type_indicator = 'F') then

Line 358: l_Price_Adj_Rltship_Tbl := IBE_Quote_Misc_pvt.getLinePrcAdjRelTbl (l_Price_Adjustment_Tbl(j).PRICE_ADJUSTMENT_ID);

354: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
355: ibe_util.debug('x_qte_line_tbl(i).pricing_line_type_indicator='|| x_qte_line_tbl(i).pricing_line_type_indicator);
356: ibe_util.debug('before calling getLinePrcAdjRelTbl: l_Price_Adjustment_Tbl(j).PRICE_ADJUSTMENT_ID='|| l_Price_Adjustment_Tbl(j).PRICE_ADJUSTMENT_ID);
357: END IF;
358: l_Price_Adj_Rltship_Tbl := IBE_Quote_Misc_pvt.getLinePrcAdjRelTbl (l_Price_Adjustment_Tbl(j).PRICE_ADJUSTMENT_ID);
359: FOR k IN 1..l_Price_Adj_Rltship_Tbl.COUNT LOOP
360: l_Price_Adj_Rltship_Tbl(k).ADJ_RELATIONSHIP_ID := fnd_api.g_miss_num;
361: l_Price_Adj_Rltship_Tbl(k).operation_code := 'CREATE';
362:

Line 366: l_Price_Adj_Rltship_Tbl(k).PRICE_ADJ_INDEX := IBE_Quote_Misc_pvt.getPrcAdjIndexFromPrcAdjId

362:
363: l_Price_Adj_Rltship_Tbl(k).RLTD_PRICE_ADJ_INDEX := x_Price_Adjustment_Tbl.count+j;
364:
365: -- the following two values are for Qual Lines, we have to search the indices
366: l_Price_Adj_Rltship_Tbl(k).PRICE_ADJ_INDEX := IBE_Quote_Misc_pvt.getPrcAdjIndexFromPrcAdjId
367: (l_Price_Adj_Rltship_Tbl(k).PRICE_ADJUSTMENT_ID, l_Price_Adjustment_Tbl_ALL);
368: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
369: ibe_util.debug('New... need to pass qte_line_index');
370: END IF;

Line 371: l_Price_Adj_Rltship_Tbl(k).QTE_LINE_INDEX := IBE_Quote_Misc_pvt.getLineIndexFromLineId(l_Price_Adj_Rltship_Tbl(k).quote_line_id, x_qte_line_tbl);

367: (l_Price_Adj_Rltship_Tbl(k).PRICE_ADJUSTMENT_ID, l_Price_Adjustment_Tbl_ALL);
368: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
369: ibe_util.debug('New... need to pass qte_line_index');
370: END IF;
371: l_Price_Adj_Rltship_Tbl(k).QTE_LINE_INDEX := IBE_Quote_Misc_pvt.getLineIndexFromLineId(l_Price_Adj_Rltship_Tbl(k).quote_line_id, x_qte_line_tbl);
372: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
373: ibe_util.debug('New... and the qte_line_index is:'||l_Price_Adj_Rltship_Tbl(k).QTE_LINE_INDEX);
374: END IF;
375: -- clear out the other id's

Line 748: IBE_Quote_Misc_pvt.Validate_User_Update(

744: -- Initialize API return status to success
745: x_return_status := FND_API.G_RET_STS_SUCCESS;
746:
747: -- User Authentication
748: IBE_Quote_Misc_pvt.Validate_User_Update(
749: p_init_msg_list => p_init_msg_list
750: ,p_quote_header_id => p_from_quote_header_id
751: ,p_party_id => p_to_Qte_Header_Rec.party_id
752: ,p_cust_account_id => p_to_Qte_Header_Rec.cust_account_id

Line 769: IBE_Quote_Misc_pvt.getQuoteOwner

765:
766:
767: l_to_qte_header_rec := p_to_qte_header_rec;
768: -- get party_id and cust_account_id of quote_header_id
769: IBE_Quote_Misc_pvt.getQuoteOwner
770: ( p_api_version_number => p_api_version_number
771: ,p_quote_header_id => p_from_quote_header_id
772: ,x_party_id => l_Party_id
773: ,x_cust_account_id => l_Cust_account_id

Line 832: := IBE_Quote_Misc_pvt.getQuotelastUpdateDate

828: END IF;
829:
830: -- copy change the lastupdatedate, but order capture does not return it.
831: l_to_qte_header_rec.last_update_date
832: := IBE_Quote_Misc_pvt.getQuotelastUpdateDate
833: (l_to_qte_header_rec.quote_header_id);
834: ELSE
835: -- get order_type_id from the original quote header
836: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1107: IBE_Quote_Misc_pvt.log_environment_info();

1103: -- API body
1104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1105: IBE_UTIL.DEBUG('APPENDTOREPLACESHARE: Before Calling log_environment_info');
1106: END IF;
1107: IBE_Quote_Misc_pvt.log_environment_info();
1108: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1109: IBE_UTIL.DEBUG('APPENDTOREPLACESHARE: After Calling log_environment_info');
1110: END IF;
1111:

Line 1113: IBE_Quote_Misc_pvt.Validate_User_Update(

1109: IBE_UTIL.DEBUG('APPENDTOREPLACESHARE: After Calling log_environment_info');
1110: END IF;
1111:
1112: -- User Authentication
1113: IBE_Quote_Misc_pvt.Validate_User_Update(
1114: p_init_msg_list => p_init_msg_list
1115: ,p_quote_header_id => p_original_quote_header_id
1116: ,p_party_id => p_party_id
1117: ,p_cust_account_id => p_cust_account_id

Line 1136: IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate

1132: --Removing this validation as this is already being done in validate_user_update
1133: /*IF (p_last_update_date is not null
1134: and p_last_update_date <> fnd_api.g_miss_date) THEN
1135:
1136: IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate
1137: ( p_api_version_number => p_api_version_number
1138: ,p_quote_header_id => p_original_quote_header_id
1139: ,p_last_update_date => p_last_update_date
1140: ,X_Return_Status => x_return_status

Line 1255: := IBE_Quote_Misc_pvt.getQuotelastUpdateDate

1251: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254: l_to_qte_header_rec.last_update_date
1255: := IBE_Quote_Misc_pvt.getQuotelastUpdateDate
1256: (l_to_qte_header_rec.quote_header_id);
1257:
1258: else
1259: -- we are in a sort of update mode updating the target cart

Line 1262: := IBE_Quote_Misc_pvt.getQuotelastUpdateDate

1258: else
1259: -- we are in a sort of update mode updating the target cart
1260: l_to_qte_header_rec.quote_header_id := p_rep_app_quote_header_id;
1261: l_to_qte_header_rec.last_update_date
1262: := IBE_Quote_Misc_pvt.getQuotelastUpdateDate
1263: (l_to_qte_header_rec.quote_header_id);
1264: end if; -- end of copy_quote if
1265:
1266: IF ((p_mode = 'REPLACE' )

Line 1500: IBE_Quote_Misc_pvt.log_environment_info();

1496: -- API body
1497: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1498: IBE_UTIL.DEBUG('SAVEASANDSHARE: Before Calling log_environment_info');
1499: END IF;
1500: IBE_Quote_Misc_pvt.log_environment_info();
1501: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1502: IBE_UTIL.DEBUG('SAVEASANDSHARE: After Calling log_environment_info');
1503: END IF;
1504:

Line 1656: IBE_Quote_Misc_pvt.log_environment_info();

1652: -- API body
1653: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1654: IBE_UTIL.DEBUG('ActivateQuote: Before Calling log_environment_info');
1655: END IF;
1656: IBE_Quote_Misc_pvt.log_environment_info();
1657: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1658: IBE_UTIL.DEBUG('ActivateQuote: After Calling log_environment_info');
1659: END IF;
1660:

Line 1662: IBE_Quote_Misc_pvt.Validate_User_Update(

1658: IBE_UTIL.DEBUG('ActivateQuote: After Calling log_environment_info');
1659: END IF;
1660:
1661: -- User Authentication
1662: IBE_Quote_Misc_pvt.Validate_User_Update(
1663: p_init_msg_list => p_init_msg_list
1664: ,p_quote_header_id => p_quote_header_id
1665: ,p_validate_user => FND_API.G_TRUE
1666: ,x_return_status => x_return_status

Line 1687: l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.GetQuoteLastUpdateDate(l_qte_header_rec.quote_header_id);

1683: l_qte_header_rec.last_update_date := p_last_update_date;
1684:
1685: IF l_qte_header_rec.last_update_date IS NULL
1686: OR l_qte_header_rec.last_update_date = FND_API.G_MISS_DATE THEN
1687: l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.GetQuoteLastUpdateDate(l_qte_header_rec.quote_header_id);
1688: END IF;
1689:
1690:
1691: IF FND_API.To_Boolean(p_increaseVersion) THEN

Line 1721: l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.GetQuoteLastUpdateDate(l_qte_header_rec.quote_header_id);

1717: END IF;
1718:
1719: l_qte_header_rec.quote_header_id := l_quote_header_id_tmp;
1720:
1721: l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.GetQuoteLastUpdateDate(l_qte_header_rec.quote_header_id);
1722: END IF;
1723:
1724: l_qte_header_rec.quote_name := 'IBE_PRMT_SC_UNNAMED';
1725: l_qte_header_rec.quote_source_code := 'IStore Account';

Line 1905: IBE_Quote_Misc_pvt.log_environment_info();

1901:
1902: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1903: IBE_UTIL.DEBUG('RETRIEVESHAREQUOTE: Before Calling log_environment_info');
1904: END IF;
1905: IBE_Quote_Misc_pvt.log_environment_info();
1906: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1907: IBE_UTIL.DEBUG('RETRIEVESHAREQUOTE: After Calling log_environment_info');
1908: END IF;
1909:

Line 1911: IBE_UTIL.DEBUG('call IBE_Quote_Misc_pvt.get_Shared_Quote at'

1907: IBE_UTIL.DEBUG('RETRIEVESHAREQUOTE: After Calling log_environment_info');
1908: END IF;
1909:
1910: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1911: IBE_UTIL.DEBUG('call IBE_Quote_Misc_pvt.get_Shared_Quote at'
1912: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1913: END IF;
1914:
1915: IBE_Quote_Misc_pvt.get_Shared_Quote

Line 1915: IBE_Quote_Misc_pvt.get_Shared_Quote

1911: IBE_UTIL.DEBUG('call IBE_Quote_Misc_pvt.get_Shared_Quote at'
1912: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1913: END IF;
1914:
1915: IBE_Quote_Misc_pvt.get_Shared_Quote
1916: ( p_api_version_number => p_api_version_number
1917: ,p_quote_password => p_quote_password
1918: ,p_quote_number => p_quote_number
1919: ,p_quote_version => p_quote_version

Line 1933: IBE_UTIL.DEBUG('done IBE_Quote_Misc_pvt.getShareQuote at'

1929: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1933: IBE_UTIL.DEBUG('done IBE_Quote_Misc_pvt.getShareQuote at'
1934: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1935: END IF;
1936:
1937: x_privilege_type_code := IBE_Quote_Misc_pvt.getShareePrivilege

Line 1937: x_privilege_type_code := IBE_Quote_Misc_pvt.getShareePrivilege

1933: IBE_UTIL.DEBUG('done IBE_Quote_Misc_pvt.getShareQuote at'
1934: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1935: END IF;
1936:
1937: x_privilege_type_code := IBE_Quote_Misc_pvt.getShareePrivilege
1938: ( p_quote_header_id => l_qte_header_rec.quote_header_id
1939: ,p_sharee_number => p_sharee_number
1940: );
1941: l_pricebasedonowner := fnd_profile.value('IBE_SC_PRICE_BASED_ON_OWNER');

Line 2203: IBE_Quote_Misc_pvt.log_environment_info();

2199:
2200: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2201: IBE_UTIL.DEBUG('MergeActiveQuote: Before Calling log_environment_info');
2202: END IF;
2203: IBE_Quote_Misc_pvt.log_environment_info();
2204: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2205: IBE_UTIL.DEBUG('MergeActiveQuote: After Calling log_environment_info');
2206: END IF;
2207:

Line 2249: := IBE_Quote_Misc_pvt.get_active_quote_id(

2245: IBE_UTIL.DEBUG('MergeActiveQuote: before getActiveQuote');
2246: END IF;
2247: --Retrieve the database(account active cart) quote header id
2248: l_db_qte_header_rec.quote_header_id
2249: := IBE_Quote_Misc_pvt.get_active_quote_id(
2250: p_party_id => p_party_id ,
2251: p_cust_account_id => p_cust_account_id);
2252:
2253: IF (IBE_UTIL.G_DEBUGON = l_true) THEN