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 1124: pay_balance_pkg.set_context ('TAX_UNIT_ID', l_legal_employer_id);

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

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

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

Line 1149: 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 ) ;

1145: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1146: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1147: CLOSE csr_bg_Get_Defined_Balance_Id;
1148: IF csr_balance%FOUND THEN
1149: 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 ) ;
1150: l_tot_overtime_hours := l_tot_overtime_hours + nvl(l_overtime_hours,0);
1151: END IF;
1152: END LOOP ;
1153:

Line 1181: 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 ) ;

1177: CLOSE csr_bg_Get_Defined_Balance_Id;
1178:
1179: IF csr_balance%FOUND THEN
1180:
1181: 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 ) ;
1182: l_tot_addl_time_hours := l_tot_addl_time_hours + nvl(l_addl_time_hours,0);
1183: END IF;
1184: END LOOP ;
1185:

Line 1207: 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 ) ;

1203: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1204: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1205: CLOSE csr_bg_Get_Defined_Balance_Id;
1206: IF csr_balance%FOUND THEN
1207: 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 ) ;
1208: l_tot_absence_hours := l_tot_absence_hours + nvl(l_absence_hours,0);
1209: END IF;
1210: END LOOP ;
1211:

Line 1932: 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 ) ;

1928: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1929: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1930: CLOSE csr_bg_Get_Defined_Balance_Id;
1931: IF csr_balance%FOUND THEN
1932: 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 ) ;
1933: l_tot_overtime_hours := l_tot_overtime_hours + nvl(l_overtime_hours,0);
1934: END IF;
1935: END LOOP ;
1936:

Line 1962: 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 ) ;

1958: CLOSE csr_bg_Get_Defined_Balance_Id;
1959:
1960: IF csr_balance%FOUND THEN
1961:
1962: 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 ) ;
1963: l_tot_addl_time_hours := l_tot_addl_time_hours + nvl(l_addl_time_hours,0);
1964: END IF;
1965: END LOOP ;
1966:

Line 1988: 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 ) ;

1984: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
1985: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1986: CLOSE csr_bg_Get_Defined_Balance_Id;
1987: IF csr_balance%FOUND THEN
1988: 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 ) ;
1989: l_tot_absence_hours := l_tot_absence_hours + nvl(l_absence_hours,0);
1990: END IF;
1991: END LOOP ;
1992:

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

2411: INTO l_defined_balance_id;
2412:
2413: CLOSE csr_def_bal_id;
2414:
2415: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);
2416: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2417:
2418: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2419:

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

2412:
2413: CLOSE csr_def_bal_id;
2414:
2415: -- pay_balance_pkg.set_context ('SOURCE_TEXT', NULL);
2416: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2417:
2418: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2419:
2420: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);

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

2416: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2417:
2418: fnd_file.put_line (fnd_file.LOG, 'p_tax_unit_id'||p_tax_unit_id);
2419:
2420: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
2421: l_return_balance_value :=
2422: TO_CHAR
2423: (pay_balance_pkg.get_value
2424: (p_defined_balance_id => l_defined_balance_id

Line 2423: (pay_balance_pkg.get_value

2419:
2420: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
2421: l_return_balance_value :=
2422: TO_CHAR
2423: (pay_balance_pkg.get_value
2424: (p_defined_balance_id => l_defined_balance_id
2425: ,p_assignment_id => p_in_assignment_id
2426: ,p_virtual_date => p_in_virtual_date
2427: )