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.HXC_TIMEKEEPER_PROCESS dependencies on HXC_TK_DETAIL_TEMP

Line 191: FROM hxc_tk_detail_temp

187: CURSOR c (
188: p_detailid NUMBER
189: ) IS
190: SELECT *
191: FROM hxc_tk_detail_temp
192: WHERE detailid = p_detailid;
193:
194: c_row hxc_tk_detail_temp%ROWTYPE;
195:

Line 194: c_row hxc_tk_detail_temp%ROWTYPE;

190: SELECT *
191: FROM hxc_tk_detail_temp
192: WHERE detailid = p_detailid;
193:
194: c_row hxc_tk_detail_temp%ROWTYPE;
195:
196: CURSOR c_detail_info (
197: timecard_id IN NUMBER,
198: timecard_ovn IN NUMBER

Line 698: DELETE FROM hxc_tk_detail_temp; --4191367

694: IF p_reqryflg = 'N' THEN
695: --ctk --empty the detail_temp table
696: g_detail_data.DELETE;
697:
698: DELETE FROM hxc_tk_detail_temp; --4191367
699: /*ADVICE(786): Use of DELETE or UPDATE without WHERE clause [313] */
700:
701:
702: g_submit_table.DELETE;

Line 1135: UPDATE hxc_tk_detail_temp

1131: OPEN c (x.detail_id);
1132: FETCH c INTO c_row;
1133:
1134: IF c%FOUND THEN
1135: UPDATE hxc_tk_detail_temp
1136: SET dff_catg = l_attributes (l_attribute_index).attribute_category,
1137: dff_oldcatg = l_attributes (l_attribute_index).attribute_category,
1138: dff_attr1 = l_attributes (l_attribute_index).attribute1,
1139: dff_attr2 = l_attributes (l_attribute_index).attribute2,

Line 1200: INSERT INTO hxc_tk_detail_temp

1196: dff_oldattr29 = l_attributes (l_attribute_index).attribute29,
1197: dff_oldattr30 = l_attributes (l_attribute_index).attribute30
1198: WHERE detailid = x.detail_id;
1199: ELSE
1200: INSERT INTO hxc_tk_detail_temp
1201: (detailid, timecard_id, resource_id, comment_text, dff_catg, dff_oldcatg,
1202: dff_attr1, dff_attr2, dff_attr3, dff_attr4, dff_attr5, dff_attr6, dff_attr7,
1203: dff_attr8, dff_attr9, dff_attr10, dff_attr11, dff_attr12, dff_attr13,
1204: dff_attr14, dff_attr15, dff_attr16, dff_attr17, dff_attr18, dff_attr19,

Line 1309: UPDATE hxc_tk_detail_temp

1305: --
1306:
1307: IF (l_attributes (l_attribute_index).attribute3 = 'LATE') THEN
1308: /* JOEL => we are missing old_audit_datetime in the table*/
1309: UPDATE hxc_tk_detail_temp
1310: SET late_change = 'LATE',
1311: old_late_change = 'LATE',
1312: change_comment = NULL,
1313: old_change_comment = NULL,

Line 1330: UPDATE hxc_tk_detail_temp

1326: ELSIF (l_attributes (l_attribute_index).attribute3 = 'CHANGE') THEN -- change
1327:
1328: /* IF (l_attributes ( l_attribute_index ).attribute3)='CHANGE'
1329: THEN*/
1330: UPDATE hxc_tk_detail_temp
1331: SET late_change = 'CHANGE',
1332: old_late_change = 'CHANGE',
1333: late_comment = NULL,
1334: old_late_comment = NULL,

Line 1349: UPDATE hxc_tk_detail_temp

1345: WHERE detailid = x.detail_id;
1346:
1347: ELSIF (l_attributes (l_attribute_index).attribute3 is null) THEN
1348:
1349: UPDATE hxc_tk_detail_temp
1350: SET late_change = NULL,
1351: old_late_change = NULL,
1352: late_comment = NULL,
1353: old_late_comment = NULL,

Line 1381: INSERT INTO hxc_tk_detail_temp

1377: end if;
1378:
1379: --
1380:
1381: INSERT INTO hxc_tk_detail_temp
1382: (detailid, timecard_id, resource_id, comment_text, late_change, old_late_change,
1383: late_reason,
1384: late_comment, old_late_reason, old_late_comment, audit_datetime,
1385: old_audit_datetime,

Line 1401: INSERT INTO hxc_tk_detail_temp

1397: l_attributes (l_attribute_index).attribute7);
1398:
1399: ELSIF (l_attributes (l_attribute_index).attribute3 = 'CHANGE') THEN
1400:
1401: INSERT INTO hxc_tk_detail_temp
1402: (detailid, timecard_id, resource_id, comment_text, late_change,old_late_change,
1403: change_reason,
1404: change_comment, old_change_reason, old_change_comment, audit_datetime,
1405: old_audit_datetime,

Line 1420: INSERT INTO hxc_tk_detail_temp

1416: l_attributes (l_attribute_index).attribute7);
1417:
1418: ELSIF (l_attributes (l_attribute_index).attribute3 is null) THEN
1419:
1420: INSERT INTO hxc_tk_detail_temp
1421: (detailid, timecard_id, resource_id, comment_text, late_change,old_late_change,
1422: change_reason,
1423: change_comment, old_change_reason, old_change_comment, audit_datetime,
1424: old_audit_datetime,

Line 2060: UPDATE hxc_tk_detail_temp

2056: OPEN c (l_detail_id);
2057: FETCH c INTO c_row;
2058:
2059: IF c%FOUND THEN
2060: UPDATE hxc_tk_detail_temp
2061: SET comment_text = l_detail_comment_text
2062: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2063: ELSE
2064: INSERT INTO hxc_tk_detail_temp

Line 2064: INSERT INTO hxc_tk_detail_temp

2060: UPDATE hxc_tk_detail_temp
2061: SET comment_text = l_detail_comment_text
2062: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2063: ELSE
2064: INSERT INTO hxc_tk_detail_temp
2065: (detailid, timecard_id, comment_text)
2066: VALUES (l_detail_id, l_timecard_id, l_detail_comment_text);
2067: END IF;
2068:

Line 2458: UPDATE hxc_tk_detail_temp

2454: OPEN c (l_detail_id);
2455: FETCH c INTO c_row;
2456:
2457: IF c%FOUND THEN
2458: UPDATE hxc_tk_detail_temp
2459: SET comment_text = l_detail_comment_text
2460: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2461: ELSE
2462: INSERT INTO hxc_tk_detail_temp

Line 2462: INSERT INTO hxc_tk_detail_temp

2458: UPDATE hxc_tk_detail_temp
2459: SET comment_text = l_detail_comment_text
2460: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2461: ELSE
2462: INSERT INTO hxc_tk_detail_temp
2463: (detailid, timecard_id, comment_text)
2464: VALUES (l_detail_id, l_timecard_id, l_detail_comment_text);
2465: END IF;
2466:

Line 5824: FROM hxc_tk_detail_temp

5820: CURSOR c_detail (
5821: p_detailid IN NUMBER
5822: ) IS
5823: SELECT *
5824: FROM hxc_tk_detail_temp
5825: WHERE detailid = p_detailid;
5826:
5827: CURSOR c_timecard_info (
5828: p_resource_id

Line 5846: c_row hxc_tk_detail_temp%ROWTYPE;

5842: AND date_to = hr_general.end_of_time
5843: AND start_time = p_start_period
5844: AND stop_time = p_end_period;
5845:
5846: c_row hxc_tk_detail_temp%ROWTYPE;
5847:
5848: l_detail_reason_category VARCHAR2 (150);
5849: l_detail_reason_att_1 VARCHAR2 (150);
5850: l_detail_reason_att_2 VARCHAR2 (150);

Line 6508: DELETE FROM hxc_tk_detail_temp

6504: hr_utility.trace('not l_detail_dff_changed');
6505: end if;
6506: END IF;
6507:
6508: DELETE FROM hxc_tk_detail_temp
6509: WHERE detailid = l_detail_id;
6510:
6511: END IF;
6512: