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

Line 57: ( payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,

53: p_group_id in number,
54: p_srs_request_id OUT NOCOPY number)
55: IS
56: TYPE check_details_rectype IS RECORD
57: ( payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
58: payroll_id pay_payroll_actions.payroll_id%TYPE,
59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,

Line 58: payroll_id pay_payroll_actions.payroll_id%TYPE,

54: p_srs_request_id OUT NOCOPY number)
55: IS
56: TYPE check_details_rectype IS RECORD
57: ( payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
58: payroll_id pay_payroll_actions.payroll_id%TYPE,
59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,

Line 59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,

55: IS
56: TYPE check_details_rectype IS RECORD
57: ( payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
58: payroll_id pay_payroll_actions.payroll_id%TYPE,
59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,

Line 60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,

56: TYPE check_details_rectype IS RECORD
57: ( payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
58: payroll_id pay_payroll_actions.payroll_id%TYPE,
59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,

Line 61: effective_date pay_payroll_actions.effective_date%TYPE,

57: ( payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
58: payroll_id pay_payroll_actions.payroll_id%TYPE,
59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,

Line 62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,

58: payroll_id pay_payroll_actions.payroll_id%TYPE,
59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,
66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,

Line 63: cheque_report pay_payroll_actions.cheque_report%TYPE,

59: org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE,
60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,
66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
67: payroll_name pay_all_payrolls_f.payroll_name%TYPE,

Line 64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,

60: payment_type_id pay_payroll_actions.payment_type_id%TYPE,
61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,
66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
67: payroll_name pay_all_payrolls_f.payroll_name%TYPE,
68: consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE,

Line 65: start_date pay_payroll_actions.start_date%TYPE,

61: effective_date pay_payroll_actions.effective_date%TYPE,
62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,
66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
67: payroll_name pay_all_payrolls_f.payroll_name%TYPE,
68: consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE,
69: business_group_id pay_all_payrolls_f.business_group_id%TYPE,

Line 66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,

62: cheque_procedure pay_payroll_actions.cheque_procedure%TYPE,
63: cheque_report pay_payroll_actions.cheque_report%TYPE,
64: start_cheque_number pay_payroll_actions.start_cheque_number%TYPE,
65: start_date pay_payroll_actions.start_date%TYPE,
66: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
67: payroll_name pay_all_payrolls_f.payroll_name%TYPE,
68: consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE,
69: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
70: assignment_id pay_assignment_actions.assignment_id%TYPE

Line 77: l_curr_payroll_action_id pay_payroll_Actions.payroll_Action_id%type;

73: check_details_rec check_details_rectype;
74: l_request_id number;
75: l_sort_sequence hr_lookups.meaning%TYPE;
76: l_check_style hr_lookups.meaning%TYPE;
77: l_curr_payroll_action_id pay_payroll_Actions.payroll_Action_id%type;
78: --
79: l_wait_outcome BOOLEAN;
80: l_phase VARCHAR2(80);
81: l_status VARCHAR2(80);

Line 127: -- Derive payroll name, consolidation set from pay_payroll_actions

123: l_format := 'DD-MM-YYYY';
124: end if;
125:
126: -- if group 1
127: -- Derive payroll name, consolidation set from pay_payroll_actions
128: -- Derive the previous check writer details from pay_payroll_actions
129: IF p_group_id = 1 THEN
130:
131: hr_utility.set_location(l_proc, 20);

Line 128: -- Derive the previous check writer details from pay_payroll_actions

124: end if;
125:
126: -- if group 1
127: -- Derive payroll name, consolidation set from pay_payroll_actions
128: -- Derive the previous check writer details from pay_payroll_actions
129: IF p_group_id = 1 THEN
130:
131: hr_utility.set_location(l_proc, 20);
132:

Line 149: FROM pay_payroll_actions ppa

145: ,papf.business_group_id
146: ,paa.assignment_id
147: -- ,popmf.org_payment_method_name
148: INTO check_details_rec
149: FROM pay_payroll_actions ppa
150: ,pay_assignment_actions paa
151: ,pay_all_payrolls_f papf
152: ,pay_consolidation_sets pcs
153: ,pay_org_payment_methods_f popmf

Line 300: update pay_payroll_actions

296: open c_get_payrl_action(p_start_check_number);
297: fetch c_get_payrl_action into l_curr_payroll_action_id;
298: close c_get_payrl_action;
299:
300: update pay_payroll_actions
301: set assignment_set_id = null,
302: last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id

Line 346: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;

342: p_srs_request_id OUT NOCOPY number)
343:
344: IS
345:
346: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
347: l_start_cheque_number pay_payroll_actions.start_cheque_number%TYPE;
348: l_request_id number;
349: --
350: l_wait_outcome BOOLEAN;

Line 347: l_start_cheque_number pay_payroll_actions.start_cheque_number%TYPE;

343:
344: IS
345:
346: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
347: l_start_cheque_number pay_payroll_actions.start_cheque_number%TYPE;
348: l_request_id number;
349: --
350: l_wait_outcome BOOLEAN;
351: l_phase VARCHAR2(80);

Line 369: -- Derive payroll and check details from pay_payroll_actions

365:
366: l_request_id := 0;
367:
368: -- if group 1
369: -- Derive payroll and check details from pay_payroll_actions
370: -- Assign all the relevant SRS params
371:
372: IF p_group_id = 1 THEN
373:

Line 378: from pay_payroll_actions ppa, pay_assignment_actions paa

374: hr_utility.set_location(l_proc, 10);
375:
376: select ppa.payroll_action_id, paa.serial_number
377: into l_payroll_action_id, l_start_cheque_number
378: from pay_payroll_actions ppa, pay_assignment_actions paa
379: where ppa.payroll_action_id = paa.payroll_action_id
380: and paa.assignment_action_id = p_check_assignment_action;
381:
382: END IF;

Line 441: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

437: p_check_assignment_action varchar2,
438: p_group_id in number,
439: p_srs_request_id OUT NOCOPY number) IS
440:
441: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
442: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
443: l_prepayment_asg_action pay_assignment_actions.assignment_action_id%TYPE ;
444: l_serial_number pay_assignment_actions.serial_number%TYPE;
445: l_pre_payment_id pay_pre_payments.pre_payment_id%TYPE;

Line 473: from pay_payroll_actions ppa, pay_assignment_actions paa,

469: select distinct(paa.assignment_action_id),ppa.payroll_id,
470: paa.assignment_id, ppp.pre_payment_id, paa2.serial_number
471: into l_prepayment_asg_action, l_payroll_id, l_assignment_id,
472: l_pre_payment_id, l_serial_number
473: from pay_payroll_actions ppa, pay_assignment_actions paa,
474: pay_assignment_actions paa2, pay_all_payrolls_f papf,
475: pay_pre_payments ppp, pay_action_interlocks pal
476: where pal.locking_action_id = p_check_assignment_action
477: and paa2.assignment_action_id = p_check_assignment_action

Line 544: ( payroll_id pay_payroll_actions.payroll_id%TYPE,

540: p_group_id in number,
541: p_srs_request_id OUT NOCOPY number)IS
542:
543: TYPE payroll_action_rectype IS RECORD
544: ( payroll_id pay_payroll_actions.payroll_id%TYPE,
545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
547: action_type pay_payroll_actions.action_type%TYPE,
548: action_status pay_payroll_actions.action_status%TYPE,

Line 545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,

541: p_srs_request_id OUT NOCOPY number)IS
542:
543: TYPE payroll_action_rectype IS RECORD
544: ( payroll_id pay_payroll_actions.payroll_id%TYPE,
545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
547: action_type pay_payroll_actions.action_type%TYPE,
548: action_status pay_payroll_actions.action_status%TYPE,
549: action_population_status pay_payroll_actions.action_population_status%TYPE

Line 547: action_type pay_payroll_actions.action_type%TYPE,

543: TYPE payroll_action_rectype IS RECORD
544: ( payroll_id pay_payroll_actions.payroll_id%TYPE,
545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
547: action_type pay_payroll_actions.action_type%TYPE,
548: action_status pay_payroll_actions.action_status%TYPE,
549: action_population_status pay_payroll_actions.action_population_status%TYPE
550: );
551: --

Line 548: action_status pay_payroll_actions.action_status%TYPE,

544: ( payroll_id pay_payroll_actions.payroll_id%TYPE,
545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
547: action_type pay_payroll_actions.action_type%TYPE,
548: action_status pay_payroll_actions.action_status%TYPE,
549: action_population_status pay_payroll_actions.action_population_status%TYPE
550: );
551: --
552: CURSOR get_pay_run_asg_action(p_check_assignment_action varchar2)

Line 549: action_population_status pay_payroll_actions.action_population_status%TYPE

545: consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
546: business_group_id pay_all_payrolls_f.business_group_id%TYPE,
547: action_type pay_payroll_actions.action_type%TYPE,
548: action_status pay_payroll_actions.action_status%TYPE,
549: action_population_status pay_payroll_actions.action_population_status%TYPE
550: );
551: --
552: CURSOR get_pay_run_asg_action(p_check_assignment_action varchar2)
553: IS ( select pal2.locked_action_id

Line 585: from pay_payroll_actions

581: l_already_ran := 'N';
582:
583: select count(*)
584: into l_temp
585: from pay_payroll_actions
586: where action_type = 'V'
587: and action_status = 'P';
588:
589: dbms_lock.sleep(5*l_temp);

Line 613: from pay_payroll_actions ppa, pay_assignment_actions paa,

609: papf.business_group_id,
610: ppa.action_type, ppa.action_status,
611: ppa.action_population_status
612: into payroll_action_rec
613: from pay_payroll_actions ppa, pay_assignment_actions paa,
614: pay_all_payrolls_f papf, pay_consolidation_sets pcs
615: where paa.assignment_action_id = l_payroll_run_asg_action
616: and ppa.payroll_action_id = paa.payroll_action_id
617: and papf.payroll_id = ppa.payroll_id

Line 632: pay_payroll_actions pa2,

628: begin
629: select distinct 1
630: into l_temp
631: from pay_assignment_actions ac2,
632: pay_payroll_actions pa2,
633: pay_action_interlocks pai
634: where pai.locked_action_id = l_payroll_run_asg_action
635: and ac2.assignment_action_id = pai.locking_action_id
636: and pa2.payroll_action_id = ac2.payroll_action_id