DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on PAY_BALANCE_PKG

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

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

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

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

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

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

Line 1376: pay_balance_pkg.set_context('SOURCE_ID',

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

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

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

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

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

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:

Line 1399: balance := pay_balance_pkg.get_value(

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

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

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

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

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

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

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

Line 1462: pay_balance_pkg.set_context('SOURCE_ID',

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

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

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

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

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

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(

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

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

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

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

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

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

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

Line 1534: pay_balance_pkg.set_context('SOURCE_ID',

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

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

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

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

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

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(

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