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 735: DELETE FROM hxc_tk_detail_temp; --4191367

731: IF p_reqryflg = 'N' THEN
732: --ctk --empty the detail_temp table
733: g_detail_data.DELETE;
734:
735: DELETE FROM hxc_tk_detail_temp; --4191367
736: /*ADVICE(786): Use of DELETE or UPDATE without WHERE clause [313] */
737:
738:
739: g_submit_table.DELETE;

Line 1267: UPDATE hxc_tk_detail_temp

1263: OPEN c (x.detail_id);
1264: FETCH c INTO c_row;
1265:
1266: IF c%FOUND THEN
1267: UPDATE hxc_tk_detail_temp
1268: SET dff_catg = l_attributes (l_attribute_index).attribute_category,
1269: dff_oldcatg = l_attributes (l_attribute_index).attribute_category,
1270: dff_attr1 = l_attributes (l_attribute_index).attribute1,
1271: dff_attr2 = l_attributes (l_attribute_index).attribute2,

Line 1332: INSERT INTO hxc_tk_detail_temp

1328: dff_oldattr29 = l_attributes (l_attribute_index).attribute29,
1329: dff_oldattr30 = l_attributes (l_attribute_index).attribute30
1330: WHERE detailid = x.detail_id;
1331: ELSE
1332: INSERT INTO hxc_tk_detail_temp
1333: (detailid, timecard_id, resource_id, comment_text, dff_catg, dff_oldcatg,
1334: dff_attr1, dff_attr2, dff_attr3, dff_attr4, dff_attr5, dff_attr6, dff_attr7,
1335: dff_attr8, dff_attr9, dff_attr10, dff_attr11, dff_attr12, dff_attr13,
1336: dff_attr14, dff_attr15, dff_attr16, dff_attr17, dff_attr18, dff_attr19,

Line 1441: UPDATE hxc_tk_detail_temp

1437: --
1438:
1439: IF (l_attributes (l_attribute_index).attribute3 = 'LATE') THEN
1440: /* JOEL => we are missing old_audit_datetime in the table*/
1441: UPDATE hxc_tk_detail_temp
1442: SET late_change = 'LATE',
1443: old_late_change = 'LATE',
1444: change_comment = NULL,
1445: old_change_comment = NULL,

Line 1462: UPDATE hxc_tk_detail_temp

1458: ELSIF (l_attributes (l_attribute_index).attribute3 = 'CHANGE') THEN -- change
1459:
1460: /* IF (l_attributes ( l_attribute_index ).attribute3)='CHANGE'
1461: THEN*/
1462: UPDATE hxc_tk_detail_temp
1463: SET late_change = 'CHANGE',
1464: old_late_change = 'CHANGE',
1465: late_comment = NULL,
1466: old_late_comment = NULL,

Line 1481: UPDATE hxc_tk_detail_temp

1477: WHERE detailid = x.detail_id;
1478:
1479: ELSIF (l_attributes (l_attribute_index).attribute3 is null) THEN
1480:
1481: UPDATE hxc_tk_detail_temp
1482: SET late_change = NULL,
1483: old_late_change = NULL,
1484: late_comment = NULL,
1485: old_late_comment = NULL,

Line 1513: INSERT INTO hxc_tk_detail_temp

1509: end if;
1510:
1511: --
1512:
1513: INSERT INTO hxc_tk_detail_temp
1514: (detailid, timecard_id, resource_id, comment_text, late_change, old_late_change,
1515: late_reason,
1516: late_comment, old_late_reason, old_late_comment, audit_datetime,
1517: old_audit_datetime,

Line 1533: INSERT INTO hxc_tk_detail_temp

1529: l_attributes (l_attribute_index).attribute7);
1530:
1531: ELSIF (l_attributes (l_attribute_index).attribute3 = 'CHANGE') THEN
1532:
1533: INSERT INTO hxc_tk_detail_temp
1534: (detailid, timecard_id, resource_id, comment_text, late_change,old_late_change,
1535: change_reason,
1536: change_comment, old_change_reason, old_change_comment, audit_datetime,
1537: old_audit_datetime,

Line 1552: INSERT INTO hxc_tk_detail_temp

1548: l_attributes (l_attribute_index).attribute7);
1549:
1550: ELSIF (l_attributes (l_attribute_index).attribute3 is null) THEN
1551:
1552: INSERT INTO hxc_tk_detail_temp
1553: (detailid, timecard_id, resource_id, comment_text, late_change,old_late_change,
1554: change_reason,
1555: change_comment, old_change_reason, old_change_comment, audit_datetime,
1556: old_audit_datetime,

Line 2195: UPDATE hxc_tk_detail_temp

2191: OPEN c (l_detail_id);
2192: FETCH c INTO c_row;
2193:
2194: IF c%FOUND THEN
2195: UPDATE hxc_tk_detail_temp
2196: SET comment_text = l_detail_comment_text
2197: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2198: ELSE
2199: INSERT INTO hxc_tk_detail_temp

Line 2199: INSERT INTO hxc_tk_detail_temp

2195: UPDATE hxc_tk_detail_temp
2196: SET comment_text = l_detail_comment_text
2197: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2198: ELSE
2199: INSERT INTO hxc_tk_detail_temp
2200: (detailid, timecard_id, comment_text)
2201: VALUES (l_detail_id, l_timecard_id, l_detail_comment_text);
2202: END IF;
2203:

Line 2599: UPDATE hxc_tk_detail_temp

2595: OPEN c (l_detail_id);
2596: FETCH c INTO c_row;
2597:
2598: IF c%FOUND THEN
2599: UPDATE hxc_tk_detail_temp
2600: SET comment_text = l_detail_comment_text
2601: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2602: ELSE
2603: INSERT INTO hxc_tk_detail_temp

Line 2603: INSERT INTO hxc_tk_detail_temp

2599: UPDATE hxc_tk_detail_temp
2600: SET comment_text = l_detail_comment_text
2601: WHERE detailid = l_detail_id AND timecard_id = l_timecard_id;
2602: ELSE
2603: INSERT INTO hxc_tk_detail_temp
2604: (detailid, timecard_id, comment_text)
2605: VALUES (l_detail_id, l_timecard_id, l_detail_comment_text);
2606: END IF;
2607:

Line 7302: FROM hxc_tk_detail_temp

7298: CURSOR c_detail (
7299: p_detailid IN NUMBER
7300: ) IS
7301: SELECT *
7302: FROM hxc_tk_detail_temp
7303: WHERE detailid = p_detailid;
7304:
7305: CURSOR c_timecard_info (
7306: p_resource_id

Line 7324: c_row hxc_tk_detail_temp%ROWTYPE;

7320: AND date_to = hr_general.end_of_time
7321: AND start_time = p_start_period
7322: AND stop_time = p_end_period;
7323:
7324: c_row hxc_tk_detail_temp%ROWTYPE;
7325:
7326: l_detail_reason_category VARCHAR2 (150);
7327: l_detail_reason_att_1 VARCHAR2 (150);
7328: l_detail_reason_att_2 VARCHAR2 (150);

Line 7986: DELETE FROM hxc_tk_detail_temp

7982: hr_utility.trace('not l_detail_dff_changed');
7983: end if;
7984: END IF;
7985:
7986: DELETE FROM hxc_tk_detail_temp
7987: WHERE detailid = l_detail_id;
7988:
7989: END IF;
7990: