1193: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);
1194: END IF;
1195:
1196: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1197: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1198:
1199:
1200: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1201: (
1275: END IF;
1276:
1277: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1278: IF (l_code <> 'ONE') THEN
1279: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1280: END IF;
1281:
1282: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1283: (
1387: END IF;
1388:
1389: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1390: IF (l_code <> 'ONE') THEN
1391: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1392: END IF;
1393: OPEN C_extended(p_header_id,p_line_id,p_line_number,l_code);
1394:
1395: LOOP-- inner loop added abghosh
1534: LOOP
1535: FETCH c_charge_periodicity INTO l_code;
1536: EXIT WHEN c_charge_periodicity%NOTFOUND;
1537: G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code := l_code;
1538: G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1539: G_RECURRING_AMOUNTS_TBL(i).recurring_amount := OE_HEADER_ADJ_UTIL.Get_Rec_Order_Adj_Total(l_header_id, p_price_adjustment_id, l_code);
1540:
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('***************************************************************');