eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_CA_BALANCE_VIEW_PKG

Line 487: pay_ca_balance_view_pkg.get_value

483: p_start_date,
484: p_effective_date) LOOP
485: hr_utility.trace(l_routine_name||': 60');
486: l_balance_value := l_balance_value +
487: pay_ca_balance_view_pkg.get_value
488: (p_assignment_action_id => r_asg.assignment_action_id,
489: p_defined_balance_id => l_lb_defined_balance_id,
490: p_dont_cache => 1,
491: p_always_get_dbi => 0);

Line 504: pay_ca_balance_view_pkg.get_value

500: p_start_date,
501: p_effective_date) LOOP
502: hr_utility.trace(l_routine_name||': 70');
503: l_balance_value := l_balance_value +
504: pay_ca_balance_view_pkg.get_value
505: (p_assignment_action_id => r_asg.assignment_action_id,
506: p_defined_balance_id => l_lb_defined_balance_id,
507: p_dont_cache => 1,
508: p_always_get_dbi => 0);

Line 527: pay_ca_balance_view_pkg.get_value

523: p_start_date,
524: p_effective_date) LOOP
525: hr_utility.trace(l_routine_name||': 110');
526: l_balance_value := l_balance_value +
527: pay_ca_balance_view_pkg.get_value
528: (p_assignment_action_id => r_asg.assignment_action_id,
529: p_defined_balance_id => l_lb_defined_balance_id,
530: p_dont_cache => 1,
531: p_always_get_dbi => 0);

Line 544: pay_ca_balance_view_pkg.get_value

540: p_start_date,
541: p_effective_date) LOOP
542: hr_utility.trace(l_routine_name||': 120');
543: l_balance_value := l_balance_value +
544: pay_ca_balance_view_pkg.get_value
545: (p_assignment_action_id => r_asg.assignment_action_id,
546: p_defined_balance_id => l_lb_defined_balance_id,
547: p_dont_cache => 1,
548: p_always_get_dbi => 0);

Line 825: pay_ca_balance_view_pkg.get_value

821: p_effective_date,
822: l_ge_def_bal_id) LOOP
823: hr_utility.trace(l_routine_name||': 60');
824: l_balance_value := l_balance_value +
825: pay_ca_balance_view_pkg.get_value
826: (p_assignment_action_id => r_asg.assignment_action_id,
827: p_defined_balance_id => l_lb_defined_balance_id,
828: p_dont_cache => 1,
829: p_always_get_dbi => 0);

Line 842: pay_ca_balance_view_pkg.get_value

838: p_start_date,
839: p_effective_date) LOOP
840: hr_utility.trace(l_routine_name||': 70');
841: l_balance_value := l_balance_value +
842: pay_ca_balance_view_pkg.get_value
843: (p_assignment_action_id => r_asg.assignment_action_id,
844: p_defined_balance_id => l_lb_defined_balance_id,
845: p_dont_cache => 1,
846: p_always_get_dbi => 0);

Line 866: pay_ca_balance_view_pkg.get_value

862: p_effective_date,
863: l_ge_def_bal_id) LOOP
864: hr_utility.trace(l_routine_name||': 110');
865: l_balance_value := l_balance_value +
866: pay_ca_balance_view_pkg.get_value
867: (p_assignment_action_id => r_asg.assignment_action_id,
868: p_defined_balance_id => l_lb_defined_balance_id,
869: p_dont_cache => 1,
870: p_always_get_dbi => 0);

Line 884: pay_ca_balance_view_pkg.get_value

880: p_effective_date,
881: l_ge_def_bal_id) LOOP
882: hr_utility.trace(l_routine_name||': 120');
883: l_balance_value := l_balance_value +
884: pay_ca_balance_view_pkg.get_value
885: (p_assignment_action_id => r_asg.assignment_action_id,
886: p_defined_balance_id => l_lb_defined_balance_id,
887: p_dont_cache => 1,
888: p_always_get_dbi => 0);

Line 1263: l_balance_value := pay_ca_balance_view_pkg.get_value

1259: /*
1260: * No latest balances found so calculate the group level balance from
1261: * first principles
1262: */
1263: l_balance_value := pay_ca_balance_view_pkg.get_value
1264: (p_assignment_id,
1265: p_gl_defined_balance_id,
1266: p_effective_date);
1267:

Line 1288: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,

1284: p_effective_date,
1285: l_date_mask);
1286: END IF;
1287: l_balance_value := l_balance_value +
1288: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,
1289: l_lb_defined_balance_id,
1290: l_virtual_date,
1291: 1); /*turn caching off*/
1292: END LOOP;

Line 1303: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,

1299: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1300: p_effective_date,
1301: l_date_mask);
1302: l_balance_value := l_balance_value +
1303: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,
1304: l_lb_defined_balance_id,
1305: l_virtual_date,
1306: 1); /*turn caching off*/
1307: END LOOP;

Line 1323: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,

1319: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1320: p_effective_date,
1321: l_date_mask);
1322: l_balance_value := l_balance_value +
1323: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,
1324: l_lb_defined_balance_id,
1325: l_virtual_date,
1326: 1); /*turn caching off*/
1327: END LOOP;

Line 1342: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,

1338: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1339: p_effective_date,
1340: l_date_mask);
1341: l_balance_value := l_balance_value +
1342: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,
1343: l_lb_defined_balance_id,
1344: l_virtual_date,
1345: 1); /*turn caching off*/
1346: END LOOP;

Line 1368: pay_ca_balance_view_pkg.get_value

1364: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1365: p_effective_date,
1366: l_date_mask);
1367: l_balance_value := l_balance_value +
1368: pay_ca_balance_view_pkg.get_value
1369: (p_assignment_id => r_asg.assignment_id,
1370: p_defined_balance_id => l_lb_defined_balance_id,
1371: p_effective_date => l_virtual_date,
1372: p_dont_cache => 1); /* turn caching off */

Line 1384: pay_ca_balance_view_pkg.get_value

1380: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1381: p_effective_date,
1382: l_date_mask);
1383: l_balance_value := l_balance_value +
1384: pay_ca_balance_view_pkg.get_value
1385: (p_assignment_id => r_asg.assignment_id,
1386: p_defined_balance_id => l_lb_defined_balance_id,
1387: p_effective_date => l_virtual_date,
1388: p_dont_cache => 1); /* turn caching off */

Line 1405: pay_ca_balance_view_pkg.get_value

1401: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1402: p_effective_date,
1403: l_date_mask);
1404: l_balance_value := l_balance_value +
1405: pay_ca_balance_view_pkg.get_value
1406: (p_assignment_id => r_asg.assignment_id,
1407: p_defined_balance_id => l_lb_defined_balance_id,
1408: p_effective_date => l_virtual_date,
1409: p_dont_cache => 1); /* turn caching off */

Line 1425: pay_ca_balance_view_pkg.get_value

1421: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1422: p_effective_date,
1423: l_date_mask);
1424: l_balance_value := l_balance_value +
1425: pay_ca_balance_view_pkg.get_value
1426: (p_assignment_id => r_asg.assignment_id,
1427: p_defined_balance_id => l_lb_defined_balance_id,
1428: p_effective_date => l_virtual_date,
1429: p_dont_cache => 1); /* turn caching off */

Line 1824: l_balance_value := pay_ca_balance_view_pkg.get_value

1820: /*
1821: * No latest balances found so calculate the group level balance from
1822: * first principles
1823: */
1824: l_balance_value := pay_ca_balance_view_pkg.get_value
1825: (p_assignment_id,
1826: p_gl_defined_balance_id,
1827: p_effective_date);
1828:

Line 1849: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,

1845: p_effective_date,
1846: l_date_mask);
1847: END IF;
1848: l_balance_value := l_balance_value +
1849: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,
1850: l_lb_defined_balance_id,
1851: l_virtual_date,
1852: 1); /*turn caching off*/
1853: END LOOP;

Line 1864: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,

1860: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1861: p_effective_date,
1862: l_date_mask);
1863: l_balance_value := l_balance_value +
1864: pay_ca_balance_view_pkg.get_value(r_asg.assignment_id,
1865: l_lb_defined_balance_id,
1866: l_virtual_date,
1867: 1); /*turn caching off*/
1868: END LOOP;

Line 1886: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,

1882: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1883: p_effective_date,
1884: l_date_mask);
1885: l_balance_value := l_balance_value +
1886: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,
1887: l_lb_defined_balance_id,
1888: l_virtual_date,
1889: 1); /*turn caching off*/
1890: END LOOP;

Line 1905: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,

1901: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1902: p_effective_date,
1903: l_date_mask);
1904: l_balance_value := l_balance_value +
1905: pay_ca_balance_view_pkg.get_value (r_asg.assignment_id,
1906: l_lb_defined_balance_id,
1907: l_virtual_date,
1908: 1); /*turn caching off*/
1909: END LOOP;

Line 1932: pay_ca_balance_view_pkg.get_value

1928: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1929: p_effective_date,
1930: l_date_mask);
1931: l_balance_value := l_balance_value +
1932: pay_ca_balance_view_pkg.get_value
1933: (p_assignment_id => r_asg.assignment_id,
1934: p_defined_balance_id => l_lb_defined_balance_id,
1935: p_effective_date => l_virtual_date,
1936: p_dont_cache => 1); /* turn caching off */

Line 1949: pay_ca_balance_view_pkg.get_value

1945: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1946: p_effective_date,
1947: l_date_mask);
1948: l_balance_value := l_balance_value +
1949: pay_ca_balance_view_pkg.get_value
1950: (p_assignment_id => r_asg.assignment_id,
1951: p_defined_balance_id => l_lb_defined_balance_id,
1952: p_effective_date => l_virtual_date,
1953: p_dont_cache => 1); /* turn caching off */

Line 1971: pay_ca_balance_view_pkg.get_value

1967: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1968: p_effective_date,
1969: l_date_mask);
1970: l_balance_value := l_balance_value +
1971: pay_ca_balance_view_pkg.get_value
1972: (p_assignment_id => r_asg.assignment_id,
1973: p_defined_balance_id => l_lb_defined_balance_id,
1974: p_effective_date => l_virtual_date,
1975: p_dont_cache => 1); /* turn caching off */

Line 1992: pay_ca_balance_view_pkg.get_value

1988: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1989: p_effective_date,
1990: l_date_mask);
1991: l_balance_value := l_balance_value +
1992: pay_ca_balance_view_pkg.get_value
1993: (p_assignment_id => r_asg.assignment_id,
1994: p_defined_balance_id => l_lb_defined_balance_id,
1995: p_effective_date => l_virtual_date,
1996: p_dont_cache => 1); /* turn caching off */

Line 2223: pay_ca_balance_view_pkg.set_context('DATE_EARNED',

2219: BEGIN
2220:
2221: /* hr_utility.trace_on(NULL,'ORASDR'); */
2222: hr_utility.trace('Starting routine: '||l_routine_name);
2223: pay_ca_balance_view_pkg.set_context('DATE_EARNED',
2224: fnd_date.date_to_canonical(p_effective_date));
2225:
2226: l_balance_name := p_balance_name;
2227:

Line 2249: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');

2245: END IF;
2246: ELSIF p_time_dimension = 'PYDATE' THEN
2247: hr_utility.trace(l_routine_name||': 20');
2248: IF p_start_date IS NULL THEN
2249: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');
2250: IF l_date_context IS NOT NULL THEN
2251: l_start_date := fnd_date.canonical_to_date(l_date_context);
2252: ELSE
2253: RAISE e_no_start_date_for_pydate;

Line 2257: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',

2253: RAISE e_no_start_date_for_pydate;
2254: END IF;
2255: ELSE
2256: l_start_date := p_start_date;
2257: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',
2258: fnd_date.date_to_canonical(p_start_date));
2259: END IF;
2260: ELSIF p_time_dimension = 'PTD' THEN
2261: hr_utility.trace(l_routine_name||': 25');

Line 2270: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',

2266:
2267: IF p_gre_id IS NOT NULL THEN
2268: hr_utility.trace(l_routine_name||': 30');
2269:
2270: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',
2271: p_gre_id);
2272:
2273: l_dim_str1 := 'GRE_';
2274:

Line 2377: pay_ca_balance_view_pkg.set_context('SOURCE_ID',

2373:
2374: ELSIF p_source_id IS NOT NULL THEN
2375: hr_utility.trace(l_routine_name||': 40');
2376:
2377: pay_ca_balance_view_pkg.set_context('SOURCE_ID',
2378: p_source_id);
2379:
2380: l_dim_str1 := 'RPT_UNIT_';
2381:

Line 2415: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',

2411: l_gl_dimension := l_dim_str1 || p_time_dimension;
2412: l_lb_dimension := 'ASG_' || l_gl_dimension;
2413: ELSE
2414: hr_utility.trace(l_routine_name||': 60');
2415: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',
2416: p_jurisdiction);
2417: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2418: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;
2419: END IF;

Line 2447: pay_ca_balance_view_pkg.get_value (l_assignment_id,

2443: * All of the balance parameters are contexts so we can just call PYDATE
2444: * This will not use latest balances.
2445: */
2446: l_balance_value :=
2447: pay_ca_balance_view_pkg.get_value (l_assignment_id,
2448: l_gl_defined_balance_id,
2449: p_effective_date);
2450: ELSE
2451: /*

Line 2771: pay_ca_balance_view_pkg.set_context('DATE_EARNED',

2767: ,p_pay_basis_type
2768: );
2769: Elsif p_flag = 'Y' then
2770: -- Process rb cursors to find assignments
2771: pay_ca_balance_view_pkg.set_context('DATE_EARNED',
2772: fnd_date.date_to_canonical(p_effective_date));
2773:
2774: l_balance_name := p_balance_name;
2775:

Line 2797: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');

2793: END IF;
2794: ELSIF p_time_dimension = 'PYDATE' THEN
2795: hr_utility.trace(l_routine_name||': 20');
2796: IF p_start_date IS NULL THEN
2797: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');
2798: IF l_date_context IS NOT NULL THEN
2799: l_start_date := fnd_date.canonical_to_date(l_date_context);
2800: ELSE
2801: RAISE e_no_start_date_for_pydate;

Line 2805: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',

2801: RAISE e_no_start_date_for_pydate;
2802: END IF;
2803: ELSE
2804: l_start_date := p_start_date;
2805: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',
2806: fnd_date.date_to_canonical(p_start_date));
2807: END IF;
2808: ELSIF p_time_dimension = 'PTD' THEN
2809: hr_utility.trace(l_routine_name||': 25');

Line 2818: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',

2814:
2815: IF p_gre_id IS NOT NULL THEN
2816: hr_utility.trace(l_routine_name||': 30');
2817:
2818: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',
2819: p_gre_id);
2820:
2821: l_dim_str1 := 'GRE_';
2822:

Line 2912: pay_ca_balance_view_pkg.set_context('SOURCE_ID',

2908:
2909: ELSIF p_source_id IS NOT NULL THEN
2910: hr_utility.trace(l_routine_name||': 40');
2911:
2912: pay_ca_balance_view_pkg.set_context('SOURCE_ID',
2913: p_source_id);
2914:
2915: l_dim_str1 := 'RPT_UNIT_';
2916:

Line 2969: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',

2965: l_gl_dimension := l_dim_str1 || p_time_dimension;
2966: l_lb_dimension := 'ASG_' || l_gl_dimension;
2967: ELSE
2968: hr_utility.trace(l_routine_name||': 60');
2969: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',
2970: p_jurisdiction);
2971: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2972: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;
2973: END IF;

Line 3005: hr_utility.trace('Calling pay_ca_balance_view_pkg.get_value ');

3001: /*
3002: * All of the balance parameters are contexts so we can just call PYDATE
3003: * This will not use latest balances.
3004: */
3005: hr_utility.trace('Calling pay_ca_balance_view_pkg.get_value ');
3006:
3007: hr_utility.trace('l_assignment_id :'||to_char(l_assignment_id));
3008: l_balance_value :=
3009: pay_ca_balance_view_pkg.get_value (l_assignment_id,

Line 3009: pay_ca_balance_view_pkg.get_value (l_assignment_id,

3005: hr_utility.trace('Calling pay_ca_balance_view_pkg.get_value ');
3006:
3007: hr_utility.trace('l_assignment_id :'||to_char(l_assignment_id));
3008: l_balance_value :=
3009: pay_ca_balance_view_pkg.get_value (l_assignment_id,
3010: l_gl_defined_balance_id,
3011: p_effective_date);
3012: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));
3013: ELSE