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: asg_rec c_asg_stmt%ROWTYPE;
769: BEGIN

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

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

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

1126:
1127: l_uom := l_result(i).currency_cd;
1128: l_nnmntry_uom := l_result(i).uom;
1129:
1130: hr_utility.set_location('Inserting INTO ben_tcs_per_item item_id '||item_id_process.item_id,91);
1131:
1132: INSERT INTO ben_tcs_per_item
1133: ( per_item_id,
1134: asg_stmt_id ,

Line 1132: INSERT INTO ben_tcs_per_item

1128: l_nnmntry_uom := l_result(i).uom;
1129:
1130: hr_utility.set_location('Inserting INTO ben_tcs_per_item item_id '||item_id_process.item_id,91);
1131:
1132: INSERT INTO ben_tcs_per_item
1133: ( per_item_id,
1134: asg_stmt_id ,
1135: stmt_id ,
1136: item_id,

Line 1143: ( ben_tcs_per_item_s.NEXTVAL ,

1139: assignment_id,
1140: uom ,
1141: nnmntry_uom )
1142: VALUES
1143: ( ben_tcs_per_item_s.NEXTVAL ,
1144: ben_tcs_asg_stmt_s.CURRVAL ,
1145: p_stmt_id,
1146: item_id_process.item_id,
1147: p_person_id,

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

1149: l_assign.assignment_id ,
1150: l_uom ,
1151: l_nnmntry_uom );
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

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

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

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

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

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

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

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

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

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

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

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,

Line 1376: ben_tcs_per_item_s.CURRVAL ,

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