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 5650: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>

5646:
5647: --modified if condition, added check for credit amounts also, bug 4947610
5648: -- Usage lines don't have an amount.
5649: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5650: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5651: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5652: l_currency) +
5653: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5654: l_currency) +

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

5647: --modified if condition, added check for credit amounts also, bug 4947610
5648: -- Usage lines don't have an amount.
5649: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5650: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5651: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5652: l_currency) +
5653: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5654: l_currency) +
5655: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),

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

5649: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5650: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5651: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5652: l_currency) +
5653: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5654: l_currency) +
5655: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),
5656: l_currency)) THEN
5657:

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

5651: (oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5652: l_currency) +
5653: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.credit_amount, 0),
5654: l_currency) +
5655: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.suppressed_credit, 0),
5656: l_currency)) THEN
5657:
5658: /* original if condition commented for bug 4947610
5659: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and

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

5656: l_currency)) THEN
5657:
5658: /* original if condition commented for bug 4947610
5659: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5660: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5661: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5662: l_currency) THEN
5663: */
5664: OKC_API.SET_MESSAGE

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

5657:
5658: /* original if condition commented for bug 4947610
5659: IF(l_ETP_flag = 'E') AND top_line_grp_rec.lse_id <> 12 AND -- top_line_grp_rec.lse_id = 46 and
5660: oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5661: oks_extwar_util_pvt.round_currency_amt(NVL(top_line_grp_rec.price_negotiated, 0),
5662: l_currency) THEN
5663: */
5664: OKC_API.SET_MESSAGE
5665: (

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

5750: ELSIF l_price_negotiated < 0 AND l_temp_total_billed > 0 THEN
5751: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
5752: END IF;
5753:
5754: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
5755: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
5756:
5757: THEN
5758: OKC_API.SET_MESSAGE

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

5751: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
5752: END IF;
5753:
5754: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
5755: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
5756:
5757: THEN
5758: OKC_API.SET_MESSAGE
5759: (

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

5766: p_token3 => 'TOKEN3',
5767: p_token3_value => nvl(l_total_billed, 0)
5768: );
5769: x_return_status := OKC_API.G_RET_STS_ERROR;
5770: END IF; -- IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_billed_amt,0),l_currency) >
5771: END IF; -- nvl(l_total_billed, 0) <> 0
5772: l_temp_total_billed := 0;
5773: END IF;
5774: --------------------------------------------------------------------

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

5922: */
5923: END LOOP; --end loop of rules_rec
5924:
5925: --Check for subline level element total equal to price negotiated
5926: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5927: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated, 0), l_currency))
5928: AND line_grp_rec.lse_id <> 13)
5929: THEN
5930:

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

5923: END LOOP; --end loop of rules_rec
5924:
5925: --Check for subline level element total equal to price negotiated
5926: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_amt, 0), l_currency) <>
5927: oks_extwar_util_pvt.round_currency_amt(NVL(line_grp_rec.price_negotiated, 0), l_currency))
5928: AND line_grp_rec.lse_id <> 13)
5929: THEN
5930:
5931: -- store SQL error message on message stack

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

5987: ELSIF l_price_negotiated < 0 AND l_temp_total_billed > 0 THEN
5988: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
5989: END IF;
5990:
5991: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
5992: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
5993:
5994: THEN
5995: OKC_API.SET_MESSAGE

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

5988: l_price_negotiated := abs(l_price_negotiated) + l_temp_total_billed;
5989: END IF;
5990:
5991: IF (oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed, 0), l_currency) >
5992: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated, 0), l_currency))
5993:
5994: THEN
5995: OKC_API.SET_MESSAGE
5996: (

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

6003: p_token3 => 'TOKEN3',
6004: p_token3_value => nvl(l_total_billed, 0)
6005: );
6006: x_return_status := OKC_API.G_RET_STS_ERROR;
6007: END IF; -- IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_lvl_total_billed_amt,0),l_currency) >
6008: END IF; -- nvl(l_total_billed, 0) <> 0
6009: END IF; -- line_grp_rec.lse_id <> 13
6010: /*
6011: --Check for price negotiated should not less than billed amount

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

6019: l_temp_total_billed := abs(l_temp_total_billed);
6020: l_price_negotiated := abs(l_price_negotiated);
6021: END If;
6022:
6023: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed ,0),l_currency) >
6024: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated,0),l_currency))
6025: AND line_grp_rec.lse_id <> 13)
6026: THEN
6027:

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

6020: l_price_negotiated := abs(l_price_negotiated);
6021: END If;
6022:
6023: IF ((oks_extwar_util_pvt.round_currency_amt(NVL(l_temp_total_billed ,0),l_currency) >
6024: oks_extwar_util_pvt.round_currency_amt(NVL(l_price_negotiated,0),l_currency))
6025: AND line_grp_rec.lse_id <> 13)
6026: THEN
6027:
6028: -- store SQL error message on message stack

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

6069: -- l_sub_line_price_nego_tot := l_sub_line_price_nego_tot + NVL(line_grp_rec.price_negotiated,0);
6070: -- Compares each sub line price negotiated to sum of level elements for that subline.
6071: /*
6072: IF (l_ETP_flag = 'E' AND top_line_grp_rec.lse_id <> 12)
6073: and (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:
6076: THEN
6077:

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

6070: -- Compares each sub line price negotiated to sum of level elements for that subline.
6071: /*
6072: IF (l_ETP_flag = 'E' AND top_line_grp_rec.lse_id <> 12)
6073: and (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:
6076: THEN
6077:
6078: OKC_API.SET_MESSAGE