DBA Data[Home] [Help]

APPS.PN_VAR_TRX_PKG dependencies on PNP_DEBUG_PKG

Line 1161: pnp_debug_pkg.log('');

1157: l_context VARCHAR2(255);
1158:
1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */

Line 1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');

1158:
1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */
1166: IF p_proration_rule IS NULL THEN

Line 1163: pnp_debug_pkg.log('');

1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */
1166: IF p_proration_rule IS NULL THEN
1167:

Line 1178: pnp_debug_pkg.log('VR ID: '||p_var_rent_id||

1174: l_vr_proration_rule := p_proration_rule;
1175:
1176: END IF;
1177:
1178: pnp_debug_pkg.log('VR ID: '||p_var_rent_id||
1179: ' Proration Rule: '||l_vr_proration_rule);
1180: pnp_debug_pkg.log('');
1181:
1182: l_counter1 := 1;

Line 1180: pnp_debug_pkg.log('');

1176: END IF;
1177:
1178: pnp_debug_pkg.log('VR ID: '||p_var_rent_id||
1179: ' Proration Rule: '||l_vr_proration_rule);
1180: pnp_debug_pkg.log('');
1181:
1182: l_counter1 := 1;
1183:
1184: /* fetch partial and full period details */

Line 1218: pnp_debug_pkg.log(l_context||' COMPLETE');

1214: l_counter1 := l_counter1 + 1;
1215:
1216: END LOOP;
1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);

Line 1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);

1215:
1216: END LOOP;
1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');

Line 1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);

1216: END LOOP;
1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:

Line 1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);

1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN

Line 1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);

1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN
1226:

Line 1223: pnp_debug_pkg.log('');

1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN
1226:
1227: l_context := 'CYP - update invoice_flag';

Line 1252: pnp_debug_pkg.log(l_context||' COMPLETE');

1248: var_rent_id = p_var_rent_id AND
1249: period_id IN (l_part_prd_id, l_full_prd_id)
1250: );
1251:
1252: pnp_debug_pkg.log(l_context||' COMPLETE');
1253: pnp_debug_pkg.log('');
1254:
1255:
1256: l_context := 'CYP - update pr_grp_blended_vol_start - end';

Line 1253: pnp_debug_pkg.log('');

1249: period_id IN (l_part_prd_id, l_full_prd_id)
1250: );
1251:
1252: pnp_debug_pkg.log(l_context||' COMPLETE');
1253: pnp_debug_pkg.log('');
1254:
1255:
1256: l_context := 'CYP - update pr_grp_blended_vol_start - end';
1257: /* reset pr_grp_blended_vol_start - pr_grp_blended_vol_end */

Line 1287: pnp_debug_pkg.log(l_context||' COMPLETE');

1283: var_rent_id = p_var_rent_id AND
1284: period_id IN (l_part_prd_id, l_full_prd_id)
1285: );
1286:
1287: pnp_debug_pkg.log(l_context||' COMPLETE');
1288: pnp_debug_pkg.log('');
1289:
1290: /* populate blended_period_vol_start - blended_period_vol_end */
1291: l_context := 'CYP - update blended_period_vol_start - end';

Line 1288: pnp_debug_pkg.log('');

1284: period_id IN (l_part_prd_id, l_full_prd_id)
1285: );
1286:
1287: pnp_debug_pkg.log(l_context||' COMPLETE');
1288: pnp_debug_pkg.log('');
1289:
1290: /* populate blended_period_vol_start - blended_period_vol_end */
1291: l_context := 'CYP - update blended_period_vol_start - end';
1292:

Line 1317: pnp_debug_pkg.log(l_context||' COMPLETE');

1313: bkpt_rate = cyp_rec.bkpt_rate;
1314:
1315: END LOOP;
1316:
1317: pnp_debug_pkg.log(l_context||' COMPLETE');
1318: pnp_debug_pkg.log('');
1319:
1320: ELSIF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYNP THEN
1321:

Line 1318: pnp_debug_pkg.log('');

1314:
1315: END LOOP;
1316:
1317: pnp_debug_pkg.log(l_context||' COMPLETE');
1318: pnp_debug_pkg.log('');
1319:
1320: ELSIF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYNP THEN
1321:
1322: l_context := 'CYNP - update invoice_flag';

Line 1348: pnp_debug_pkg.log(l_context||' COMPLETE');

1344: var_rent_id = p_var_rent_id AND
1345: period_id IN (l_part_prd_id, l_full_prd_id)
1346: );
1347:
1348: pnp_debug_pkg.log(l_context||' COMPLETE');
1349: pnp_debug_pkg.log('');
1350:
1351: l_context
1352: := 'CYNP - update pr_grp_blended_vol_start - end, blended_period_vol_start - end';

Line 1349: pnp_debug_pkg.log('');

1345: period_id IN (l_part_prd_id, l_full_prd_id)
1346: );
1347:
1348: pnp_debug_pkg.log(l_context||' COMPLETE');
1349: pnp_debug_pkg.log('');
1350:
1351: l_context
1352: := 'CYNP - update pr_grp_blended_vol_start - end, blended_period_vol_start - end';
1353: /* reset pr_grp_blended_vol_start - pr_grp_blended_vol_end */

Line 1401: pnp_debug_pkg.log(l_context||' COMPLETE');

1397: bkpt_rate = cynp_rec.bkpt_rate;
1398:
1399: END LOOP;
1400:
1401: pnp_debug_pkg.log(l_context||' COMPLETE');
1402: pnp_debug_pkg.log('');
1403:
1404: l_context
1405: := 'CYNP - update pr_grp_blended_vol_start - end for first/last partial';

Line 1402: pnp_debug_pkg.log('');

1398:
1399: END LOOP;
1400:
1401: pnp_debug_pkg.log(l_context||' COMPLETE');
1402: pnp_debug_pkg.log('');
1403:
1404: l_context
1405: := 'CYNP - update pr_grp_blended_vol_start - end for first/last partial';
1406:

Line 1451: pnp_debug_pkg.log(l_context||' COMPLETE');

1447: trx_header_id = last_part_rec.trx_header_id;
1448:
1449: END LOOP;
1450:
1451: pnp_debug_pkg.log(l_context||' COMPLETE');
1452: pnp_debug_pkg.log('');
1453:
1454: END IF;
1455:

Line 1452: pnp_debug_pkg.log('');

1448:
1449: END LOOP;
1450:
1451: pnp_debug_pkg.log(l_context||' COMPLETE');
1452: pnp_debug_pkg.log('');
1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');

Line 1456: pnp_debug_pkg.log('');

1452: pnp_debug_pkg.log('');
1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION

Line 1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');

1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN

Line 1458: pnp_debug_pkg.log('');

1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log

Line 1462: pnp_debug_pkg.log

1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log

Line 1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');

1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log
1467: ('**********************************************************************');
1468: RAISE;

Line 1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');

1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log
1467: ('**********************************************************************');
1468: RAISE;
1469:

Line 1466: pnp_debug_pkg.log

1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log
1467: ('**********************************************************************');
1468: RAISE;
1469:
1470: END populate_blended_grp_vol;

Line 2000: pnp_debug_pkg.log('Deleting for lines');

1996: IF p_line_item_id IS NOT NULL AND
1997: p_period_id IS NOT NULL AND
1998: p_var_rent_id IS NOT NULL
1999: THEN
2000: pnp_debug_pkg.log('Deleting for lines');
2001: DELETE
2002: pn_var_trx_details_all
2003: WHERE
2004: trx_header_id IN

Line 2025: pnp_debug_pkg.log('Deleting for periods');

2021: ELSIF p_line_item_id IS NULL AND
2022: p_period_id IS NOT NULL AND
2023: p_var_rent_id IS NOT NULL
2024: THEN
2025: pnp_debug_pkg.log('Deleting for periods');
2026: DELETE
2027: pn_var_trx_details_all
2028: WHERE
2029: trx_header_id IN

Line 2048: pnp_debug_pkg.log('Deleting for VR');

2044: ELSIF p_line_item_id IS NULL AND
2045: p_period_id IS NULL AND
2046: p_var_rent_id IS NOT NULL
2047: THEN
2048: pnp_debug_pkg.log('Deleting for VR');
2049: DELETE
2050: pn_var_trx_details_all
2051: WHERE
2052: trx_header_id IN

Line 2337: pnp_debug_pkg.log

2333: l_max_end_date DATE;
2334:
2335: BEGIN
2336:
2337: pnp_debug_pkg.log
2338: ('+++++++++++++ pn_var_trx_pkg.populate_transactions START +++++++++++++');
2339:
2340: /* lock the line items */
2341: l_line_items_lock4bkpt_t.DELETE;

Line 2737: pnp_debug_pkg.log('Trx updated');

2733: END LOOP; /* loop for all periods */
2734:
2735: /* get the grp IDs right if any trx was updated */
2736: IF l_trx_create_upd_flag THEN
2737: pnp_debug_pkg.log('Trx updated');
2738: /* groups the lines across the periods */
2739: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);
2740:
2741: /* populate the reset group IDs */

Line 2748: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);

2744: ly_pr_grp_vol_start - end,
2745: invoice_flag
2746: for FY, LY, FLY */
2747: FOR i in 1..for_data_t.COUNT LOOP
2748: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);

Line 2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);

2745: invoice_flag
2746: for FY, LY, FLY */
2747: FOR i in 1..for_data_t.COUNT LOOP
2748: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);

Line 2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);

2746: for FY, LY, FLY */
2747: FOR i in 1..for_data_t.COUNT LOOP
2748: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2754:

Line 2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);

2747: FOR i in 1..for_data_t.COUNT LOOP
2748: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2754:
2755: UPDATE

Line 2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);

2748: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2754:
2755: UPDATE
2756: pn_var_trx_headers_all

Line 2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);

2749: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2750: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2751: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2752: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2753: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2754:
2755: UPDATE
2756: pn_var_trx_headers_all
2757: SET

Line 3538: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');

3534: ytd_sales_t NUM_T;
3535:
3536: BEGIN
3537:
3538: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');
3539:
3540: /* get VR details */
3541: IF p_proration_rule IS NULL THEN
3542:

Line 3555: pnp_debug_pkg.log('Called with: ');

3551: l_proration_rule := p_proration_rule;
3552:
3553: END IF;
3554:
3555: pnp_debug_pkg.log('Called with: ');
3556: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3557: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3558:
3559: /* l_proration_rule based decisions */

Line 3556: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);

3552:
3553: END IF;
3554:
3555: pnp_debug_pkg.log('Called with: ');
3556: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3557: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3558:
3559: /* l_proration_rule based decisions */
3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

Line 3557: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);

3553: END IF;
3554:
3555: pnp_debug_pkg.log('Called with: ');
3556: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3557: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3558:
3559: /* l_proration_rule based decisions */
3560: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3561: ,pn_var_trx_pkg.G_PRORUL_LY

Line 5069: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');

5065: ytd_deductions_t NUM_T;
5066:
5067: BEGIN
5068:
5069: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');
5070:
5071: /* get VR details */
5072: IF p_proration_rule IS NULL THEN
5073:

Line 5086: pnp_debug_pkg.log('Called with: ');

5082: l_proration_rule := p_proration_rule;
5083:
5084: END IF;
5085:
5086: pnp_debug_pkg.log('Called with: ');
5087: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5088: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5089:
5090: /* l_proration_rule based decisions */

Line 5087: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);

5083:
5084: END IF;
5085:
5086: pnp_debug_pkg.log('Called with: ');
5087: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5088: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5089:
5090: /* l_proration_rule based decisions */
5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

Line 5088: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);

5084: END IF;
5085:
5086: pnp_debug_pkg.log('Called with: ');
5087: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5088: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5089:
5090: /* l_proration_rule based decisions */
5091: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5092: ,pn_var_trx_pkg.G_PRORUL_LY