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.HR_PAY_IF_ASG_COST_BRD dependencies on HR_PAY_INTERFACE_PKG

Line 20: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND

16: CURSOR csr_get_pid IS
17: SELECT aa.payroll_id
18: FROM per_all_assignments_f aa
19: WHERE aa.assignment_id = :old.assignment_id AND
20: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND
21: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) <= aa.effective_end_date;
22: --
23: l_event_id NUMBER;
24: l_business_group_id NUMBER;

Line 21: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) <= aa.effective_end_date;

17: SELECT aa.payroll_id
18: FROM per_all_assignments_f aa
19: WHERE aa.assignment_id = :old.assignment_id AND
20: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND
21: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) <= aa.effective_end_date;
22: --
23: l_event_id NUMBER;
24: l_business_group_id NUMBER;
25: l_legislation_code VARCHAR2(10);

Line 38: INTO HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.business_group_id;

34: CLOSE csr_get_event_id ;
35:
36: OPEN csr_get_bg;
37: FETCH csr_get_bg
38: INTO HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.business_group_id;
39: CLOSE csr_get_bg;
40:
41: l_business_group_id :=
42: HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.business_group_id;

Line 42: HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.business_group_id;

38: INTO HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.business_group_id;
39: CLOSE csr_get_bg;
40:
41: l_business_group_id :=
42: HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.business_group_id;
43: l_legislation_code := pay_core_utils.get_legislation_code(
44: p_bg_id => l_business_group_id);
45:
46: OPEN csr_get_pid;

Line 48: INTO HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.payroll_id;

44: p_bg_id => l_business_group_id);
45:
46: OPEN csr_get_pid;
47: FETCH csr_get_pid
48: INTO HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.payroll_id;
49: CLOSE csr_get_pid;
50:
51: l_payroll_id :=
52: hr_pay_interface_pkg.g_reporting_details_rec_var.payroll_id;

Line 52: hr_pay_interface_pkg.g_reporting_details_rec_var.payroll_id;

48: INTO HR_PAY_INTERFACE_PKG.g_reporting_details_rec_var.payroll_id;
49: CLOSE csr_get_pid;
50:
51: l_payroll_id :=
52: hr_pay_interface_pkg.g_reporting_details_rec_var.payroll_id;
53:
54: IF paywsfgt_pkg.trigger_is_not_enabled(
55: p_event_id => l_event_id,
56: p_legislation_code => l_legislation_code,

Line 63: IF hr_pay_interface_pkg.g_cost_allocation_id IS NOT NULL AND

59: ) THEN
60: RETURN;
61: END IF;
62:
63: IF hr_pay_interface_pkg.g_cost_allocation_id IS NOT NULL AND
64: :old.cost_allocation_id <>
65: hr_pay_interface_pkg.g_cost_allocation_id
66: THEN
67: hr_utility.set_message (800, 'PER_ASG_COST_INF_DIS_DEL');

Line 65: hr_pay_interface_pkg.g_cost_allocation_id

61: END IF;
62:
63: IF hr_pay_interface_pkg.g_cost_allocation_id IS NOT NULL AND
64: :old.cost_allocation_id <>
65: hr_pay_interface_pkg.g_cost_allocation_id
66: THEN
67: hr_utility.set_message (800, 'PER_ASG_COST_INF_DIS_DEL');
68: hr_pay_interface_pkg.g_cost_allocation_id := NULL;
69: hr_utility.raise_error;

Line 68: hr_pay_interface_pkg.g_cost_allocation_id := NULL;

64: :old.cost_allocation_id <>
65: hr_pay_interface_pkg.g_cost_allocation_id
66: THEN
67: hr_utility.set_message (800, 'PER_ASG_COST_INF_DIS_DEL');
68: hr_pay_interface_pkg.g_cost_allocation_id := NULL;
69: hr_utility.raise_error;
70: ELSE
71: hr_pay_interface_pkg.g_cost_allocation_id := :old.cost_allocation_id;
72: hr_pay_interface_pkg.g_asg_cost_ass_id := :old.assignment_id;

Line 71: hr_pay_interface_pkg.g_cost_allocation_id := :old.cost_allocation_id;

67: hr_utility.set_message (800, 'PER_ASG_COST_INF_DIS_DEL');
68: hr_pay_interface_pkg.g_cost_allocation_id := NULL;
69: hr_utility.raise_error;
70: ELSE
71: hr_pay_interface_pkg.g_cost_allocation_id := :old.cost_allocation_id;
72: hr_pay_interface_pkg.g_asg_cost_ass_id := :old.assignment_id;
73: -- hr_pay_interface_pkg.g_asg_cost_end_date := :old.effective_end_date;
74: hr_pay_interface_pkg.g_asg_cost_start_date := :old.effective_start_date;
75: END IF;

Line 72: hr_pay_interface_pkg.g_asg_cost_ass_id := :old.assignment_id;

68: hr_pay_interface_pkg.g_cost_allocation_id := NULL;
69: hr_utility.raise_error;
70: ELSE
71: hr_pay_interface_pkg.g_cost_allocation_id := :old.cost_allocation_id;
72: hr_pay_interface_pkg.g_asg_cost_ass_id := :old.assignment_id;
73: -- hr_pay_interface_pkg.g_asg_cost_end_date := :old.effective_end_date;
74: hr_pay_interface_pkg.g_asg_cost_start_date := :old.effective_start_date;
75: END IF;
76: END IF;

Line 73: -- hr_pay_interface_pkg.g_asg_cost_end_date := :old.effective_end_date;

69: hr_utility.raise_error;
70: ELSE
71: hr_pay_interface_pkg.g_cost_allocation_id := :old.cost_allocation_id;
72: hr_pay_interface_pkg.g_asg_cost_ass_id := :old.assignment_id;
73: -- hr_pay_interface_pkg.g_asg_cost_end_date := :old.effective_end_date;
74: hr_pay_interface_pkg.g_asg_cost_start_date := :old.effective_start_date;
75: END IF;
76: END IF;
77: END hr_pay_if_asg_cost_brd;

Line 74: hr_pay_interface_pkg.g_asg_cost_start_date := :old.effective_start_date;

70: ELSE
71: hr_pay_interface_pkg.g_cost_allocation_id := :old.cost_allocation_id;
72: hr_pay_interface_pkg.g_asg_cost_ass_id := :old.assignment_id;
73: -- hr_pay_interface_pkg.g_asg_cost_end_date := :old.effective_end_date;
74: hr_pay_interface_pkg.g_asg_cost_start_date := :old.effective_start_date;
75: END IF;
76: END IF;
77: END hr_pay_if_asg_cost_brd;