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_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_DETAILS

Line 522: INSERT INTO hxc_rdb_post_details

518: LIMIT 500;
519: EXIT WHEN restab.COUNT = 0;
520:
521: FORALL i IN restab.FIRST..restab.LAST
522: INSERT INTO hxc_rdb_post_details
523: (resource_id,
524: time_building_block_id,
525: ovn,
526: timecard_id,

Line 733: INSERT INTO hxc_rdb_post_details

729: LIMIT 500;
730: EXIT WHEN restab.COUNT = 0;
731:
732: FORALL i IN restab.FIRST..restab.LAST
733: INSERT INTO hxc_rdb_post_details
734: (resource_id,
735: time_building_block_id,
736: ovn,
737: timecard_id,

Line 902: UPDATE hxc_rdb_post_details

898: -- Update the timecard_id in the details table because they
899: -- are referenced below.
900:
901: FORALL i IN rowidtab.FIRST..rowidtab.LAST
902: UPDATE hxc_rdb_post_details
903: SET timecard_id = sumtab(i)
904: WHERE timecard_id = rdbtab(i);
905:
906:

Line 930: FROM hxc_rdb_post_details rdb

926:
927:
928: CURSOR pick_details
929: IS SELECT ROWIDTOCHAR(rdb.rowid)
930: FROM hxc_rdb_post_details rdb
931: WHERE ret_user_id = FND_GLOBAL.user_id
932: AND retro_batch_id IS NOT NULL;
933:
934: rowtab VARCHARTAB;

Line 957: UPDATE hxc_rdb_post_details

953: LOOP
954: FETCH pick_details BULK COLLECT INTO rowtab LIMIT 500;
955: EXIT WHEN rowtab.COUNT = 0;
956: FORALL i IN rowtab.FIRST..rowtab.LAST
957: UPDATE hxc_rdb_post_details
958: SET retro_batch_id = retro_batch_id||'(Retro)'
959: WHERE rowid = CHARTOROWID(rowtab(i));
960:
961: COMMIT;

Line 1082: FROM hxc_rdb_post_details

1078: attribute2,
1079: attribute3),
1080: 1,
1081: FND_GLOBAL.user_id
1082: FROM hxc_rdb_post_details
1083: WHERE rec_line_id IS NOT NULL
1084: AND ret_user_id = FND_GLOBAL.user_id
1085: UNION
1086: SELECT DISTINCT '0' batch_id,

Line 1095: FROM hxc_rdb_post_details

1091: attribute2,
1092: attribute3),
1093: 1,
1094: FND_GLOBAL.user_id
1095: FROM hxc_rdb_post_details
1096: WHERE rec_line_id IS NOT NULL
1097: AND ret_user_id = FND_GLOBAL.user_id;
1098:
1099:

Line 1119: FROM hxc_rdb_post_details

1115: old_attribute2,
1116: old_attribute3),
1117: -1,
1118: FND_GLOBAL.user_id
1119: FROM hxc_rdb_post_details
1120: WHERE rec_retro_line_id IS NOT NULL
1121: AND ret_user_id = FND_GLOBAL.user_id
1122: UNION
1123: SELECT DISTINCT '0' retro_batch_id,

Line 1132: FROM hxc_rdb_post_details

1128: old_attribute2,
1129: old_attribute3),
1130: -1,
1131: FND_GLOBAL.user_id
1132: FROM hxc_rdb_post_details
1133: WHERE rec_retro_line_id IS NOT NULL
1134: AND ret_user_id = FND_GLOBAL.user_id;
1135:
1136:

Line 1222: FROM hxc_rdb_post_details

1218: hrs_pm,
1219: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1220: hrs_pm) ,
1221: fnd_global.user_id
1222: FROM hxc_rdb_post_details
1223: WHERE ret_user_id = FND_GLOBAL.user_id
1224: AND batch_id IS NOT NULL
1225: UNION
1226: SELECT DISTINCT retro_batch_id,

Line 1231: FROM hxc_rdb_post_details

1227: hrs_pm,
1228: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1229: hrs_pm) ,
1230: fnd_global.user_id
1231: FROM hxc_rdb_post_details
1232: WHERE ret_user_id = FND_GLOBAL.user_id
1233: AND retro_batch_id IS NOT NULL
1234: UNION
1235: SELECT DISTINCT '0' batch_id,

Line 1239: FROM hxc_rdb_post_details

1235: SELECT DISTINCT '0' batch_id,
1236: hrs_pm,
1237: COUNT(DISTINCT timecard_id) OVER (PARTITION BY hrs_pm) measure,
1238: fnd_global.user_id
1239: FROM hxc_rdb_post_details
1240: WHERE ret_user_id = FND_GLOBAL.user_id;
1241:
1242: COMMIT;
1243: END IF;

Line 2086: FROM hxc_rdb_post_details

2082: WHERE ret_user_id = FND_GLOBAL.user_id;
2083:
2084: CURSOR get_old_details
2085: IS SELECT ROWIDTOCHAR(ROWID)
2086: FROM hxc_rdb_post_details
2087: WHERE ret_user_id = FND_GLOBAL.user_id;
2088:
2089: rowtab VARCHARTAB;
2090:

Line 2112: DELETE FROM hxc_rdb_post_details

2108: FETCH get_old_details BULK COLLECT INTO rowtab LIMIT 500;
2109: EXIT WHEN rowtab.COUNT = 0;
2110:
2111: FORALL i IN rowtab.FIRST..rowtab.LAST
2112: DELETE FROM hxc_rdb_post_details
2113: WHERE ROWID = CHARTOROWID(rowtab(i));
2114:
2115: COMMIT;
2116:

Line 2240: FROM hxc_rdb_post_details det

2236: NULL,
2237: NULL,
2238: timecard_id,
2239: FND_GLOBAL.user_id
2240: FROM hxc_rdb_post_details det
2241: WHERE timecard_id = p_timecard_id
2242: AND rec_line_id IS NOT NULL
2243: AND ret_user_id = FND_GLOBAL.user_id
2244: UNION

Line 2260: FROM hxc_rdb_post_details det

2256: old_batch_id,
2257: old_request_id,
2258: timecard_id,
2259: FND_GLOBAL.user_id
2260: FROM hxc_rdb_post_details det
2261: WHERE timecard_id = p_timecard_id
2262: AND rec_retro_line_id IS NOT NULL
2263: AND ret_user_id = FND_GLOBAL.user_id ;
2264: