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.OKS_QA_DATA_INTEGRITY dependencies on OKS_EXTWAR_UTIL_PVT

Line 5797: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>

5793:
5794: --modified if condition, added check for credit amounts also, bug 4947610
5795: -- Usage lines don't have an amount.
5796: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5797: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5798: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5799: l_currency) +
5800: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5801: l_currency) +

Line 5798: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),

5794: --modified if condition, added check for credit amounts also, bug 4947610
5795: -- Usage lines don't have an amount.
5796: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5797: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5798: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5799: l_currency) +
5800: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5801: l_currency) +
5802: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),

Line 5800: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),

5796: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5797: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5798: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5799: l_currency) +
5800: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5801: l_currency) +
5802: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),
5803: l_currency)) THEN
5804:

Line 5802: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),

5798: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5799: l_currency) +
5800: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5801: l_currency) +
5802: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),
5803: l_currency)) THEN
5804:
5805: /* original if condition commented for bug 4947610
5806: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and

Line 5807: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>

5803: l_currency)) THEN
5804:
5805: /* original if condition commented for bug 4947610
5806: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5807: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5808: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5809: l_currency) THEN
5810: */
5811: OKC_API.SET_MESSAGE

Line 5808: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),

5804:
5805: /* original if condition commented for bug 4947610
5806: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5807: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5808: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5809: l_currency) THEN
5810: */
5811: OKC_API.SET_MESSAGE
5812: (

Line 5901: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >

5897: ELSIF l_price_negotiated < 0 AND l_temp_total_billed > 0 THEN
5898: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
5899: END IF;
5900:
5901: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
5902: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
5903:
5904: THEN
5905: OKC_API.SET_MESSAGE

Line 5902: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))

5898: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
5899: END IF;
5900:
5901: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
5902: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
5903:
5904: THEN
5905: OKC_API.SET_MESSAGE
5906: (

Line 5917: END IF; -- IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_billed_amt,0),l_currency) >

5913: p_token3 => 'TOKEN3',
5914: p_token3_value => nvl(l_total_billed, 0)
5915: );
5916: x_return_status := OKC_API.G_RET_STS_ERROR;
5917: END IF; -- IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_billed_amt,0),l_currency) >
5918: END IF; -- nvl(l_total_billed, 0) <> 0
5919: l_temp_total_billed := 0;
5920: END IF;
5921: --------------------------------------------------------------------

Line 6073: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>

6069: */
6070: END LOOP; --end loop of rules_rec
6071:
6072: --Check for subline level element total equal to price negotiated
6073: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
6074: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated, 0), l_currency))
6075: AND line_grp_rec.lse_id <> 13)
6076: THEN
6077:

Line 6074: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated, 0), l_currency))

6070: END LOOP; --end loop of rules_rec
6071:
6072: --Check for subline level element total equal to price negotiated
6073: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
6074: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated, 0), l_currency))
6075: AND line_grp_rec.lse_id <> 13)
6076: THEN
6077:
6078: -- store SQL error message on message stack

Line 6138: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >

6134: ELSIF l_price_negotiated < 0 AND l_temp_total_billed > 0 THEN
6135: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
6136: END IF;
6137:
6138: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
6139: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
6140:
6141: THEN
6142: OKC_API.SET_MESSAGE

Line 6139: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))

6135: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
6136: END IF;
6137:
6138: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
6139: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
6140:
6141: THEN
6142: OKC_API.SET_MESSAGE
6143: (

Line 6154: END IF; -- IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_billed_amt,0),l_currency) >

6150: p_token3 => 'TOKEN3',
6151: p_token3_value => nvl(l_total_billed, 0)
6152: );
6153: x_return_status := OKC_API.G_RET_STS_ERROR;
6154: END IF; -- IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_billed_amt,0),l_currency) >
6155: END IF; -- nvl(l_total_billed, 0) <> 0
6156: END IF; -- line_grp_rec.lse_id <> 13
6157: /*
6158: --Check for price negotiated should not less than billed amount

Line 6170: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed ,0),l_currency) >

6166: l_temp_total_billed := abs(l_temp_total_billed);
6167: l_price_negotiated := abs(l_price_negotiated);
6168: END If;
6169:
6170: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed ,0),l_currency) >
6171: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated,0),l_currency))
6172: AND line_grp_rec.lse_id <> 13)
6173: THEN
6174:

Line 6171: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated,0),l_currency))

6167: l_price_negotiated := abs(l_price_negotiated);
6168: END If;
6169:
6170: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed ,0),l_currency) >
6171: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated,0),l_currency))
6172: AND line_grp_rec.lse_id <> 13)
6173: THEN
6174:
6175: -- store SQL error message on message stack

Line 6220: and (oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt,0),l_currency) <>

6216: -- l_sub_line_price_nego_tot := l_sub_line_price_nego_tot + NVL(line_grp_rec.price_negotiated,0);
6217: -- Compares each sub line price negotiated to sum of level elements for that subline.
6218: /*
6219: IF (l_ETP_flag = 'E' AND top_line_grp_rec.lse_id <> 12)
6220: and (oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt,0),l_currency) <>
6221: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated,0),l_currency))
6222:
6223: THEN
6224:

Line 6221: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated,0),l_currency))

6217: -- Compares each sub line price negotiated to sum of level elements for that subline.
6218: /*
6219: IF (l_ETP_flag = 'E' AND top_line_grp_rec.lse_id <> 12)
6220: and (oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt,0),l_currency) <>
6221: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated,0),l_currency))
6222:
6223: THEN
6224:
6225: OKC_API.SET_MESSAGE