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_US_PSD_XML dependencies on PAY_PAYROLL_ACTIONS

Line 181: token_val pay_payroll_actions.legislative_parameters%type;

177: parameter_list varchar2) return varchar2
178: is
179: start_ptr number;
180: end_ptr number;
181: token_val pay_payroll_actions.legislative_parameters%type;
182: par_value pay_payroll_actions.legislative_parameters%type;
183: begin
184: --
185: token_val := name||'=';

Line 182: par_value pay_payroll_actions.legislative_parameters%type;

178: is
179: start_ptr number;
180: end_ptr number;
181: token_val pay_payroll_actions.legislative_parameters%type;
182: par_value pay_payroll_actions.legislative_parameters%type;
183: begin
184: --
185: token_val := name||'=';
186: --

Line 395: FROM pay_payroll_actions ppa

391: p_state_abbrev,
392: p_report_type,
393: p_period_type,
394: p_tax_coll_dist_code
395: FROM pay_payroll_actions ppa
396: WHERE ppa.payroll_action_id = p_pactid;
397: --
398: select state_code into l_state_code
399: from pay_us_states pus

Line 406: FROM pay_payroll_actions ppa

402: p_state_code := l_state_code;
403: /* SELECT fnd_date.canonical_to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
404: 'TRANSFER_DATE'))
405: INTO p_period_end
406: FROM pay_payroll_actions ppa
407: WHERE ppa.payroll_action_id = p_pactid;*/
408:
409: SELECT to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
410: 'TRANSFER_DATE'), 'DD-MON-YYYY')

Line 412: FROM pay_payroll_actions ppa

408:
409: SELECT to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
410: 'TRANSFER_DATE'), 'DD-MON-YYYY')
411: INTO p_period_end
412: FROM pay_payroll_actions ppa
413: WHERE ppa.payroll_action_id = p_pactid;
414:
415: if (p_period_type='Quarterly') then
416: p_period_start:= trunc(p_period_end,'Q');

Line 592: pay_payroll_actions ppa

588: pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
589: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833
591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa
593: where ppa.payroll_action_id = paa.payroll_action_id
594: -- and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
595: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
596: and ppa.report_type in ('PSD_MAG_XML')

Line 608: pay_payroll_actions ppa

604: paa.assignment_action_id,
605: paa.assignment_id,
606: ppa.effective_date
607: FROM pay_assignment_actions paa,
608: pay_payroll_actions ppa
609: where ppa.payroll_action_id = paa.payroll_action_id
610: and paa.assignment_action_id = act_id--pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
611: and ppa.report_type ='YREND'
612: and ppa.action_type = 'X';

Line 618: FROM pay_payroll_actions ppa

614: CURSOR c_get_report_params_ytd IS
615: SELECT pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
616: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
617: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters)
618: FROM pay_payroll_actions ppa
619: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
620: and ppa.report_type in ('PSD_MAG_XML')
621: and ppa.action_type = 'X'
622: and ppa.action_status = 'P';

Line 627: pay_payroll_actions PA,

623:
624: CURSOR c_get_yepp_act_id IS
625: /* SELECT AA1.assignment_action_id
626: FROM pay_assignment_actions AA,
627: pay_payroll_actions PA,
628: pay_assignment_actions AA1,
629: pay_payroll_actions PA1
630: WHERE AA.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
631: AND AA.payroll_action_id = PA.payroll_action_id

Line 629: pay_payroll_actions PA1

625: /* SELECT AA1.assignment_action_id
626: FROM pay_assignment_actions AA,
627: pay_payroll_actions PA,
628: pay_assignment_actions AA1,
629: pay_payroll_actions PA1
630: WHERE AA.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
631: AND AA.payroll_action_id = PA.payroll_action_id
632: AND AA.tax_unit_id = AA1.tax_unit_id
633: AND AA1.assignment_id = AA.assignment_id

Line 841: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

837: message_text VARCHAR2(32000):= null;
838: message_preprocess VARCHAR2(2000) := null;
839: l_period_type varchar2(100);
840: l_transmitter number;
841: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
842: l_no_of_gres_picked NUMBER(15) := 0;
843: l_package_error_status char(1) := 'N';
844:
845: -- Cursor to get all the GREs belonging to the given business group

Line 868: from pay_payroll_actions ppa

864: ) OR
865: ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
866: 'TRANSFER_PERIOD_TYPE') = 'Yearly'
867: AND EXISTS ( select null
868: from pay_payroll_actions ppa
869: where to_number(substr(LEGISLATIVE_PARAMETERS,1,instr(LEGISLATIVE_PARAMETERS,' ',1)-1)) = puar.tax_unit_id
870: and ppa.report_type = 'YREND'
871: and ppa.effective_date = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
872: 'TRANSFER_DATE')

Line 926: FROM pay_payroll_actions

922: -- archived
923: CURSOR c_gre_payroll_action (cp_gre NUMBER)
924: IS
925: SELECT payroll_action_id
926: FROM pay_payroll_actions
927: WHERE report_type = 'YREND'
928: AND effective_date = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
929: 'TRANSFER_DATE')
930: AND business_group_id+0 = p_business_group_id

Line 942: from pay_payroll_actions ppa

938:
939:
940: select ppa.effective_date
941: into l_effective_date
942: from pay_payroll_actions ppa
943: where ppa.payroll_action_id=p_pactid;
944:
945: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
946: ,'TRANSFER_PERIOD_TYPE') into l_period_type

Line 1186: l_report_file_name pay_payroll_actions.magnetic_file_name%type;

1182: l_gre_name hr_all_organization_units.name%type;
1183: l_archive boolean:= FALSE;
1184: l_w2_reporting_rules_exist number;
1185: l_psd_reporting_rules_exist number;
1186: l_report_file_name pay_payroll_actions.magnetic_file_name%type;
1187: l_transfer_month_quarter varchar2(30);
1188: /* Local variables used for checking W2 and PSD Reporting Rules */
1189: message_text VARCHAR2(32000):= null;
1190: message_preprocess VARCHAR2(2000) := null;

Line 1242: update pay_payroll_actions

1238: );
1239:
1240: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 20);
1241:
1242: update pay_payroll_actions
1243: set effective_date = l_period_end
1244: WHERE payroll_action_id = p_pactid;
1245:
1246: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_TRANS_LEGAL_CO_ID',legislative_parameters)

Line 1248: FROM pay_payroll_actions

1244: WHERE payroll_action_id = p_pactid;
1245:
1246: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_TRANS_LEGAL_CO_ID',legislative_parameters)
1247: INTO l_trans_legal_co_id
1248: FROM pay_payroll_actions
1249: WHERE payroll_action_id = p_pactid;
1250:
1251: hr_utility.trace('l_trans_legal_co_id: '||l_trans_legal_co_id);
1252:

Line 1262: FROM pay_payroll_actions

1258: hr_utility.trace('Transmitter Name l_gre_name: '||l_gre_name);
1259:
1260: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_MONTH/QUARTER',legislative_parameters)
1261: INTO l_transfer_month_quarter
1262: FROM pay_payroll_actions
1263: WHERE payroll_action_id = p_pactid;
1264:
1265: hr_utility.trace('l_transfer_month_quarter: '||l_transfer_month_quarter);
1266:

Line 1275: FROM pay_payroll_actions

1271: hr_utility.trace('l_tax_coll_dist_code_or_all: '||l_tax_coll_dist_code_or_all);
1272:
1273: SELECT report_file_name
1274: INTO l_report_file_name
1275: FROM pay_payroll_actions
1276: WHERE payroll_action_id = p_pactid;
1277:
1278: /* The name of the report should be of the following format:
1279: Monthly: PSDPWLGRENMALLMMMDDYYYY_/PSDPWLGRENM012MMMDDYYYY_n_P.*

Line 1288: UPDATE pay_payroll_actions

1284:
1285: l_report_file_name:=l_report_file_name||upper(substr(replace(translate(l_gre_name,'`~!@#$%^&*-_=+{}()[]\|:;"'',.<>/?', ' '),' '),1,5))||l_tax_coll_dist_code_or_all||substr(l_period_type,1,1)||replace(to_char(l_period_end,'MM-DD-YYYY'),'-','');
1286: hr_utility.trace('l_report_file_name: '||l_report_file_name);
1287:
1288: UPDATE pay_payroll_actions
1289: SET report_file_name = l_report_file_name
1290: WHERE payroll_action_id = p_pactid;
1291:
1292: UPDATE pay_payroll_actions

Line 1292: UPDATE pay_payroll_actions

1288: UPDATE pay_payroll_actions
1289: SET report_file_name = l_report_file_name
1290: WHERE payroll_action_id = p_pactid;
1291:
1292: UPDATE pay_payroll_actions
1293: SET magnetic_file_name = l_report_file_name
1294: WHERE payroll_action_id = p_pactid;
1295:
1296: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 30);

Line 1347: pay_payroll_actions ppa,

1343: else
1344: --Modified for the Bug 15944697
1345: p_sqlstr := 'SELECT DISTINCT to_number(paa.serial_number)
1346: FROM pay_assignment_actions paa,
1347: pay_payroll_actions ppa,
1348: per_all_assignments_f paf,
1349: pay_payroll_actions ppa1,
1350: pay_us_asg_reporting puar,
1351: pay_state_rules SR

Line 1349: pay_payroll_actions ppa1,

1345: p_sqlstr := 'SELECT DISTINCT to_number(paa.serial_number)
1346: FROM pay_assignment_actions paa,
1347: pay_payroll_actions ppa,
1348: per_all_assignments_f paf,
1349: pay_payroll_actions ppa1,
1350: pay_us_asg_reporting puar,
1351: pay_state_rules SR
1352: WHERE ppa1.payroll_action_id = :payroll_action_id
1353: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

1513: /* Variables used to hold the details of the payroll and assignment actions
1514: that are created. */
1515:
1516: l_payroll_action_created boolean := false;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1518: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1519:
1520: /* Variable holding the balance to be tested. */
1521:

Line 1568: pay_payroll_actions ppa

1564: paa.tax_unit_id tax_unit_id,
1565: ppa.effective_date effective_end_date
1566: FROM per_all_assignments_f ASG,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa
1569: WHERE ppa.effective_date between l_period_start
1570: and l_period_end
1571: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1572: and paa.payroll_action_id = ppa.payroll_action_id

Line 1602: pay_payroll_actions ppa,

1598: paa.tax_unit_id tax_unit_id,
1599: ppa.effective_date effective_end_date
1600: FROM per_all_assignments_f ASG,
1601: pay_assignment_actions paa,
1602: pay_payroll_actions ppa,
1603: pay_population_ranges ppr
1604: WHERE ppa.effective_date between l_period_start
1605: and l_period_end
1606: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1641: pay_payroll_actions ppa

1637: ppa.effective_date effective_end_date,
1638: paa.assignment_action_id act_id
1639: FROM per_all_assignments_f ASG,
1640: pay_assignment_actions paa,
1641: pay_payroll_actions ppa
1642: WHERE ppa.effective_date = l_period_end
1643: and ppa.report_type = 'YREND'
1644: and paa.payroll_action_id = ppa.payroll_action_id
1645: and paa.assignment_id = ASG.assignment_id

Line 1675: pay_payroll_actions ppa,

1671: ppa.effective_date effective_end_date,
1672: paa.assignment_action_id act_id
1673: FROM per_all_assignments_f ASG,
1674: pay_assignment_actions paa,
1675: pay_payroll_actions ppa,
1676: pay_population_ranges ppr
1677: WHERE ppa.effective_date= l_period_end
1678: and ppa.report_type = 'YREND'
1679: and paa.payroll_action_id = ppa.payroll_action_id

Line 1719: PAY_PAYROLL_ACTIONS PPA ,

1715: PAA.ASSIGNMENT_ACTION_ID,
1716: PPA.EFFECTIVE_DATE
1717: FROM PER_ALL_ASSIGNMENTS_F PAF,
1718: PAY_ASSIGNMENT_ACTIONS PAA,
1719: PAY_PAYROLL_ACTIONS PPA ,
1720: PAY_ACTION_CLASSIFICATIONS PAC
1721: WHERE PAF.PERSON_ID = l_person_id
1722: AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
1723: AND PAA.TAX_UNIT_ID = l_tax_unit_id

Line 1992: FROM pay_payroll_actions

1988: hr_utility.set_location ('action_creation',8);
1989:
1990: /*SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
1991: INTO l_transfer_gre_id
1992: FROM pay_payroll_actions
1993: WHERE payroll_action_id = p_pactid;
1994: hr_utility.trace('In action_creation, l_transfer_gre_id= '||l_transfer_gre_id);*/
1995:
1996: hr_utility.set_location ('action_creation',9);

Line 2178: from pay_payroll_actions ppa

2174: from pay_us_states
2175: where state_abbrev =
2176: (select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
2177: 'TRANSFER_STATE')
2178: from pay_payroll_actions ppa
2179: where ppa.payroll_action_id = p_payroll_action_id);
2180:
2181:
2182: l_arch_gre_step :=20;

Line 2887: PAY_PAYROLL_ACTIONS PPA ,

2883: PPA.EFFECTIVE_DATE
2884: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2885: PER_ALL_ASSIGNMENTS_F PAF ,
2886: PAY_ASSIGNMENT_ACTIONS PAA,
2887: PAY_PAYROLL_ACTIONS PPA ,
2888: PAY_ACTION_CLASSIFICATIONS PAC
2889: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id
2890: AND PAF.PERSON_ID = PAF1.PERSON_ID
2891: AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID