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 FND_USER

Line 2149: fnd.user_name||newline||'['||

2145: CURSOR get_created_user ( p_request_id VARCHAR2 )
2146: IS SELECT /*+ ORDERED */
2147: det.detail_bb_id,
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,

Line 2153: fnd_user fnd,

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
2157: AND det.created_by = fnd.user_id

Line 2157: AND det.created_by = fnd.user_id

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
2157: AND det.created_by = fnd.user_id
2158: AND fnd.employee_id = ppf.person_id
2159: AND det.day_start_time BETWEEN ppf.effective_start_date
2160: AND ppf.effective_end_date
2161: AND det.created_by_user IS NULL ;

Line 2171: -- Find out user_name for the corresponding user_ids from FND_USER

2167: BEGIN
2168:
2169:
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:

Line 2173: -- FND_USER.

2169:
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

Line 2235: fnd.user_name||newline||'['||

2231: CURSOR get_updated_user ( p_request_id VARCHAR2)
2232: IS SELECT /*+ ORDERED */
2233: det.detail_bb_id,
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,

Line 2239: fnd_user fnd,

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
2243: AND det.last_updated_by = fnd.user_id

Line 2243: AND det.last_updated_by = fnd.user_id

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
2243: AND det.last_updated_by = fnd.user_id
2244: AND fnd.employee_id = ppf.person_id
2245: AND det.day_start_time BETWEEN ppf.effective_start_date
2246: AND ppf.effective_end_date
2247: AND det.last_updated_by_user IS NULL ;

Line 2256: -- Find out user_name for the corresponding user_ids from FND_USER

2252:
2253: BEGIN
2254:
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:

Line 2258: -- FND_USER.

2254:
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