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 810: hr_utility.set_location ( 'delete ben_tcs_per_item_value and ben_tcs_per_item entry for per_item_id :' || l_per_item,73);

806: FETCH c_per_item
807: INTO l_per_item ;
808: EXIT WHEN c_per_item%NOTFOUND;
809:
810: hr_utility.set_location ( 'delete ben_tcs_per_item_value and ben_tcs_per_item entry for per_item_id :' || l_per_item,73);
811: DELETE FROM ben_tcs_per_item_value
812: WHERE per_item_id = l_per_item;
813:
814: DELETE FROM ben_tcs_per_item

Line 811: DELETE FROM ben_tcs_per_item_value

807: INTO l_per_item ;
808: EXIT WHEN c_per_item%NOTFOUND;
809:
810: hr_utility.set_location ( 'delete ben_tcs_per_item_value and ben_tcs_per_item entry for per_item_id :' || l_per_item,73);
811: DELETE FROM ben_tcs_per_item_value
812: WHERE per_item_id = l_per_item;
813:
814: DELETE FROM ben_tcs_per_item
815: WHERE per_item_id = l_per_item;

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

1152:
1153: hr_utility.set_location(' After inserting INTO ben_tcs_per_item ',92);
1154: END IF;
1155: IF (l_source_cd = 'BB' OR l_source_cd = 'RULE' OR l_source_cd = 'PAYCOSTG' ) THEN
1156: hr_utility.set_location(' Inserting INTO ben_tcs_per_item_value ' ,92.1);
1157: IF (l_comp_type_cd = 'DATE') THEN
1158: IF( l_source_cd = 'PAYCOSTG' OR l_source_cd = 'BB' ) THEN
1159: WRITE('Data Type Mismatch for the item :' || item_name ||
1160: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);

Line 1174: INSERT INTO ben_tcs_per_item_value

1170: Rollback_Person := 'Y' ;
1171: EXIT ;
1172: ELSE
1173: BEGIN
1174: INSERT INTO ben_tcs_per_item_value
1175: ( per_item_value_id,
1176: per_item_id ,
1177: source_from_date ,
1178: source_to_date,

Line 1185: ( ben_tcs_per_item_value_s.NEXTVAL ,

1181: source_key ,
1182: source_cd,
1183: display_date)
1184: VALUES
1185: ( ben_tcs_per_item_value_s.NEXTVAL ,
1186: ben_tcs_per_item_s.CURRVAL ,
1187: l_result(i).start_date,
1188: l_result(i).end_date ,
1189: i,

Line 1213: INSERT INTO ben_tcs_per_item_value

1209: END;
1210: END IF ;
1211: ELSIF (l_comp_type_cd = 'TEXT') THEN
1212:
1213: INSERT INTO ben_tcs_per_item_value
1214: ( per_item_value_id,
1215: per_item_id ,
1216: source_from_date ,
1217: source_to_date,

Line 1224: ( ben_tcs_per_item_value_s.NEXTVAL ,

1220: source_key ,
1221: source_cd,
1222: display_date)
1223: VALUES
1224: ( ben_tcs_per_item_value_s.NEXTVAL ,
1225: ben_tcs_per_item_s.CURRVAL ,
1226: l_result(i).start_date,
1227: l_result(i).end_date ,
1228: i,

Line 1237: INSERT INTO ben_tcs_per_item_value

1233: ELSE
1234:
1235:
1236: BEGIN
1237: INSERT INTO ben_tcs_per_item_value
1238: ( per_item_value_id,
1239: per_item_id ,
1240: source_from_date ,
1241: source_to_date,

Line 1248: ( ben_tcs_per_item_value_s.NEXTVAL ,

1244: source_key ,
1245: source_cd,
1246: display_date)
1247: VALUES
1248: ( ben_tcs_per_item_value_s.NEXTVAL ,
1249: ben_tcs_per_item_s.CURRVAL ,
1250: l_result(i).start_date,
1251: l_result(i).end_date ,
1252: i,

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

1271: EXIT ;
1272: END;
1273: END IF;
1274:
1275: hr_utility.set_location(' After inserting INTO ben_tcs_per_item_value ',93 );
1276:
1277: ELSIF (l_source_cd = 'THRDPTYPAY' OR l_source_cd = 'EE' ) THEN
1278:
1279: hr_utility.set_location('Inserting INTO ben_tcs_per_item_value ',94.1);

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

1275: hr_utility.set_location(' After inserting INTO ben_tcs_per_item_value ',93 );
1276:
1277: ELSIF (l_source_cd = 'THRDPTYPAY' OR l_source_cd = 'EE' ) THEN
1278:
1279: hr_utility.set_location('Inserting INTO ben_tcs_per_item_value ',94.1);
1280: hr_utility.set_location('l_comp_type_cd'||l_comp_type_cd,95.1);
1281: hr_utility.set_location('l_result(i).value'||l_result(i).value,96.1);
1282: hr_utility.set_location('actual'||l_result(i).actual_uom,97.1);
1283: IF (l_comp_type_cd = 'DATE') THEN

Line 1301: INSERT INTO ben_tcs_per_item_value

1297: Rollback_Person := 'Y' ;
1298: EXIT;
1299: ELSE
1300:
1301: INSERT INTO ben_tcs_per_item_value
1302: ( per_item_value_id,
1303: per_item_id ,
1304: source_from_date ,
1305: source_to_date,

Line 1312: ( ben_tcs_per_item_value_s.NEXTVAL ,

1308: source_key ,
1309: source_cd,
1310: display_date)
1311: VALUES
1312: ( ben_tcs_per_item_value_s.NEXTVAL ,
1313: ben_tcs_per_item_s.CURRVAL ,
1314: l_result(i).start_date,
1315: l_result(i).end_date ,
1316: i,

Line 1325: INSERT INTO ben_tcs_per_item_value

1321: END IF ;
1322:
1323: ELSIF (l_comp_type_cd = 'TEXT') THEN
1324:
1325: INSERT INTO ben_tcs_per_item_value
1326: ( per_item_value_id,
1327: per_item_id ,
1328: source_from_date ,
1329: source_to_date,

Line 1336: ( ben_tcs_per_item_value_s.NEXTVAL ,

1332: source_key ,
1333: source_cd,
1334: display_date)
1335: VALUES
1336: ( ben_tcs_per_item_value_s.NEXTVAL ,
1337: ben_tcs_per_item_s.CURRVAL ,
1338: l_result(i).start_date,
1339: l_result(i).end_date ,
1340: i,

Line 1365: INSERT INTO ben_tcs_per_item_value

1361: Rollback_Person := 'Y' ;
1362: EXIT;
1363: ELSE
1364:
1365: INSERT INTO ben_tcs_per_item_value
1366: ( per_item_value_id,
1367: per_item_id ,
1368: source_from_date ,
1369: source_to_date,

Line 1375: ( ben_tcs_per_item_value_s.NEXTVAL ,

1371: source_key ,
1372: source_cd,
1373: display_date)
1374: VALUES
1375: ( ben_tcs_per_item_value_s.NEXTVAL ,
1376: ben_tcs_per_item_s.CURRVAL ,
1377: l_result(i).start_date,
1378: l_result(i).end_date ,
1379: i,