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.16.12020000.2 2012/10/30 12:41:20 pkoduri ship $*/
3: /*
4: ******************************************************************
5: * *

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

102: /******************************************************************
103: ** private package global declarations
104: ******************************************************************/
105:
106: g_package VARCHAR2(50) := 'pay_1099r_pkg.';
107: g_debug boolean := FALSE;
108: g_print_instr VARCHAR2(1) := 'Y';
109:
110: ----------------------------------- range_cursor -------------------------------

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

122: --hr_utility.trace_on(null,'pyus109r');
123: hr_utility.trace('Before the range cursor');
124: hr_utility.trace('Entering :'||l_procedure_name);
125:
126: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
127: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
128: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
129: into ln_year,
130: ln_gre_id,

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

123: hr_utility.trace('Before the range cursor');
124: hr_utility.trace('Entering :'||l_procedure_name);
125:
126: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
127: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
128: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
129: into ln_year,
130: ln_gre_id,
131: ln_assign_set

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

124: hr_utility.trace('Entering :'||l_procedure_name);
125:
126: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
127: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
128: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
129: into ln_year,
130: ln_gre_id,
131: ln_assign_set
132: from pay_payroll_actions ppa

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

197: ln_gross_bal number;
198:
199:
200: cursor c_payroll_param (cp_pactid in number) is
201: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
202: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),

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

198:
199:
200: cursor c_payroll_param (cp_pactid in number) is
201: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
202: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),

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

199:
200: cursor c_payroll_param (cp_pactid in number) is
201: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
202: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
207: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),

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

200: cursor c_payroll_param (cp_pactid in number) is
201: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
202: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
207: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
208: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),

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

201: select to_number(pay_1099R_pkg.get_parameter('YEAR',ppa1.legislative_parameters)),
202: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
207: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
208: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
209: ppa.effective_date,

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

202: to_number(pay_1099R_pkg.get_parameter('TAX_ID',ppa1.legislative_parameters)),
203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
207: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
208: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
209: ppa.effective_date,
210: ppa.payroll_action_id,

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

203: to_number(pay_1099R_pkg.get_parameter('ORG_ID',ppa1.legislative_parameters)),
204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
207: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
208: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
209: ppa.effective_date,
210: ppa.payroll_action_id,
211: ppa.start_date,

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

204: to_number(pay_1099R_pkg.get_parameter('LOC_ID',ppa1.legislative_parameters)),
205: to_number(pay_1099R_pkg.get_parameter('PER_ID',ppa1.legislative_parameters)),
206: pay_1099R_pkg.get_parameter('SSN',ppa1.legislative_parameters),
207: pay_1099R_pkg.get_parameter('ST_COD',ppa1.legislative_parameters),
208: to_number(pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters)),
209: ppa.effective_date,
210: ppa.payroll_action_id,
211: ppa.start_date,
212: ppa1.effective_date,

Line 221: and pay_1099R_pkg.get_parameter

217: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
218: where ppa1.payroll_action_id = cp_pactid
219: and ppa.effective_date = ppa1.effective_date
220: and ppa.report_type = 'YREND'
221: and pay_1099R_pkg.get_parameter
222: ('TAX_ID',ppa1.legislative_parameters) =
223: pay_1099R_pkg.get_parameter
224: ('TRANSFER_GRE',ppa.legislative_parameters);
225:

Line 223: pay_1099R_pkg.get_parameter

219: and ppa.effective_date = ppa1.effective_date
220: and ppa.report_type = 'YREND'
221: and pay_1099R_pkg.get_parameter
222: ('TAX_ID',ppa1.legislative_parameters) =
223: pay_1099R_pkg.get_parameter
224: ('TRANSFER_GRE',ppa.legislative_parameters);
225:
226:
227: /* cursor c_payroll_param (cp_pactid in number) is

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

224: ('TRANSFER_GRE',ppa.legislative_parameters);
225:
226:
227: /* cursor c_payroll_param (cp_pactid in number) is
228: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
229: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

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

225:
226:
227: /* cursor c_payroll_param (cp_pactid in number) is
228: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
229: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),

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

226:
227: /* cursor c_payroll_param (cp_pactid in number) is
228: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
229: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
234: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),

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

227: /* cursor c_payroll_param (cp_pactid in number) is
228: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
229: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
234: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
235: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),

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

228: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
229: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
234: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
235: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
236: effective_date,

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

229: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
234: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
235: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
236: effective_date,
237: report_type,

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

230: pay_1099R_pkg.get_parameter('ORG_ID',ppa.legislative_parameters),
231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
234: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
235: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
236: effective_date,
237: report_type,
238: report_qualifier,

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

231: pay_1099R_pkg.get_parameter('LOC_ID',ppa.legislative_parameters),
232: pay_1099R_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
233: pay_1099R_pkg.get_parameter('SSN',ppa.legislative_parameters),
234: pay_1099R_pkg.get_parameter('ST_COD',ppa.legislative_parameters),
235: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters),
236: effective_date,
237: report_type,
238: report_qualifier,
239: report_category

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

1008: l_procedure_name := g_package||'sort_action';
1009: hr_utility.trace('Entering :'||l_procedure_name);
1010: hr_utility.trace('Beginning of the sort_action cursor');
1011: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
1012: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
1013: ppa.legislative_parameters)),'DD-MON-YYYY')
1014: into l_effective_date, l_session_date
1015: from pay_payroll_actions ppa
1016: where payroll_action_id = payactid;

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

1029: where ppa1.payroll_action_id = :pactid
1030: and paa1.payroll_action_id = ppa1.payroll_action_id
1031: and paa.assignment_action_id = paa1.serial_number
1032: order by
1033: decode(pay_1099R_pkg.get_parameter(''SORT_1'',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 1049: decode(pay_1099R_pkg.get_parameter(''SORT_2'',ppa1.legislative_parameters),

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

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

1062: hr_us_w2_rep.get_per_item( paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1063: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),
1064: null, null,
1065: substr(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),1,1))),
1066: decode(pay_1099R_pkg.get_parameter(''SORT_3'',ppa1.legislative_parameters),
1067: ''Employee_Name'',
1068: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_LAST_NAME'') ||
1069: hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_FIRST_NAME'') ||
1070: decode(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES'' ),

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

1126: P_NODE varchar2,
1127: P_DATA varchar2
1128: ) AS
1129:
1130: l_proc_name varchar2(100) := 'pay_1099r_pkg.load_xml';
1131: l_data varchar2(500);
1132: BEGIN
1133:
1134: hr_utility.trace('Entering : '||l_proc_name);

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

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

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

1169:
1170: ------------------------------ generate_footer_xml -------------------------------
1171:
1172: PROCEDURE generate_footer_xml is
1173: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_footer_xml';
1174:
1175: BEGIN
1176: hr_utility.trace('Entering : '||l_proc_name);
1177:

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

1375: PROCEDURE generate_detail_xml IS
1376:
1377: CURSOR csr_get_details (p_asg_actid in number) IS
1378: SELECT
1379: to_number(pay_1099R_pkg.get_parameter('YREND_PACTID',ppa.legislative_parameters)) yrend_pactid,
1380: to_number(paa.serial_number) fed_aaid,
1381: v1099r.year year,
1382: v1099r.gross_1099r gross_1099r,
1383: v1099r.wages_tips_compensation fit_subject,

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

1419:
1420:
1421: CURSOR c_parameters (asg_actid in NUMBER) IS
1422: SELECT ppa.legislative_parameters,
1423: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1424: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1425: FROM pay_payroll_actions ppa,
1426: pay_assignment_actions paa
1427: WHERE paa.assignment_action_id = asg_actid

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

1420:
1421: CURSOR c_parameters (asg_actid in NUMBER) IS
1422: SELECT ppa.legislative_parameters,
1423: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1424: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1425: FROM pay_payroll_actions ppa,
1426: pay_assignment_actions paa
1427: WHERE paa.assignment_action_id = asg_actid
1428: and ppa.payroll_action_id = paa.payroll_action_id;

Line 1665: end pay_1099R_pkg;

1661: --begin
1662:
1663: --hr_utility.trace_on(null, 'pyus109r');
1664:
1665: end pay_1099R_pkg;