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_1099R_PKG dependencies on PAY_1099R_PKG

Line 1: PACKAGE BODY PAY_1099R_PKG as

1: PACKAGE BODY PAY_1099R_PKG as
2: /* $Header: pyus109r.pkb 120.2.12000000.5 2007/09/21 09:12:40 vaprakas noship $*/
3: /*
4: ******************************************************************
5: * *

Line 90: g_package VARCHAR2(50) := 'pay_1099r_pkg.';

86: /******************************************************************
87: ** private package global declarations
88: ******************************************************************/
89:
90: g_package VARCHAR2(50) := 'pay_1099r_pkg.';
91: g_debug boolean := FALSE;
92: g_print_instr VARCHAR2(1) := 'Y';
93:
94: ----------------------------------- range_cursor -------------------------------

Line 110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),

106: --hr_utility.trace_on(null,'pyus109r');
107: hr_utility.trace('Before the range cursor');
108: hr_utility.trace('Entering :'||l_procedure_name);
109:
110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
111: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
112: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
113: into ln_year,
114: ln_gre_id,

Line 111: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),

107: hr_utility.trace('Before the range cursor');
108: hr_utility.trace('Entering :'||l_procedure_name);
109:
110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
111: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
112: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
113: into ln_year,
114: ln_gre_id,
115: ln_assign_set

Line 112: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)

108: hr_utility.trace('Entering :'||l_procedure_name);
109:
110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
111: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
112: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
113: into ln_year,
114: ln_gre_id,
115: ln_assign_set
116: from pay_payroll_actions ppa

Line 185: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),

181: ln_gross_bal number;
182:
183:
184: cursor c_payroll_param (cp_pactid in number) is
185: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),

Line 186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),

182:
183:
184: cursor c_payroll_param (cp_pactid in number) is
185: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),

Line 187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),

183:
184: cursor c_payroll_param (cp_pactid in number) is
185: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),

Line 188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),

184: cursor c_payroll_param (cp_pactid in number) is
185: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
192: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),

Line 189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),

185: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
192: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
193: ppa.effective_date,

Line 190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),

186: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
192: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
193: ppa.effective_date,
194: ppa.payroll_action_id,

Line 191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),

187: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
192: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
193: ppa.effective_date,
194: ppa.payroll_action_id,
195: ppa.start_date,

Line 192: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),

188: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
189: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
190: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
191: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
192: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
193: ppa.effective_date,
194: ppa.payroll_action_id,
195: ppa.start_date,
196: ppa1.effective_date,

Line 205: and pay_1099R_pkg.get_parameter

201: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
202: where ppa1.payroll_action_id = cp_pactid
203: and ppa.effective_date = ppa1.effective_date
204: and ppa.report_type = 'YREND'
205: and pay_1099R_pkg.get_parameter
206: ('TAX_ID',ppa1.legislative_parameters) =
207: pay_1099R_pkg.get_parameter
208: ('TRANSFER_GRE',ppa.legislative_parameters);
209:

Line 207: pay_1099R_pkg.get_parameter

203: and ppa.effective_date = ppa1.effective_date
204: and ppa.report_type = 'YREND'
205: and pay_1099R_pkg.get_parameter
206: ('TAX_ID',ppa1.legislative_parameters) =
207: pay_1099R_pkg.get_parameter
208: ('TRANSFER_GRE',ppa.legislative_parameters);
209:
210:
211: /* cursor c_payroll_param (cp_pactid in number) is

Line 212: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),

208: ('TRANSFER_GRE',ppa.legislative_parameters);
209:
210:
211: /* cursor c_payroll_param (cp_pactid in number) is
212: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

Line 213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),

209:
210:
211: /* cursor c_payroll_param (cp_pactid in number) is
212: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),

Line 214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),

210:
211: /* cursor c_payroll_param (cp_pactid in number) is
212: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),

Line 215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),

211: /* cursor c_payroll_param (cp_pactid in number) is
212: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
219: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),

Line 216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

212: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
219: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
220: effective_date,

Line 217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),

213: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
219: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
220: effective_date,
221: report_type,

Line 218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),

214: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
219: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
220: effective_date,
221: report_type,
222: report_qualifier,

Line 219: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),

215: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
216: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
217: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
218: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
219: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
220: effective_date,
221: report_type,
222: report_qualifier,
223: report_category

Line 996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',

992: l_procedure_name := g_package||'sort_action';
993: hr_utility.trace('Entering :'||l_procedure_name);
994: hr_utility.trace('Beginning of the sort_action cursor');
995: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
997: ppa.legislative_parameters)),'DD-MON-YYYY')
998: into l_effective_date, l_session_date
999: from pay_payroll_actions ppa
1000: where payroll_action_id = payactid;

Line 1017: decode(pay_1099R_pkg.get_parameter(''SORT_1'',ppa1.legislative_parameters),

1013: where ppa1.payroll_action_id = :pactid
1014: and paa1.payroll_action_id = ppa1.payroll_action_id
1015: and paa.assignment_action_id = paa1.serial_number
1016: order by
1017: decode(pay_1099R_pkg.get_parameter(''SORT_1'',ppa1.legislative_parameters),
1018: ''Employee_Name'',
1019: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_LAST_NAME'') ||
1020: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1021: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES'' ),

Line 1033: decode(pay_1099R_pkg.get_parameter(''SORT_2'',ppa1.legislative_parameters),

1029: hr_us_w2_rep.get_per_item( paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1030: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),
1031: null, null,
1032: substr(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),1,1))),
1033: decode(pay_1099R_pkg.get_parameter(''SORT_2'',ppa1.legislative_parameters),
1034: ''Employee_Name'',
1035: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_LAST_NAME'') ||
1036: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1037: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES'' ),

Line 1050: decode(pay_1099R_pkg.get_parameter(''SORT_3'',ppa1.legislative_parameters),

1046: hr_us_w2_rep.get_per_item( paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1047: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),
1048: null, null,
1049: substr(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),1,1))),
1050: decode(pay_1099R_pkg.get_parameter(''SORT_3'',ppa1.legislative_parameters),
1051: ''Employee_Name'',
1052: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_LAST_NAME'') ||
1053: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1054: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES'' ),

Line 1114: l_proc_name varchar2(100) := 'pay_1099r_pkg.load_xml';

1110: P_NODE varchar2,
1111: P_DATA varchar2
1112: ) AS
1113:
1114: l_proc_name varchar2(100) := 'pay_1099r_pkg.load_xml';
1115: l_data varchar2(500);
1116: BEGIN
1117:
1118: hr_utility.trace('Entering : '||l_proc_name);

Line 1141: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_header_xml';

1137:
1138: ------------------------------ generate_header_xml -------------------------------
1139: PROCEDURE generate_header_xml is
1140:
1141: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_header_xml';
1142:
1143: BEGIN
1144: hr_utility.trace('Entering : '||l_proc_name);
1145:

Line 1157: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_footer_xml';

1153:
1154: ------------------------------ generate_footer_xml -------------------------------
1155:
1156: PROCEDURE generate_footer_xml is
1157: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_footer_xml';
1158:
1159: BEGIN
1160: hr_utility.trace('Entering : '||l_proc_name);
1161:

Line 1363: to_number(pay_1099R_pkg.get_parameter('YREND_PACTID',ppa.legislative_parameters)) yrend_pactid,

1359: PROCEDURE generate_detail_xml IS
1360:
1361: CURSOR csr_get_details (p_asg_actid in number) IS
1362: SELECT
1363: to_number(pay_1099R_pkg.get_parameter('YREND_PACTID',ppa.legislative_parameters)) yrend_pactid,
1364: to_number(paa.serial_number) fed_aaid,
1365: v1099r.year year,
1366: v1099r.gross_1099r gross_1099r,
1367: v1099r.wages_tips_compensation fit_subject,

Line 1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),

1401:
1402:
1403: CURSOR c_parameters (asg_actid in NUMBER) IS
1404: SELECT ppa.legislative_parameters,
1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1406: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1407: FROM pay_payroll_actions ppa,
1408: pay_assignment_actions paa
1409: WHERE paa.assignment_action_id = asg_actid

Line 1406: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)

1402:
1403: CURSOR c_parameters (asg_actid in NUMBER) IS
1404: SELECT ppa.legislative_parameters,
1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1406: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1407: FROM pay_payroll_actions ppa,
1408: pay_assignment_actions paa
1409: WHERE paa.assignment_action_id = asg_actid
1410: and ppa.payroll_action_id = paa.payroll_action_id;

Line 1550: end pay_1099R_pkg;

1546: --begin
1547:
1548: --hr_utility.trace_on(null, 'pyus109r');
1549:
1550: end pay_1099R_pkg;