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_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_RPT_TC_DETAILS_ALL

Line 254: -- already collected from HXC_RPT_TC_HIST_LOG and HXC_RPT_TC_DETAILS_ALL.

250:
251:
252: -- CLEAR_HISTORY_DATA
253: -- If chosen to regenerate all data and clear history data, deletes all information
254: -- already collected from HXC_RPT_TC_HIST_LOG and HXC_RPT_TC_DETAILS_ALL.
255:
256: PROCEDURE clear_history_data
257: AS
258:

Line 263: -- Delete from HXC_RPT_TC_DETAILS_ALL

259: BEGIN
260:
261: -- Public Procedure clear_history_data
262: -- Delete from HXC_RPT_TC_HIST_LOG
263: -- Delete from HXC_RPT_TC_DETAILS_ALL
264: -- Commit the changes.
265:
266: IF g_debug
267: THEN

Line 273: DELETE FROM hxc_rpt_tc_details_all;

269: END IF;
270:
271: DELETE FROM hxc_rpt_tc_hist_log;
272:
273: DELETE FROM hxc_rpt_tc_details_all;
274:
275: COMMIT;
276:
277: IF g_debug

Line 322: -- captured into HXC_RPT_TC_DETAILS_ALL for all the

318: BEGIN
319:
320: -- Public Procedure fetch_history_from_date
321: -- Look into HXC_RPT_TC_HIST_LOG to find out upto which details are
322: -- captured into HXC_RPT_TC_DETAILS_ALL for all the
323: -- resource_id-tc_start_time-tc_stop_time combinations loaded
324: -- right now into HXC_RPT_TC_RESOURCE_TEMP.
325: -- Update these values as history_from_date in HXC_RPT_TC_RESOURCE_TEMP
326: -- for corresponding resource_id-tc_start_time-tc_stop_time

Line 481: hxc_rpt_tc_details_all det,

477: bb.date_to,
478: bb.last_update_date,
479: bb.last_updated_by
480: FROM hxc_rpt_tc_resource_temp gt,
481: hxc_rpt_tc_details_all det,
482: hxc_time_building_blocks bb
483: WHERE bb.scope = 'DETAIL'
484: AND bb.time_building_block_id = det.detail_bb_id
485: AND bb.object_version_number = det.detail_bb_ovn

Line 500: -- HXC_RPT_TC_DETAILS_ALL table.

496: BEGIN
497:
498: -- Public Procedure update_last_touched_date
499: -- Used for those detail records that are already collected in
500: -- HXC_RPT_TC_DETAILS_ALL table.
501: -- For those records in HXC_RPT_TC_DETAILS_ALL which belong to
502: -- the timecard records in HXC_RPT_TC_RESOURCE_TEMP, get the
503: -- last_updated_date, last_updated_by, and date_to values
504: -- from HXC_TIME_BUILDING_BLOCKS table, if the date_to column

Line 501: -- For those records in HXC_RPT_TC_DETAILS_ALL which belong to

497:
498: -- Public Procedure update_last_touched_date
499: -- Used for those detail records that are already collected in
500: -- HXC_RPT_TC_DETAILS_ALL table.
501: -- For those records in HXC_RPT_TC_DETAILS_ALL which belong to
502: -- the timecard records in HXC_RPT_TC_RESOURCE_TEMP, get the
503: -- last_updated_date, last_updated_by, and date_to values
504: -- from HXC_TIME_BUILDING_BLOCKS table, if the date_to column
505: -- is different.

Line 507: -- and date_to columns in HXC_RPT_TC_DETAILS_ALL

503: -- last_updated_date, last_updated_by, and date_to values
504: -- from HXC_TIME_BUILDING_BLOCKS table, if the date_to column
505: -- is different.
506: -- Update all such records with the last_updated_date, last_updated_by
507: -- and date_to columns in HXC_RPT_TC_DETAILS_ALL
508:
509:
510: IF g_debug
511: THEN

Line 535: UPDATE hxc_rpt_tc_details_all

531:
532: IF bb_id_tab.COUNT > 0
533: THEN
534: FORALL i IN bb_id_tab.FIRST..bb_id_tab.LAST
535: UPDATE hxc_rpt_tc_details_all
536: SET last_update_date = update_date_tab(i),
537: last_updated_by = update_user_tab(i),
538: last_updated_by_user = NULL,
539: date_to = date_to_tab(i)

Line 558: -- For all the records recorded in a previous run in HXC_RPT_TC_DETAILS_ALL

554: END update_last_touched_date;
555:
556:
557: -- UPDATE_TIMECARD_COMMENTS
558: -- For all the records recorded in a previous run in HXC_RPT_TC_DETAILS_ALL
559: -- updates the timecard comments, if they were changed.
560:
561:
562: PROCEDURE update_timecard_comments

Line 571: hxc_rpt_tc_details_all det,

567: comment_text,
568: detail_bb_id,
569: detail_bb_ovn
570: FROM hxc_time_building_blocks bb,
571: hxc_rpt_tc_details_all det,
572: hxc_rpt_tc_resource_temp gt
573: WHERE bb.time_building_block_id = det.tc_bb_id
574: AND bb.object_version_number = det.tc_bb_ovn
575: AND bb.comment_text IS NOT NULL

Line 586: -- For all the records previously loaded into HXC_RPT_TC_DETAILS_ALL

582:
583: BEGIN
584:
585: -- Public Procedure update_timecard_comments
586: -- For all the records previously loaded into HXC_RPT_TC_DETAILS_ALL
587: -- query from HXC_TIME_BUILDING_BLOCKS, their relevant timecard
588: -- comments.
589: -- Update HXC_RPT_TC_DETAILS_ALL with the comments picked up above.
590:

Line 589: -- Update HXC_RPT_TC_DETAILS_ALL with the comments picked up above.

585: -- Public Procedure update_timecard_comments
586: -- For all the records previously loaded into HXC_RPT_TC_DETAILS_ALL
587: -- query from HXC_TIME_BUILDING_BLOCKS, their relevant timecard
588: -- comments.
589: -- Update HXC_RPT_TC_DETAILS_ALL with the comments picked up above.
590:
591: IF g_debug
592: THEN
593: hr_utility.trace('Starting update_timecard_comments');

Line 614: UPDATE hxc_rpt_tc_details_all

610:
611: IF det_bb_tab.COUNT > 0
612: THEN
613: FORALL i IN det_bb_tab.FIRST..det_bb_tab.LAST
614: UPDATE hxc_rpt_tc_details_all
615: SET tc_comments = comment_tab(i)
616: WHERE detail_bb_id = det_bb_tab(i)
617: AND detail_bb_ovn = det_ovn_tab(i);
618: END IF;

Line 641: -- is put into HXC_RPT_TC_DETAILS_ALL table.

637:
638:
639: -- LOAD_DETAIL_INFO
640: -- Now that all history records are processed, new detail information
641: -- is put into HXC_RPT_TC_DETAILS_ALL table.
642:
643:
644: PROCEDURE load_detail_info ( p_request_sysdate IN DATE)
645: AS

Line 650: -- Insert into HXC_RPT_TC_DETAILS_ALL detail information

646:
647: BEGIN
648:
649: -- Public Procedure load_detail_info
650: -- Insert into HXC_RPT_TC_DETAILS_ALL detail information
651: -- and day information from HXC_TIME_BUILDING_BLOCKS
652: -- WHERE clauses are placed taking care that data is picked up
653: -- only from the history_from_date already recorded -- meaning
654: -- we need data that is not existing only. Anyways, at this

Line 657: -- in HXC_RPT_TC_DETAILS_ALL.

653: -- only from the history_from_date already recorded -- meaning
654: -- we need data that is not existing only. Anyways, at this
655: -- point, an already existing detail is picked up again, the request
656: -- will error out, as there is a primary key on detail bb id and ovn
657: -- in HXC_RPT_TC_DETAILS_ALL.
658:
659: IF g_debug
660: THEN
661: hr_utility.trace('load_detail_info begins '||p_request_sysdate);

Line 664: INSERT INTO hxc_rpt_tc_details_all

660: THEN
661: hr_utility.trace('load_detail_info begins '||p_request_sysdate);
662: END IF;
663:
664: INSERT INTO hxc_rpt_tc_details_all
665: ( resource_id,
666: tc_start_time,
667: tc_stop_time,
668: tc_bb_id,

Line 736: -- For all the detail time loaded via this request into HXC_RPT_TC_DETAILS_ALL

732: END load_detail_info;
733:
734:
735: -- POPULATE_ATTRIBUTES
736: -- For all the detail time loaded via this request into HXC_RPT_TC_DETAILS_ALL
737: -- populate the relevant (those visible to the user; no hidden values ) time attributes
738: -- from HXC_TIME_ATTRIBUTES.
739:
740:

Line 805: hxc_rpt_tc_details_all det,

801: ';
802: dynamic_cursor_where VARCHAR2(2000);
803: l_dynamic_cursor_where VARCHAR2(2000) := '
804: FROM hxc_rpt_tc_resource_temp gt,
805: hxc_rpt_tc_details_all det,
806: hxc_time_attribute_usages hau,
807: hxc_time_attributes ha
808: WHERE gt.tc_bb_id = det.tc_bb_id
809: AND gt.layout_id = curr_layout_id

Line 843: UPDATE hxc_rpt_tc_details_all

839: dynamic_update VARCHAR2(2000);
840: l_dynamic_update VARCHAR2(2000) :=
841: ' IF det_bb_id_tab.COUNT > 0 THEN
842: FORALL i IN det_bb_id_tab.FIRST..det_bb_id_tab.LAST
843: UPDATE hxc_rpt_tc_details_all
844: SET cla_reason = cla_reason_tab(i),
845: cla_comments = cla_comments_tab(i),
846: cla_type = cla_type_tab(i),';
847: dynamic_update_where VARCHAR2(1000);

Line 945: -- hxc_rpt_tc_details_all det,

941: -- MAX(DECODE(ATTRIBUTE_CATEGORY,'REASON',ha.ATTRIBUTE3)),
942: -- MAX(DECODE(ATTRIBUTE_CATEGORY,'APPROVAL',ha.Attribute10))
943: -- ,MAX(DECODE(ATTRIBUTE_CATEGORY,'Dummy Cost Context',ha.Attribute1))
944: -- FROM hxc_rpt_tc_resource_temp gt,
945: -- hxc_rpt_tc_details_all det,
946: -- hxc_time_attribute_usages hau,
947: -- hxc_time_attributes ha
948: -- WHERE gt.tc_bb_id = det.tc_bb_id
949: -- AND gt.layout_id = 7

Line 970: -- UPDATE hxc_rpt_tc_details_all

966: -- display_val3;
967: -- CLOSE get_attributes;
968: -- IF det_bb_id_tab.COUNT > 0 THEN
969: -- FORALL i IN det_bb_id_tab.FIRST..det_bb_id_tab.LAST
970: -- UPDATE hxc_rpt_tc_details_all
971: -- SET cla_reason = cla_reason_tab(i),
972: -- cla_comments = cla_comments_tab(i),
973: -- cla_type = cla_type_tab(i),
974: -- attribute1 = display_val1(i),

Line 1026: -- this determines which of the 30 Attributes in HXC_RPT_TC_DETAILS_ALL

1022: -- * l_layout_fld_name
1023: -- For eg. Hours Type
1024: -- * l_layout_fld_rownum
1025: -- The rank in terms of layout_component_id. Plays a key role because
1026: -- this determines which of the 30 Attributes in HXC_RPT_TC_DETAILS_ALL
1027: -- are used for this component.
1028: --
1029: -- Inline comments are put in below for reference.
1030: --

Line 1149: -- Translates the attributes already loaded into HXC_RPT_TC_DETAILS_ALL table

1145: END populate_attributes;
1146:
1147:
1148: -- TRANSLATE_ATTRIBUTES
1149: -- Translates the attributes already loaded into HXC_RPT_TC_DETAILS_ALL table
1150: -- against the queries in HXC_RPT_LAYOUT_COMP_QUERIES
1151:
1152:
1153: PROCEDURE translate_attributes(p_layout_id NUMBER)

Line 1166: hxc_rpt_tc_details_all hx

1162: l_curr_layout NUMBER(15);
1163:
1164: l_update_predicate VARCHAR2(4000) :=
1165: ' UPDATE /*+ INDEX(hx HXC_RPT_TC_DETAILS_FK2) */
1166: hxc_rpt_tc_details_all hx
1167: SET ';
1168:
1169: l_update_where VARCHAR2(4000) :=
1170: ' WHERE tc_bb_id IN ( SELECT tc_bb_id

Line 1284: FROM hxc_rpt_tc_details_all det,

1280:
1281: dynamic_where VARCHAR2(2000);
1282: l_dynamic_where VARCHAR2(2000) :=
1283: ' '' ''
1284: FROM hxc_rpt_tc_details_all det,
1285: hxc_rpt_tc_resource_temp gt,
1286: hxc_time_attribute_usages hau,
1287: hxc_time_attributes ha
1288: WHERE gt.tc_bb_id = det.tc_bb_id

Line 1348: UPDATE hxc_rpt_tc_details_all

1344: CLOSE get_alias_values;
1345: END LOOP;
1346:
1347: FORALL i IN det_bb_id_tab.FIRST..det_bb_id_tab.LAST
1348: UPDATE hxc_rpt_tc_details_all
1349: set attributeATTR_COL = ''ALIASNAME: ''||alias_value(i)
1350: WHERE detail_bb_id = det_bb_id_tab(i)
1351: AND detail_bb_ovn = det_bb_ovn_tab(i);
1352: END IF;

Line 1401: -- loading the translated alias values into HXC_RPT_TC_DETAILS_ALL.

1397: -- Public Procedure translate_aliases
1398: -- Like Populate_attributes, this is also very much processing intensive.
1399: -- Creates a dynamic pl/sql block from the sql string bits and pieces,
1400: -- depending on the alias definition ids and executes the same
1401: -- loading the translated alias values into HXC_RPT_TC_DETAILS_ALL.
1402: -- Pasted below is a sample Pl/Sql block created in one of the test runs.
1403:
1404: -- -----------------------------
1405: --

Line 1421: -- FROM hxc_rpt_tc_details_all det,

1417: -- detail_bb_ovn,
1418: -- MAX(DECODE(bld_blk_info_type_id,1,LTRIM(ha.ATTRIBUTE_CATEGORY,'ELEMENT - '))),
1419: -- MAX(DECODE(bld_blk_info_type_id,201,ha.ATTRIBUTE1)),
1420: -- ' '
1421: -- FROM hxc_rpt_tc_details_all det,
1422: -- hxc_rpt_tc_resource_temp gt,
1423: -- hxc_time_attribute_usages hau,
1424: -- hxc_time_attributes ha
1425: -- WHERE gt.tc_bb_id = det.tc_bb_id

Line 1466: -- UPDATE hxc_rpt_tc_details_all

1462: -- alias_value(i);
1463: -- CLOSE get_alias_values;
1464: -- END LOOP;
1465: -- FORALL i IN det_bb_id_tab.FIRST..det_bb_id_tab.LAST
1466: -- UPDATE hxc_rpt_tc_details_all
1467: -- set attribute2 = 'Hours Type : '||alias_value(i)
1468: -- WHERE detail_bb_id = det_bb_id_tab(i)
1469: -- AND detail_bb_ovn = det_bb_ovn_tab(i);
1470: -- END IF;

Line 1653: FROM hxc_rpt_tc_details_all det,

1649: IS SELECT flv.meaning,
1650: rtrim(substr(flv.lookup_type,5,6),'_A'),
1651: det.detail_bb_id,
1652: det.detail_bb_ovn
1653: FROM hxc_rpt_tc_details_all det,
1654: hxc_rpt_tc_resource_temp gt,
1655: fnd_lookup_values flv
1656: WHERE gt.request_id = det.request_id
1657: AND gt.resource_id = det.resource_id

Line 1677: -- Fetch all the lookup codes for CLA reasons from HXC_RPT_TC_DETAILS_ALL

1673:
1674: BEGIN
1675:
1676: -- Public Procedure translate_cla_reasons
1677: -- Fetch all the lookup codes for CLA reasons from HXC_RPT_TC_DETAILS_ALL
1678: -- wherever they exist.
1679: -- Fetch the corresponding Lookup names from FND_LOOKUP_VALUES.
1680: -- Update HXC_RPT_TC_DETAILS_ALL with the relevant lookup names
1681:

Line 1680: -- Update HXC_RPT_TC_DETAILS_ALL with the relevant lookup names

1676: -- Public Procedure translate_cla_reasons
1677: -- Fetch all the lookup codes for CLA reasons from HXC_RPT_TC_DETAILS_ALL
1678: -- wherever they exist.
1679: -- Fetch the corresponding Lookup names from FND_LOOKUP_VALUES.
1680: -- Update HXC_RPT_TC_DETAILS_ALL with the relevant lookup names
1681:
1682: IF g_debug
1683: THEN
1684: hr_utility.trace('translate_cla_reasons');

Line 1705: UPDATE hxc_rpt_tc_details_all

1701:
1702: IF l_meaning_tab.COUNT > 0
1703: THEN
1704: FORALL i IN l_meaning_tab.FIRST..l_meaning_tab.LAST
1705: UPDATE hxc_rpt_tc_details_all
1706: SET cla_reason = l_meaning_tab(i)
1707: WHERE detail_bb_id = l_det_bb_id_tab(i)
1708: AND detail_bb_ovn = l_det_bb_ovn_tab(i)
1709: AND cla_type = l_type_tab(i) ;

Line 1737: -- chosen detail records from HXC_RPT_TC_DETAILS_ALL.

1733:
1734:
1735: -- UPDATE_TRANSACTION_IDS
1736: -- Finds out the relevant transaction_ids and transaction_detail_ids for the
1737: -- chosen detail records from HXC_RPT_TC_DETAILS_ALL.
1738:
1739: PROCEDURE update_transaction_ids(p_record_save IN VARCHAR2)
1740: AS
1741:

Line 1751: FROM hxc_rpt_tc_details_all det,

1747: htd.transaction_id,
1748: htd.transaction_detail_id,
1749: det.detail_bb_id,
1750: det.detail_bb_ovn
1751: FROM hxc_rpt_tc_details_all det,
1752: hxc_rpt_tc_resource_temp gt,
1753: hxc_transaction_details htd,
1754: hxc_transactions ht
1755: WHERE gt.tc_start_time = det.tc_start_time

Line 1775: FROM hxc_rpt_tc_details_all det,

1771: htd.transaction_id,
1772: htd.transaction_detail_id,
1773: det.detail_bb_id,
1774: det.detail_bb_ovn
1775: FROM hxc_rpt_tc_details_all det,
1776: hxc_rpt_tc_resource_temp gt,
1777: hxc_dep_transaction_details htd,
1778: hxc_dep_transactions ht
1779: WHERE gt.tc_start_time = det.tc_start_time

Line 1794: -- hxc_rpt_tc_details_all, grouped by creation_date.

1790:
1791: --
1792: --
1793: -- The following complex cursor pulls out the records from
1794: -- hxc_rpt_tc_details_all, grouped by creation_date.
1795: --
1796: -- After the update above, the records would have transaction_id
1797: -- populated if they belong to a SUBMIT action. The inner query
1798: -- with DENSE_RANK would pull out these records with a

Line 1835: FROM hxc_rpt_tc_details_all det,

1831: ORDER BY creation_date) dense,
1832: det.resource_id,
1833: det.tc_start_time,
1834: det.tc_stop_time
1835: FROM hxc_rpt_tc_details_all det,
1836: hxc_rpt_tc_resource_temp temp
1837: WHERE temp.resource_id = det.resource_id
1838: AND temp.tc_start_time = det.tc_start_time
1839: AND temp.tc_stop_time = det.tc_stop_time

Line 1866: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,

1862:
1863: BEGIN
1864:
1865: -- Public Procedure update_transaction_ids
1866: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,
1867: -- and HXC_TRANSACTIONS to pick up all the transactions and
1868: -- transaction_details for a successful deposit.
1869: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
1870: -- If p_record_save is set to Y, we need to give pseudo transaction_ids

Line 1869: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.

1865: -- Public Procedure update_transaction_ids
1866: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,
1867: -- and HXC_TRANSACTIONS to pick up all the transactions and
1868: -- transaction_details for a successful deposit.
1869: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
1870: -- If p_record_save is set to Y, we need to give pseudo transaction_ids
1871: -- to the working status timecards. Do it in the following way.
1872:
1873: -- Note: This needs to be carried out only for Self Service time entry.

Line 1975: UPDATE hxc_rpt_tc_details_all

1971:
1972: IF det_bb_id_tab.COUNT > 0
1973: THEN
1974: FORALL i IN det_bb_id_tab.FIRST..det_bb_id_tab.LAST
1975: UPDATE hxc_rpt_tc_details_all
1976: SET transaction_id = det_trans_id_tab(i),
1977: transaction_detail_id = det_trans_detail_id_tab(i)
1978: WHERE detail_bb_id = det_bb_id_tab(i)
1979: AND detail_bb_ovn = det_bb_ovn_tab(i);

Line 2013: UPDATE hxc_rpt_tc_details_all

2009:
2010: IF det_bb_id_tab.COUNT > 0
2011: THEN
2012: FORALL i IN det_bb_id_tab.FIRST..det_bb_id_tab.LAST
2013: UPDATE hxc_rpt_tc_details_all
2014: SET transaction_id = det_trans_id_tab(i),
2015: transaction_detail_id = det_trans_detail_id_tab(i)
2016: WHERE detail_bb_id = det_bb_id_tab(i)
2017: AND detail_bb_ovn = det_bb_ovn_tab(i);

Line 2104: UPDATE hxc_rpt_tc_details_all

2100:
2101: IF creation_tab.COUNT > 0
2102: THEN
2103: FORALL i IN creation_tab.FIRST..creation_tab.LAST
2104: UPDATE hxc_rpt_tc_details_all
2105: SET transaction_id = trans_tab(i)+fac_tab(i)
2106: WHERE resource_id = res_id_tab(i)
2107: AND tc_start_time = start_timetab(i)
2108: AND tc_stop_time = stop_timetab(i)

Line 2152: hxc_rpt_tc_details_all det,

2148: det.detail_bb_ovn,
2149: fnd.user_name||newline||'['||
2150: ppf.full_name||']'
2151: FROM hxc_rpt_tc_resource_temp gt,
2152: hxc_rpt_tc_details_all det,
2153: fnd_user fnd,
2154: per_all_people_f ppf
2155: WHERE gt.tc_bb_id = det.tc_bb_id
2156: AND gt.request_id = p_request_id

Line 2174: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.

2170: -- Public Procedure translate_created_by
2171: -- Find out user_name for the corresponding user_ids from FND_USER
2172: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from
2173: -- FND_USER.
2174: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2175:
2176: IF g_debug
2177: THEN
2178: hr_utility.trace('translate_created_by');

Line 2199: UPDATE hxc_rpt_tc_details_all

2195:
2196: IF l_bb_id_tab.COUNT > 0
2197: THEN
2198: FORALL i IN l_bb_id_tab.FIRST..l_bb_id_tab.LAST
2199: UPDATE hxc_rpt_tc_details_all
2200: SET created_by_user = l_person_tab(i)
2201: WHERE detail_bb_id = l_bb_id_tab(i)
2202: AND detail_bb_ovn = l_bb_ovn_tab(i);
2203:

Line 2238: hxc_rpt_tc_details_all det,

2234: det.detail_bb_ovn,
2235: fnd.user_name||newline||'['||
2236: ppf.full_name||']'
2237: FROM hxc_rpt_tc_resource_temp gt,
2238: hxc_rpt_tc_details_all det,
2239: fnd_user fnd,
2240: per_all_people_f ppf
2241: WHERE gt.tc_bb_id = det.tc_bb_id
2242: AND gt.request_id = p_request_id

Line 2259: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.

2255: -- Public Procedure translate_last_updated_by
2256: -- Find out user_name for the corresponding user_ids from FND_USER
2257: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from
2258: -- FND_USER.
2259: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2260:
2261:
2262: IF g_debug
2263: THEN

Line 2288: UPDATE hxc_rpt_tc_details_all

2284:
2285: IF l_bb_id_tab.COUNT > 0
2286: THEN
2287: FORALL i IN l_bb_id_tab.FIRST..l_bb_id_tab.LAST
2288: UPDATE hxc_rpt_tc_details_all
2289: SET last_updated_by_user = l_person_tab(i)
2290: WHERE detail_bb_id = l_bb_id_tab(i)
2291: AND detail_bb_ovn = l_bb_ovn_tab(i);
2292:

Line 2446: -- HXC_RPT_TC_HIST_LOG and HXC_RPT_TC_DETAILS_ALL.

2442: -- Get the request id and sysdates.
2443: -- Pass on the parameters to create the resources list ( comma separated, groups
2444: -- of 20).
2445: -- If chosen to delete history data and recreate, delete all info from
2446: -- HXC_RPT_TC_HIST_LOG and HXC_RPT_TC_DETAILS_ALL.
2447: -- For each valid list of resources picked, execute load_tc_level_info.
2448: -- Execute fetch_history_from_date to get the date from which history has to
2449: -- be considered for each timecard.
2450: -- If chosen to reuse history data, execute update_last_touched_date.

Line 2452: -- Load the detail and day level info to HXC_RPT_TC_DETAILS_ALL.

2448: -- Execute fetch_history_from_date to get the date from which history has to
2449: -- be considered for each timecard.
2450: -- If chosen to reuse history data, execute update_last_touched_date.
2451: -- Update the layout_ids for the timecards.
2452: -- Load the detail and day level info to HXC_RPT_TC_DETAILS_ALL.
2453: -- Update the timecard comments.
2454: -- Loop thru all the distinct layout_ids picked out.
2455: -- For each layout id
2456: -- * Populate the attributes for the details

Line 2694: -- HXC_RPT_TC_DETAILS_ALL that carries a given component.

2690: -- Public Procedure insert_queries
2691: -- Not used by Load Timecard Snapshot Request.
2692: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES
2693: -- Inserts the relevant layout information and column name of
2694: -- HXC_RPT_TC_DETAILS_ALL that carries a given component.
2695:
2696: OPEN get_comp_rank ( p_vo_name);
2697:
2698: FETCH get_comp_rank BULK COLLECT