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: ******************************************************************
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
215:
216: gv_html_start_data VARCHAR2(5) := '
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;
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;
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;
4440: end if;
4441: format_data('