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_SE_WORK_TIME_CERTIFICATE dependencies on PAY_BALANCE_PKG

Line 1126: pay_balance_pkg.set_context ('TAX_UNIT_ID', l_legal_employer_id);

1122:
1123: l_dimension:='_ASG_LE_MONTH'; --EOY 2008
1124: ------------------------------------------------------
1125:
1126: pay_balance_pkg.set_context ('TAX_UNIT_ID', l_legal_employer_id);
1127:
1128: fnd_file.put_line (fnd_file.LOG, 'set Tax unit');
1129:
1130: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', l_local_unit_id);

Line 1130: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', l_local_unit_id);

1126: pay_balance_pkg.set_context ('TAX_UNIT_ID', l_legal_employer_id);
1127:
1128: fnd_file.put_line (fnd_file.LOG, 'set Tax unit');
1129:
1130: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', l_local_unit_id);
1131:
1132:
1133: l_report_start_date := TO_DATE('01/'||l_currentmonth||'/'||l_currentyear,'DD/MM/YYYY');
1134:

Line 1151: l_overtime_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1147: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1148: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1149: CLOSE csr_bg_Get_Defined_Balance_Id;
1150: IF csr_balance%FOUND THEN
1151: l_overtime_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1152: l_tot_overtime_hours := l_tot_overtime_hours + nvl(l_overtime_hours,0);
1153: END IF;
1154: END LOOP ;
1155:

Line 1183: l_addl_time_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1179: CLOSE csr_bg_Get_Defined_Balance_Id;
1180:
1181: IF csr_balance%FOUND THEN
1182:
1183: l_addl_time_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1184: l_tot_addl_time_hours := l_tot_addl_time_hours + nvl(l_addl_time_hours,0);
1185: END IF;
1186: END LOOP ;
1187:

Line 1209: l_absence_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1205: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1206: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1207: CLOSE csr_bg_Get_Defined_Balance_Id;
1208: IF csr_balance%FOUND THEN
1209: l_absence_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1210: l_tot_absence_hours := l_tot_absence_hours + nvl(l_absence_hours,0);
1211: END IF;
1212: END LOOP ;
1213: -- Bug#9272420 issue#5 fix starts

Line 1954: l_overtime_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1950: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1951: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1952: CLOSE csr_bg_Get_Defined_Balance_Id;
1953: IF csr_balance%FOUND THEN
1954: l_overtime_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1955: l_tot_overtime_hours := l_tot_overtime_hours + nvl(l_overtime_hours,0);
1956: END IF;
1957: END LOOP ;
1958:

Line 1984: l_addl_time_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1980: CLOSE csr_bg_Get_Defined_Balance_Id;
1981:
1982: IF csr_balance%FOUND THEN
1983:
1984: l_addl_time_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1985: l_tot_addl_time_hours := l_tot_addl_time_hours + nvl(l_addl_time_hours,0);
1986: END IF;
1987: END LOOP ;
1988:

Line 2010: l_absence_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

2006: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
2007: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2008: CLOSE csr_bg_Get_Defined_Balance_Id;
2009: IF csr_balance%FOUND THEN
2010: l_absence_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
2011: l_tot_absence_hours := l_tot_absence_hours + nvl(l_absence_hours,0);
2012: END IF;
2013: END LOOP ;
2014: -- Bug#9272420 issue#5 fix

Line 2455: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);

2451: INTO l_defined_balance_id;
2452:
2453: CLOSE csr_def_bal_id;
2454:
2455: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);
2456: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2457:
2458: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2459:

Line 2456: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

2452:
2453: CLOSE csr_def_bal_id;
2454:
2455: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);
2456: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2457:
2458: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2459:
2460: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);

Line 2460: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);

2456: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2457:
2458: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2459:
2460: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
2461: l_return_balance_value :=
2462: TO_CHAR
2463: (pay_balance_pkg.get_value
2464: (p_defined_balance_id => l_defined_balance_id

Line 2463: (pay_balance_pkg.get_value

2459:
2460: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
2461: l_return_balance_value :=
2462: TO_CHAR
2463: (pay_balance_pkg.get_value
2464: (p_defined_balance_id => l_defined_balance_id
2465: ,p_assignment_id => p_in_assignment_id
2466: ,p_virtual_date => p_in_virtual_date
2467: )