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