1351: --
1352: -- balance := goto_route( p_assignment_action_id, p_defined_balance_id );
1353:
1354: IF CtxNameByPos(pos_balance_date) is not null then
1355: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),
1356: CtxValueByPos(pos_balance_date));
1357: END IF;
1358:
1359: IF CtxNameByPos(pos_tax_unit_id) is not null then
1356: CtxValueByPos(pos_balance_date));
1357: END IF;
1358:
1359: IF CtxNameByPos(pos_tax_unit_id) is not null then
1360: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),
1361: CtxValueByPos(pos_tax_unit_id));
1362: END IF;
1363:
1364: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1361: CtxValueByPos(pos_tax_unit_id));
1362: END IF;
1363:
1364: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1365: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),
1366: CtxValueByPos(pos_jurisdiction_code));
1367: END IF;
1368:
1369: /*
1372: OPEN csr_context_exists;
1373: FETCH csr_context_exists INTO l_temp_num;
1374: IF csr_context_exists%FOUND THEN
1375: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1376: pay_balance_pkg.set_context('SOURCE_ID',
1377: NULL);
1378: ELSE
1379: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1380: CtxValueByPos(pos_source_id));
1375: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1376: pay_balance_pkg.set_context('SOURCE_ID',
1377: NULL);
1378: ELSE
1379: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1380: CtxValueByPos(pos_source_id));
1381:
1382: END IF;
1383:
1385: CLOSE csr_context_exists;
1386:
1387:
1388: IF CtxNameByPos(pos_tax_group) is not null then
1389: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),
1390: CtxValueByPos(pos_tax_group));
1391: END IF;
1392:
1393: IF CtxNameByPos(pos_date_earned) is not null then
1390: CtxValueByPos(pos_tax_group));
1391: END IF;
1392:
1393: IF CtxNameByPos(pos_date_earned) is not null then
1394: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1395: CtxValueByPos(pos_date_earned));
1396: END IF;
1397:
1398:
1395: CtxValueByPos(pos_date_earned));
1396: END IF;
1397:
1398:
1399: balance := pay_balance_pkg.get_value(
1400: p_defined_balance_id => p_defined_balance_id
1401: ,p_assignment_action_id => p_assignment_action_id
1402: ,p_get_rr_route => l_run_route_bool
1403: ,p_get_rb_route => FALSE);
1437: p_effective_date );
1438: */
1439:
1440: IF CtxNameByPos(pos_balance_date) is not null then
1441: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),
1442: CtxValueByPos(pos_balance_date));
1443: END IF;
1444:
1445: IF CtxNameByPos(pos_tax_unit_id) is not null then
1442: CtxValueByPos(pos_balance_date));
1443: END IF;
1444:
1445: IF CtxNameByPos(pos_tax_unit_id) is not null then
1446: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),
1447: CtxValueByPos(pos_tax_unit_id));
1448: END IF;
1449:
1450: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1447: CtxValueByPos(pos_tax_unit_id));
1448: END IF;
1449:
1450: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1451: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),
1452: CtxValueByPos(pos_jurisdiction_code));
1453: END IF;
1454:
1455: /*
1458: OPEN csr_context_exists;
1459: FETCH csr_context_exists INTO l_temp_num;
1460: IF csr_context_exists%FOUND THEN
1461: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1462: pay_balance_pkg.set_context('SOURCE_ID',
1463: NULL);
1464: ELSE
1465: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1466: CtxValueByPos(pos_source_id));
1461: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1462: pay_balance_pkg.set_context('SOURCE_ID',
1463: NULL);
1464: ELSE
1465: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1466: CtxValueByPos(pos_source_id));
1467:
1468: END IF;
1469:
1470: END IF;
1471: CLOSE csr_context_exists;
1472:
1473: IF CtxNameByPos(pos_tax_group) is not null then
1474: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),
1475: CtxValueByPos(pos_tax_group));
1476: END IF;
1477:
1478: IF CtxNameByPos(pos_date_earned) is not null then
1475: CtxValueByPos(pos_tax_group));
1476: END IF;
1477:
1478: IF CtxNameByPos(pos_date_earned) is not null then
1479: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1480: CtxValueByPos(pos_date_earned));
1481: END IF;
1482:
1483: balance := pay_balance_pkg.get_value(
1479: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1480: CtxValueByPos(pos_date_earned));
1481: END IF;
1482:
1483: balance := pay_balance_pkg.get_value(
1484: p_defined_balance_id => p_defined_balance_id
1485: ,p_assignment_action_id => p_assignment_action_id
1486: ,p_get_rr_route => l_run_route_bool
1487: ,p_get_rb_route => FALSE);
1509: p_effective_date );
1510: */
1511:
1512: IF CtxNameByPos(pos_balance_date) is not null then
1513: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),
1514: CtxValueByPos(pos_balance_date));
1515: END IF;
1516:
1517: IF CtxNameByPos(pos_tax_unit_id) is not null then
1514: CtxValueByPos(pos_balance_date));
1515: END IF;
1516:
1517: IF CtxNameByPos(pos_tax_unit_id) is not null then
1518: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),
1519: CtxValueByPos(pos_tax_unit_id));
1520: END IF;
1521:
1522: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1519: CtxValueByPos(pos_tax_unit_id));
1520: END IF;
1521:
1522: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1523: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),
1524: CtxValueByPos(pos_jurisdiction_code));
1525: END IF;
1526:
1527: /*
1530: OPEN csr_context_exists;
1531: FETCH csr_context_exists INTO l_temp_num;
1532: IF csr_context_exists%FOUND THEN
1533: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1534: pay_balance_pkg.set_context('SOURCE_ID',
1535: NULL);
1536: ELSE
1537: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1538: CtxValueByPos(pos_source_id));
1533: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1534: pay_balance_pkg.set_context('SOURCE_ID',
1535: NULL);
1536: ELSE
1537: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1538: CtxValueByPos(pos_source_id));
1539:
1540: END IF;
1541:
1542: END IF;
1543: CLOSE csr_context_exists;
1544:
1545: IF CtxNameByPos(pos_tax_group) is not null then
1546: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),
1547: CtxValueByPos(pos_tax_group));
1548: END IF;
1549:
1550: IF CtxNameByPos(pos_date_earned) is not null then
1547: CtxValueByPos(pos_tax_group));
1548: END IF;
1549:
1550: IF CtxNameByPos(pos_date_earned) is not null then
1551: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1552: CtxValueByPos(pos_date_earned));
1553: END IF;
1554:
1555: balance := pay_balance_pkg.get_value(
1551: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1552: CtxValueByPos(pos_date_earned));
1553: END IF;
1554:
1555: balance := pay_balance_pkg.get_value(
1556: p_defined_balance_id => p_defined_balance_id
1557: ,p_assignment_action_id => p_assignment_action_id
1558: ,p_get_rr_route => l_run_route_bool
1559: ,p_get_rb_route => FALSE);