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.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_PER_ITEM_VALUE

Line 817: hr_utility.set_location ( 'delete ben_tcs_per_item_value and ben_tcs_per_item entry for per_item_id :' || l_per_item,73);

813: FETCH c_per_item
814: INTO l_per_item ;
815: EXIT WHEN c_per_item%NOTFOUND;
816:
817: hr_utility.set_location ( 'delete ben_tcs_per_item_value and ben_tcs_per_item entry for per_item_id :' || l_per_item,73);
818: DELETE FROM ben_tcs_per_item_value
819: WHERE per_item_id = l_per_item;
820:
821: DELETE FROM ben_tcs_per_item

Line 818: DELETE FROM ben_tcs_per_item_value

814: INTO l_per_item ;
815: EXIT WHEN c_per_item%NOTFOUND;
816:
817: hr_utility.set_location ( 'delete ben_tcs_per_item_value and ben_tcs_per_item entry for per_item_id :' || l_per_item,73);
818: DELETE FROM ben_tcs_per_item_value
819: WHERE per_item_id = l_per_item;
820:
821: DELETE FROM ben_tcs_per_item
822: WHERE per_item_id = l_per_item;

Line 1164: hr_utility.set_location(' Inserting INTO ben_tcs_per_item_value ' ,92.1);

1160:
1161: hr_utility.set_location(' After inserting INTO ben_tcs_per_item ',92);
1162: END IF;
1163: IF (l_source_cd = 'BB' OR l_source_cd = 'RULE' OR l_source_cd = 'PAYCOSTG' ) THEN
1164: hr_utility.set_location(' Inserting INTO ben_tcs_per_item_value ' ,92.1);
1165: IF (l_comp_type_cd = 'DATE') THEN
1166: IF( l_source_cd = 'PAYCOSTG' OR l_source_cd = 'BB' ) THEN
1167: WRITE('Data Type Mismatch for the item :' || item_name ||
1168: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);

Line 1182: INSERT INTO ben_tcs_per_item_value

1178: Rollback_Person := 'Y' ;
1179: EXIT ;
1180: ELSE
1181: BEGIN
1182: INSERT INTO ben_tcs_per_item_value
1183: ( per_item_value_id,
1184: per_item_id ,
1185: source_from_date ,
1186: source_to_date,

Line 1193: ( ben_tcs_per_item_value_s.NEXTVAL ,

1189: source_key ,
1190: source_cd,
1191: display_date)
1192: VALUES
1193: ( ben_tcs_per_item_value_s.NEXTVAL ,
1194: ben_tcs_per_item_s.CURRVAL ,
1195: l_result(i).start_date,
1196: l_result(i).end_date ,
1197: i,

Line 1221: INSERT INTO ben_tcs_per_item_value

1217: END;
1218: END IF ;
1219: ELSIF (l_comp_type_cd = 'TEXT') THEN
1220:
1221: INSERT INTO ben_tcs_per_item_value
1222: ( per_item_value_id,
1223: per_item_id ,
1224: source_from_date ,
1225: source_to_date,

Line 1232: ( ben_tcs_per_item_value_s.NEXTVAL ,

1228: source_key ,
1229: source_cd,
1230: display_date)
1231: VALUES
1232: ( ben_tcs_per_item_value_s.NEXTVAL ,
1233: ben_tcs_per_item_s.CURRVAL ,
1234: l_result(i).start_date,
1235: l_result(i).end_date ,
1236: i,

Line 1245: INSERT INTO ben_tcs_per_item_value

1241: ELSE
1242:
1243:
1244: BEGIN
1245: INSERT INTO ben_tcs_per_item_value
1246: ( per_item_value_id,
1247: per_item_id ,
1248: source_from_date ,
1249: source_to_date,

Line 1256: ( ben_tcs_per_item_value_s.NEXTVAL ,

1252: source_key ,
1253: source_cd,
1254: display_date)
1255: VALUES
1256: ( ben_tcs_per_item_value_s.NEXTVAL ,
1257: ben_tcs_per_item_s.CURRVAL ,
1258: l_result(i).start_date,
1259: l_result(i).end_date ,
1260: i,

Line 1283: hr_utility.set_location(' After inserting INTO ben_tcs_per_item_value ',93 );

1279: EXIT ;
1280: END;
1281: END IF;
1282:
1283: hr_utility.set_location(' After inserting INTO ben_tcs_per_item_value ',93 );
1284: --vkodedal 7012521 Run Result ER
1285: ELSIF (l_source_cd = 'THRDPTYPAY' OR l_source_cd = 'EE' or l_source_cd = 'RR') THEN
1286:
1287: hr_utility.set_location('Inserting INTO ben_tcs_per_item_value ',94.1);

Line 1287: hr_utility.set_location('Inserting INTO ben_tcs_per_item_value ',94.1);

1283: hr_utility.set_location(' After inserting INTO ben_tcs_per_item_value ',93 );
1284: --vkodedal 7012521 Run Result ER
1285: ELSIF (l_source_cd = 'THRDPTYPAY' OR l_source_cd = 'EE' or l_source_cd = 'RR') THEN
1286:
1287: hr_utility.set_location('Inserting INTO ben_tcs_per_item_value ',94.1);
1288: hr_utility.set_location('l_comp_type_cd'||l_comp_type_cd,95.1);
1289: hr_utility.set_location('l_result(i).value'||l_result(i).value,96.1);
1290: hr_utility.set_location('actual'||l_result(i).actual_uom,97.1);
1291: IF (l_comp_type_cd = 'DATE') THEN

Line 1309: INSERT INTO ben_tcs_per_item_value

1305: Rollback_Person := 'Y' ;
1306: EXIT;
1307: ELSE
1308:
1309: INSERT INTO ben_tcs_per_item_value
1310: ( per_item_value_id,
1311: per_item_id ,
1312: source_from_date ,
1313: source_to_date,

Line 1320: ( ben_tcs_per_item_value_s.NEXTVAL ,

1316: source_key ,
1317: source_cd,
1318: display_date)
1319: VALUES
1320: ( ben_tcs_per_item_value_s.NEXTVAL ,
1321: ben_tcs_per_item_s.CURRVAL ,
1322: l_result(i).start_date,
1323: l_result(i).end_date ,
1324: i,

Line 1333: INSERT INTO ben_tcs_per_item_value

1329: END IF ;
1330:
1331: ELSIF (l_comp_type_cd = 'TEXT') THEN
1332:
1333: INSERT INTO ben_tcs_per_item_value
1334: ( per_item_value_id,
1335: per_item_id ,
1336: source_from_date ,
1337: source_to_date,

Line 1344: ( ben_tcs_per_item_value_s.NEXTVAL ,

1340: source_key ,
1341: source_cd,
1342: display_date)
1343: VALUES
1344: ( ben_tcs_per_item_value_s.NEXTVAL ,
1345: ben_tcs_per_item_s.CURRVAL ,
1346: l_result(i).start_date,
1347: l_result(i).end_date ,
1348: i,

Line 1373: INSERT INTO ben_tcs_per_item_value

1369: Rollback_Person := 'Y' ;
1370: EXIT;
1371: ELSE
1372:
1373: INSERT INTO ben_tcs_per_item_value
1374: ( per_item_value_id,
1375: per_item_id ,
1376: source_from_date ,
1377: source_to_date,

Line 1383: ( ben_tcs_per_item_value_s.NEXTVAL ,

1379: source_key ,
1380: source_cd,
1381: display_date)
1382: VALUES
1383: ( ben_tcs_per_item_value_s.NEXTVAL ,
1384: ben_tcs_per_item_s.CURRVAL ,
1385: l_result(i).start_date,
1386: l_result(i).end_date ,
1387: i,