DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PAY_BALANCE_PKG

Line 1359: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),

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

Line 1364: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),

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

Line 1369: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),

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: /*

Line 1380: pay_balance_pkg.set_context('SOURCE_ID',

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));

Line 1383: pay_balance_pkg.set_context(CtxNameByPos(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:

Line 1393: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),

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

Line 1398: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),

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:

Line 1403: balance := pay_balance_pkg.get_value(

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);

Line 1445: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),

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

Line 1450: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),

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

Line 1455: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),

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: /*

Line 1466: pay_balance_pkg.set_context('SOURCE_ID',

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));

Line 1469: pay_balance_pkg.set_context(CtxNameByPos(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:

Line 1478: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),

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

Line 1483: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),

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(

Line 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);

Line 1517: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),

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

Line 1522: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),

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

Line 1527: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),

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: /*

Line 1538: pay_balance_pkg.set_context('SOURCE_ID',

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));

Line 1541: pay_balance_pkg.set_context(CtxNameByPos(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:

Line 1550: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),

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

Line 1555: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),

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(

Line 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);