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 1529: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),

1525: p_effective_date );
1526: */
1527:
1528: IF CtxNameByPos(pos_balance_date) is not null then
1529: pay_balance_pkg.set_context(CtxNameByPos(pos_balance_date),
1530: CtxValueByPos(pos_balance_date));
1531: END IF;
1532:
1533: IF CtxNameByPos(pos_tax_unit_id) is not null then

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

1530: CtxValueByPos(pos_balance_date));
1531: END IF;
1532:
1533: IF CtxNameByPos(pos_tax_unit_id) is not null then
1534: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_unit_id),
1535: CtxValueByPos(pos_tax_unit_id));
1536: END IF;
1537:
1538: IF CtxNameByPos(pos_jurisdiction_code) is not null then

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

1535: CtxValueByPos(pos_tax_unit_id));
1536: END IF;
1537:
1538: IF CtxNameByPos(pos_jurisdiction_code) is not null then
1539: pay_balance_pkg.set_context(CtxNameByPos(pos_jurisdiction_code),
1540: CtxValueByPos(pos_jurisdiction_code));
1541: END IF;
1542:
1543: /*

Line 1550: pay_balance_pkg.set_context('SOURCE_ID',

1546: OPEN csr_context_exists;
1547: FETCH csr_context_exists INTO l_temp_num;
1548: IF csr_context_exists%FOUND THEN
1549: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1550: pay_balance_pkg.set_context('SOURCE_ID',
1551: NULL);
1552: ELSE
1553: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1554: CtxValueByPos(pos_source_id));

Line 1553: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),

1549: IF NOT CtxValueByPos_is_found(pos_source_id) THEN
1550: pay_balance_pkg.set_context('SOURCE_ID',
1551: NULL);
1552: ELSE
1553: pay_balance_pkg.set_context(CtxNameByPos(pos_source_id),
1554: CtxValueByPos(pos_source_id));
1555:
1556: END IF;
1557:

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

1558: END IF;
1559: CLOSE csr_context_exists;
1560:
1561: IF CtxNameByPos(pos_tax_group) is not null then
1562: pay_balance_pkg.set_context(CtxNameByPos(pos_tax_group),
1563: CtxValueByPos(pos_tax_group));
1564: END IF;
1565:
1566: IF CtxNameByPos(pos_date_earned) is not null then

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

1563: CtxValueByPos(pos_tax_group));
1564: END IF;
1565:
1566: IF CtxNameByPos(pos_date_earned) is not null then
1567: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1568: CtxValueByPos(pos_date_earned));
1569: END IF;
1570:
1571: balance := pay_balance_pkg.get_value(

Line 1571: balance := pay_balance_pkg.get_value(

1567: pay_balance_pkg.set_context(CtxNameByPos(pos_date_earned),
1568: CtxValueByPos(pos_date_earned));
1569: END IF;
1570:
1571: balance := pay_balance_pkg.get_value(
1572: p_defined_balance_id => p_defined_balance_id
1573: ,p_assignment_action_id => p_assignment_action_id
1574: ,p_get_rr_route => l_run_route_bool
1575: ,p_get_rb_route => FALSE);