APPS.OKS_QP_INT_PVT dependencies on FND_PROFILE

Line 1085: := fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE');

1081: WHERE inventory_item_id = c_item_id
1082: AND organization_id = c_inv_org_id;
1083:
1084: l_profile_value VARCHAR2 (240)
1085: := fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE');
1086: l_cle_id NUMBER;
1087: l_lse_id NUMBER;
1088: l_dnz_chr_id NUMBER;
1089: l_inv_org_id NUMBER;

Line 1556: l_profile_val := fnd_profile.VALUE ('HZ_AUDIT_ACCT_MERGE');

1552: 'OKS_QUALIFIERS',
1553: FALSE
1554: );
1555: hz_acct_merge_util.load_set (set_num, req_id);
1556: l_profile_val := fnd_profile.VALUE ('HZ_AUDIT_ACCT_MERGE');
1557:
1558: OPEN merged_records;
1559:
1560: LOOP

Line 1933: IF NVL (fnd_profile.VALUE ('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') =

1929: );
1930: END IF;
1931:
1932: --errorout('QTY = '||l_qpprod_quantity || ' UOM = ' || l_qpprod_uom_code);
1933: IF NVL (fnd_profile.VALUE ('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') =
1934: 'YES'
1935: THEN
1936: IF l_qpprod_quantity IS NULL
1937: OR l_qpprod_quantity = 0

Line 2010: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

2006: CLOSE l_currcode_csr;
2007: END IF;
2008:
2009: /*Added for GSI Bug 14102072 */
2010: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
2011:
2012: -- bug 5018782, don't round any amount that we get from QP
2013: l_line_details_rec.price_negotiated := ROUND (l_line_details_rec.price_negotiated, 29);
2014: Else

Line 2861: IF NVL (fnd_profile.VALUE ('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') =

2857: END IF;
2858:
2859: CLOSE l_line_details_csr;
2860:
2861: IF NVL (fnd_profile.VALUE ('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') =
2862: 'YES'
2863: THEN
2864: oks_qp_pkg.calc_price
2865: (p_detail_rec => l_input_detail_rec,

Line 3027: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

3023:
3024: CLOSE l_currcode_csr;
3025: END IF;
3026:
3027: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
3028: -- bug 5018782, don't round any amount that we get from QP
3029: l_line_details_rec.price_negotiated := ROUND (l_line_details_rec.price_negotiated, 29) ;
3030: /* bug 5018782 */
3031: Else

Line 6190: IF nvl(fnd_profile.value ('OKS_USE_BULK_FOR_LINE_REPRICE'), 'NO')='YES'

6186: l_input_details.asking_unit_price := NULL;
6187:
6188:
6189: /* skuchima: Check the profile to whether to call the Line Reprice Bulk mode or the Normal mode Bug:7539977 */
6190: IF nvl(fnd_profile.value ('OKS_USE_BULK_FOR_LINE_REPRICE'), 'NO')='YES'
6191: THEN
6192:
6193: calculate_topline_price_bulk
6194: (p_detail_rec => l_input_details,

Line 6560: IF nvl(fnd_profile.value ('OKS_USE_BULK_FOR_LINE_REPRICE'), 'NO')='YES'

6556: END IF;
6557:
6558: /* skuchima: Check the profile to whether to call the Line Reprice Bulk mode or the Normal mode Bug:7539977*/
6559:
6560: IF nvl(fnd_profile.value ('OKS_USE_BULK_FOR_LINE_REPRICE'), 'NO')='YES'
6561: THEN
6562:
6563: calculate_topline_price_bulk
6564: (p_detail_rec => l_input_detail_rec,