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_IE_CESS_REPORT dependencies on PAY_IE_CESS_REPORT

Line 1: package body pay_ie_cess_report as

1: package body pay_ie_cess_report as
2: /* $Header: pyiecess.pkb 120.9.12020000.2 2012/07/06 10:48:28 vmaripal ship $ */
3: g_package CONSTANT VARCHAR2(30) := 'pay_ie_cess_report.';
4: EOL VARCHAR2(5) := fnd_global.local_chr(10);
5: g_archive_pact NUMBER;

Line 3: g_package CONSTANT VARCHAR2(30) := 'pay_ie_cess_report.';

1: package body pay_ie_cess_report as
2: /* $Header: pyiecess.pkb 120.9.12020000.2 2012/07/06 10:48:28 vmaripal ship $ */
3: g_package CONSTANT VARCHAR2(30) := 'pay_ie_cess_report.';
4: EOL VARCHAR2(5) := fnd_global.local_chr(10);
5: g_archive_pact NUMBER;
6: g_archive_effective_date DATE;
7: g_archive_start_date DATE;

Line 54: Hr_Utility.set_location('Entering: pay_ie_cess_report.c2b',260);

50: buffer RAW( 32767 );
51: res BLOB;
52: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
53: BEGIN
54: Hr_Utility.set_location('Entering: pay_ie_cess_report.c2b',260);
55: DBMS_LOB.createTemporary( res, TRUE );
56: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
57:
58:

Line 70: Hr_Utility.set_location('Leaving: pay_ie_cess_report.c2b',265);

66: pos := pos + 16000;
67: EXIT WHEN pos > lob_len;
68: END LOOP;
69:
70: Hr_Utility.set_location('Leaving: pay_ie_cess_report.c2b',265);
71: RETURN res; -- res is OPEN here
72: END c2b;
73:
74: PROCEDURE get_parameters(p_payroll_action_id IN NUMBER,

Line 1531: pay_ie_cess_report.get_parameters (

1527: BEGIN
1528: -- hr_utility.trace_on(null,'cess');
1529: hr_utility.set_location('Entering ' || l_proc,10);
1530:
1531: pay_ie_cess_report.get_parameters (
1532: p_payroll_action_id => pactid
1533: , p_token_name => 'END_DATE'
1534: , p_token_value => l_end_date);
1535:

Line 1536: pay_ie_cess_report.get_parameters (

1532: p_payroll_action_id => pactid
1533: , p_token_name => 'END_DATE'
1534: , p_token_value => l_end_date);
1535:
1536: pay_ie_cess_report.get_parameters (
1537: p_payroll_action_id => pactid
1538: , p_token_name => 'BG_ID'
1539: , p_token_value => l_bg_id);
1540:

Line 1541: pay_ie_cess_report.get_parameters (

1537: p_payroll_action_id => pactid
1538: , p_token_name => 'BG_ID'
1539: , p_token_value => l_bg_id);
1540:
1541: pay_ie_cess_report.get_parameters (
1542: p_payroll_action_id => pactid
1543: , p_token_name => 'EMPLOYER'
1544: , p_token_value => l_employer);
1545:

Line 1546: pay_ie_cess_report.get_parameters (

1542: p_payroll_action_id => pactid
1543: , p_token_name => 'EMPLOYER'
1544: , p_token_value => l_employer);
1545:
1546: pay_ie_cess_report.get_parameters (
1547: p_payroll_action_id => pactid
1548: , p_token_name => 'START_DATE'
1549: , p_token_value => l_start_date);
1550:

Line 1774: pay_ie_cess_report.get_parameters (

1770: BEGIN
1771:
1772: --hr_utility.trace_on(null,'cess');
1773: hr_utility.set_location('Entering ' || l_proc,10);
1774: pay_ie_cess_report.get_parameters (
1775: p_payroll_action_id => pactid
1776: , p_token_name => 'EMPLOYER'
1777: , p_token_value => g_paye_ref);
1778:

Line 1779: pay_ie_cess_report.get_parameters (

1775: p_payroll_action_id => pactid
1776: , p_token_name => 'EMPLOYER'
1777: , p_token_value => g_paye_ref);
1778:
1779: pay_ie_cess_report.get_parameters (
1780: p_payroll_action_id => pactid
1781: , p_token_name => 'END_DATE'
1782: , p_token_value => l_end_date);
1783:

Line 1784: pay_ie_cess_report.get_parameters (

1780: p_payroll_action_id => pactid
1781: , p_token_name => 'END_DATE'
1782: , p_token_value => l_end_date);
1783:
1784: pay_ie_cess_report.get_parameters (
1785: p_payroll_action_id => pactid
1786: , p_token_name => 'BG_ID'
1787: , p_token_value => l_bg_id);
1788:

Line 1789: pay_ie_cess_report.get_parameters (

1785: p_payroll_action_id => pactid
1786: , p_token_name => 'BG_ID'
1787: , p_token_value => l_bg_id);
1788:
1789: pay_ie_cess_report.get_parameters (
1790: p_payroll_action_id => pactid
1791: , p_token_name => 'START_DATE'
1792: , p_token_value => l_start_date);
1793:

Line 1794: pay_ie_cess_report.get_parameters (

1790: p_payroll_action_id => pactid
1791: , p_token_name => 'START_DATE'
1792: , p_token_value => l_start_date);
1793:
1794: pay_ie_cess_report.get_parameters (
1795: p_payroll_action_id => pactid
1796: , p_token_name => 'PAYROLL'
1797: , p_token_value => l_payroll_id);
1798:

Line 1799: pay_ie_cess_report.get_parameters (

1795: p_payroll_action_id => pactid
1796: , p_token_name => 'PAYROLL'
1797: , p_token_value => l_payroll_id);
1798:
1799: pay_ie_cess_report.get_parameters (
1800: p_payroll_action_id => pactid
1801: , p_token_name => 'EMPLOYEE'
1802: , p_token_value => l_employee_person_id); /* knadhan */
1803:

Line 1958: pay_ie_cess_report.get_parameters (

1954: FETCH csr_archive_effective_date
1955: INTO g_archive_effective_date;
1956: CLOSE csr_archive_effective_date;
1957:
1958: pay_ie_cess_report.get_parameters (
1959: p_payroll_action_id => p_payroll_action_id
1960: , p_token_name => 'EMPLOYER'
1961: , p_token_value => g_paye_ref);
1962:

Line 1963: pay_ie_cess_report.get_parameters (

1959: p_payroll_action_id => p_payroll_action_id
1960: , p_token_name => 'EMPLOYER'
1961: , p_token_value => g_paye_ref);
1962:
1963: pay_ie_cess_report.get_parameters (
1964: p_payroll_action_id => p_payroll_action_id
1965: , p_token_name => 'END_DATE'
1966: , p_token_value => l_end_date);
1967:

Line 1968: pay_ie_cess_report.get_parameters (

1964: p_payroll_action_id => p_payroll_action_id
1965: , p_token_name => 'END_DATE'
1966: , p_token_value => l_end_date);
1967:
1968: pay_ie_cess_report.get_parameters (
1969: p_payroll_action_id => p_payroll_action_id
1970: , p_token_name => 'START_DATE'
1971: , p_token_value => l_start_date);
1972:

Line 1973: pay_ie_cess_report.get_parameters (

1969: p_payroll_action_id => p_payroll_action_id
1970: , p_token_name => 'START_DATE'
1971: , p_token_value => l_start_date);
1972:
1973: pay_ie_cess_report.get_parameters (
1974: p_payroll_action_id => p_payroll_action_id
1975: , p_token_name => 'BG_ID'
1976: , p_token_value => l_bg_id);
1977:

Line 2334: pay_ie_cess_report.archive_cess_info(

2330: lockingactid => l_actid
2331: , lockedactid => l_child_pay_action);
2332: END IF;
2333:
2334: pay_ie_cess_report.archive_cess_info(
2335: p_action_context_id => p_assactid,
2336: p_assignment_id => csr_rec.assignment_id, -- assignment_id
2337: p_payroll_id => l_payroll_id,
2338: p_date_earned => csr_rec.effective_date, -- date earned 9337590

Line 2386: hr_utility.set_location('Inside pay_ie_cess_report.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);

2382: l_proc := g_package || 'gen_header_xml';
2383: hr_utility.set_location ('Entering '||l_proc,1500);
2384:
2385: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2386: hr_utility.set_location('Inside pay_ie_cess_report.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
2387:
2388:
2389:
2390:

Line 2491: hr_utility.set_location(' Entering: pay_ie_cess_report.gen_body_xml: ', 270);

2487:
2488:
2489:
2490: BEGIN
2491: hr_utility.set_location(' Entering: pay_ie_cess_report.gen_body_xml: ', 270);
2492:
2493: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2494: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2495: