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

Line 316: FROM ben_tcs_per_item

312:
313: CURSOR c_get_item (v_item_id IN NUMBER , v_period_id IN NUMBER)
314: IS
315: SELECT DISTINCT item_id
316: FROM ben_tcs_per_item
317: WHERE item_id = v_item_id
318: AND stmt_perd_id = v_period_id ;
319:
320: CURSOR c_stmt_period (v_stmt_id IN NUMBER , v_perd_id IN NUMBER )

Line 765: FROM ben_tcs_per_item

761:
762: CURSOR c_per_item(v_asg_stmt_id IN NUMBER)
763: IS
764: SELECT per_item_id
765: FROM ben_tcs_per_item
766: WHERE ASG_STMT_ID = v_asg_stmt_id;
767:
768: CURSOR c_per_stmt_perd
769: IS

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 821: DELETE FROM ben_tcs_per_item

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;
823: END LOOP;
824:
825: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);

Line 1138: hr_utility.set_location('Inserting INTO ben_tcs_per_item item_id '||item_id_process.item_id,91);

1134:
1135: l_uom := l_result(i).currency_cd;
1136: l_nnmntry_uom := l_result(i).uom;
1137:
1138: hr_utility.set_location('Inserting INTO ben_tcs_per_item item_id '||item_id_process.item_id,91);
1139:
1140: INSERT INTO ben_tcs_per_item
1141: ( per_item_id,
1142: asg_stmt_id ,

Line 1140: INSERT INTO ben_tcs_per_item

1136: l_nnmntry_uom := l_result(i).uom;
1137:
1138: hr_utility.set_location('Inserting INTO ben_tcs_per_item item_id '||item_id_process.item_id,91);
1139:
1140: INSERT INTO ben_tcs_per_item
1141: ( per_item_id,
1142: asg_stmt_id ,
1143: stmt_id ,
1144: item_id,

Line 1151: ( ben_tcs_per_item_s.NEXTVAL ,

1147: assignment_id,
1148: uom ,
1149: nnmntry_uom )
1150: VALUES
1151: ( ben_tcs_per_item_s.NEXTVAL ,
1152: ben_tcs_asg_stmt_s.CURRVAL ,
1153: p_stmt_id,
1154: item_id_process.item_id,
1155: p_person_id,

Line 1161: hr_utility.set_location(' After inserting INTO ben_tcs_per_item ',92);

1157: l_assign.assignment_id ,
1158: l_uom ,
1159: l_nnmntry_uom );
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

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 1194: ben_tcs_per_item_s.CURRVAL ,

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,
1198: to_date(l_result(i).value,'yyyy/mm/dd'),

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 1233: ben_tcs_per_item_s.CURRVAL ,

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,
1237: l_result(i).value,

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 1257: ben_tcs_per_item_s.CURRVAL ,

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,
1261: fnd_number.canonical_to_number(l_result(i).value),

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 1321: ben_tcs_per_item_s.CURRVAL ,

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,
1325: fnd_date.canonical_to_date(l_result(i).value),

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 1345: ben_tcs_per_item_s.CURRVAL ,

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,
1349: l_result(i).value,

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,

Line 1384: ben_tcs_per_item_s.CURRVAL ,

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,
1388: fnd_number.canonical_to_number(l_result(i).value),