DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_YEER_PKG

Line 1: PACKAGE BODY pay_ca_yeer_pkg AS

1: PACKAGE BODY pay_ca_yeer_pkg AS
2: /* $Header: pycayeer.pkb 120.24.12020000.23 2012/12/03 12:52:22 sgotlasw ship $ */
3: --
4: /*
5: ******************************************************************

Line 21: Name : pay_ca_yeer_pkg

17: * 500 Oracle Parkway, Redwood City, CA, 94065. *
18: * *
19: ******************************************************************
20:
21: Name : pay_ca_yeer_pkg
22:
23: Description : Package for the Elements Reports. The package
24: generated the output file in the specified user
25: format. The current formats supported are

Line 219: gv_package_name VARCHAR2(50) := 'pay_ca_yeer_pkg';

215:
216: gv_html_start_data VARCHAR2(5) := '' ;
217: gv_html_end_data VARCHAR2(5) := '' ;
218:
219: gv_package_name VARCHAR2(50) := 'pay_ca_yeer_pkg';
220:
221: sv_date varchar2(20) := ' ';
222: sv_page number(4) := 0;
223:

Line 1578: if ( not pay_ca_yeer_pkg.validateSIN(sv_dbi(i).dbi_value)) and sv_dbi(i).dbi_value is not null then /* Bug 6773615 sbachu*/

1574: sv_col(sv_c) := upper(sv_dbi(i).dbi_short_name);
1575: sv_print := 1;
1576: end if;
1577:
1578: if ( not pay_ca_yeer_pkg.validateSIN(sv_dbi(i).dbi_value)) and sv_dbi(i).dbi_value is not null then /* Bug 6773615 sbachu*/
1579: sv_m := sv_m + 1;
1580: sv_msg(sv_m) := get_lookup_meaning('R_SIN_INVALID');
1581: sv_print := 1;
1582: end if;

Line 1900: if ( not pay_ca_yeer_pkg.validateSIN(lr_rl2_emprec.EMPLOYEE_SIN)) and lr_rl2_emprec.EMPLOYEE_SIN is not null then /* Bug 6773615 sbachu*/

1896: sv_col(sv_c) := upper('Sin');
1897: sv_print := 1;
1898: end if;
1899:
1900: if ( not pay_ca_yeer_pkg.validateSIN(lr_rl2_emprec.EMPLOYEE_SIN)) and lr_rl2_emprec.EMPLOYEE_SIN is not null then /* Bug 6773615 sbachu*/
1901: sv_m := sv_m + 1;
1902: sv_msg(sv_m) := get_lookup_meaning('R_SIN_INVALID');
1903: sv_print := 1;
1904: end if;

Line 2642: if ( not pay_ca_yeer_pkg.validateSIN(sv_dbi(i).dbi_value)) and sv_dbi(i).dbi_value is not null then /* Bug 6773615 sbachu*/

2638: sv_c := sv_c + 1;
2639: sv_col(sv_c) := upper(sv_dbi(i).dbi_short_name);
2640: sv_print := 1;
2641: end if;
2642: if ( not pay_ca_yeer_pkg.validateSIN(sv_dbi(i).dbi_value)) and sv_dbi(i).dbi_value is not null then /* Bug 6773615 sbachu*/
2643: sv_m := sv_m + 1;
2644: sv_msg(sv_m) := get_lookup_meaning('R_SIN_INVALID');
2645: sv_print := 1;
2646: end if;

Line 4444: end pay_ca_yeer_pkg;

4440: end if;
4441: format_data('');
4442: END pier_yeer;
4443:
4444: end pay_ca_yeer_pkg;