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

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

872: INTO l_defined_balance_id;
873:
874: CLOSE csr_def_bal_id;
875:
876: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
877: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
878:
879: l_return_balance_value :=
880: TO_CHAR

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

873:
874: CLOSE csr_def_bal_id;
875:
876: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
877: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
878:
879: l_return_balance_value :=
880: TO_CHAR
881: (pay_balance_pkg.get_value

Line 881: (pay_balance_pkg.get_value

877: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
878:
879: l_return_balance_value :=
880: TO_CHAR
881: (pay_balance_pkg.get_value
882: (p_defined_balance_id => l_defined_balance_id
883: , p_assignment_id => p_in_assignment_id
884: , p_virtual_date => p_in_virtual_date
885: )

Line 1127: pay_balance_pkg.set_context ('ASSIGNMENT_ID', l_assignment_id);

1123: BEGIN
1124: fnd_file.put_line (fnd_file.LOG
1125: , 'l_assignment_id ==> ' || l_assignment_id
1126: );
1127: pay_balance_pkg.set_context ('ASSIGNMENT_ID', l_assignment_id);
1128: fnd_file.put_line (fnd_file.LOG
1129: , 'L_LEGAL_EMPLOYER_ID_FETCHED ==> '
1130: || l_legal_employer_id_fetched
1131: );

Line 1132: pay_balance_pkg.set_context ('TAX_UNIT_ID'

1128: fnd_file.put_line (fnd_file.LOG
1129: , 'L_LEGAL_EMPLOYER_ID_FETCHED ==> '
1130: || l_legal_employer_id_fetched
1131: );
1132: pay_balance_pkg.set_context ('TAX_UNIT_ID'
1133: , l_legal_employer_id_fetched
1134: );
1135: fnd_file.put_line (fnd_file.LOG
1136: , 'l_local_unit_id_fetched ==> '

Line 1139: pay_balance_pkg.set_context ('LOCAL_UNIT_ID'

1135: fnd_file.put_line (fnd_file.LOG
1136: , 'l_local_unit_id_fetched ==> '
1137: || l_local_unit_id_fetched
1138: );
1139: pay_balance_pkg.set_context ('LOCAL_UNIT_ID'
1140: , l_local_unit_id_fetched);
1141: fnd_file.put_line (fnd_file.LOG, 'G_END_DATE ==> ' || g_end_date);
1142: pay_balance_pkg.set_context ('DATE_EARNED', g_end_date);
1143: fnd_file.put_line (fnd_file.LOG

Line 1142: pay_balance_pkg.set_context ('DATE_EARNED', g_end_date);

1138: );
1139: pay_balance_pkg.set_context ('LOCAL_UNIT_ID'
1140: , l_local_unit_id_fetched);
1141: fnd_file.put_line (fnd_file.LOG, 'G_END_DATE ==> ' || g_end_date);
1142: pay_balance_pkg.set_context ('DATE_EARNED', g_end_date);
1143: fnd_file.put_line (fnd_file.LOG
1144: , 'l_assignment_id ==> ' || l_assignment_id
1145: );
1146: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);

Line 1146: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);

1142: pay_balance_pkg.set_context ('DATE_EARNED', g_end_date);
1143: fnd_file.put_line (fnd_file.LOG
1144: , 'l_assignment_id ==> ' || l_assignment_id
1145: );
1146: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
1147: pay_balance_pkg.set_context ('SOURCE_ID', NULL);
1148: pay_balance_pkg.set_context ('TAX_GROUP', NULL);
1149: END;
1150:

Line 1147: pay_balance_pkg.set_context ('SOURCE_ID', NULL);

1143: fnd_file.put_line (fnd_file.LOG
1144: , 'l_assignment_id ==> ' || l_assignment_id
1145: );
1146: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
1147: pay_balance_pkg.set_context ('SOURCE_ID', NULL);
1148: pay_balance_pkg.set_context ('TAX_GROUP', NULL);
1149: END;
1150:
1151: -- *****************************************************************************

Line 1148: pay_balance_pkg.set_context ('TAX_GROUP', NULL);

1144: , 'l_assignment_id ==> ' || l_assignment_id
1145: );
1146: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
1147: pay_balance_pkg.set_context ('SOURCE_ID', NULL);
1148: pay_balance_pkg.set_context ('TAX_GROUP', NULL);
1149: END;
1150:
1151: -- *****************************************************************************
1152: -- getting Balance Values

Line 1170: L_HOLIDAY_PAY_PER_DAY :=to_char(pay_balance_pkg.get_value

1166:
1167: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1168: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1169:
1170: L_HOLIDAY_PAY_PER_DAY :=to_char(pay_balance_pkg.get_value
1171: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1172: P_ASSIGNMENT_ID =>l_assignment_id ,
1173: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1174: */

Line 1182: L_TOTAL_PAID_DAYS :=to_char(pay_balance_pkg.get_value

1178:
1179: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1180: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1181:
1182: L_TOTAL_PAID_DAYS :=to_char(pay_balance_pkg.get_value
1183: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1184: P_ASSIGNMENT_ID =>l_assignment_id ,
1185: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1186: */

Line 1206: L_TOTAL_PAID_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value

1202:
1203: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1204: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1205:
1206: L_TOTAL_PAID_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1207: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1208: P_ASSIGNMENT_ID =>l_assignment_id ,
1209: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1210: */

Line 1229: L_TOTAL_SAVED_DAYS :=to_char(pay_balance_pkg.get_value

1225:
1226: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1227: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1228:
1229: L_TOTAL_SAVED_DAYS :=to_char(pay_balance_pkg.get_value
1230: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1231: P_ASSIGNMENT_ID =>l_assignment_id ,
1232: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1233: */

Line 1253: L_TOTAL_SAVED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value

1249:
1250: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1251: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1252:
1253: L_TOTAL_SAVED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1254: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1255: P_ASSIGNMENT_ID =>l_assignment_id ,
1256: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1257: */

Line 1298: L_TOTAL_EARNED_DAYS :=to_char(pay_balance_pkg.get_value

1294:
1295: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1296: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1297:
1298: L_TOTAL_EARNED_DAYS :=to_char(pay_balance_pkg.get_value
1299: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1300: P_ASSIGNMENT_ID =>l_assignment_id ,
1301: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1302: */

Line 1310: L_TOTAL_EARNED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value

1306:
1307: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1308: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1309:
1310: L_TOTAL_EARNED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1311: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1312: P_ASSIGNMENT_ID =>l_assignment_id ,
1313: P_VIRTUAL_DATE => g_end_date ),'999999999D99') ;
1314: