DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PAY_US_941_REPORT

Line 1: PACKAGE BODY PAY_US_941_REPORT AS

1: PACKAGE BODY PAY_US_941_REPORT AS
2: /* $Header: payus941report.pkb 120.28.12020000.3 2013/03/19 08:44:36 ybudamal ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_941_report

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_941_report
21:
22: Description : This package is called for the 941 Report to
23: generate the XML file.
24:

Line 43: 30-OCT-2006 alikhar 115.9 5479800 Added procedure pay_us_941_report_wrapper

39: 02-DEC-2005 rdhingra 115.5 4769835 Performance changes. Updated Cursor
40: c_count_asg_processed in procedure
41: get_941_balances
42: 06-APR-2006 pragupta 115.8 5117504 introduced tags YEAR1 and YEAR2.
43: 30-OCT-2006 alikhar 115.9 5479800 Added procedure pay_us_941_report_wrapper
44: 13-Mar-2009 skpatil 115.11 8267959 Removing addition of XML tags for Cobra values
45: 25-Mar-2009 skpatil 115.12 8267963 Adding code to submit FND_REQUEST based on
46: release.
47: 11-Mar-2010 vvijayku 115.13 9357061 Added code to split number into its integer and

Line 91: g_package VARCHAR2(100) := 'pay_us_941_report';

87: 2013.
88: ************************************************************************/
89: g_CP_STATUS VARCHAR2(20);
90: g_c_qtr_end_date DATE;
91: g_package VARCHAR2(100) := 'pay_us_941_report';
92:
93: /****************************************************************************
94: Name : SPLIT_NUMBER_INTO_INT_DECIMAL
95: Description : This function splits the given number into its integer and

Line 1518: Name : pay_us_941_report_wrapper

1514:
1515: END gen_941_report;
1516:
1517: /*****************************************************************************
1518: Name : pay_us_941_report_wrapper
1519: Purpose : calls procedure gen_941_report, generates xml output and submits
1520: xml publisher report to merge the xml output with template.
1521: *****************************************************************************/
1522: PROCEDURE pay_us_941_report_wrapper

Line 1522: PROCEDURE pay_us_941_report_wrapper

1518: Name : pay_us_941_report_wrapper
1519: Purpose : calls procedure gen_941_report, generates xml output and submits
1520: xml publisher report to merge the xml output with template.
1521: *****************************************************************************/
1522: PROCEDURE pay_us_941_report_wrapper
1523: ( errbuf OUT NOCOPY VARCHAR2,
1524: retcode OUT NOCOPY VARCHAR2,
1525: p_business_group_id IN NUMBER,
1526: p_tax_unit_id IN VARCHAR2,

Line 1552: l_procedure_name := '.pay_us_941_report_wrapper';

1548: l_procedure_name VARCHAR2(100);
1549:
1550: BEGIN
1551:
1552: l_procedure_name := '.pay_us_941_report_wrapper';
1553: hr_utility.set_location('Entering '|| g_package || l_procedure_name, 10);
1554:
1555: --Bug 8267963
1556: OPEN csr_release;

Line 1638: End pay_us_941_report_wrapper ;

1634: hr_utility.raise_error;
1635:
1636: hr_utility.set_location('Leaving '|| g_package || l_procedure_name, 20);
1637:
1638: End pay_us_941_report_wrapper ;
1639:
1640: END pay_us_941_report;
1641:
1642:

Line 1640: END pay_us_941_report;

1636: hr_utility.set_location('Leaving '|| g_package || l_procedure_name, 20);
1637:
1638: End pay_us_941_report_wrapper ;
1639:
1640: END pay_us_941_report;
1641:
1642:
1643: