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.HXT_TIME_SUMMARY dependencies on HXT_SUM_HOURS_WORKED

Line 31: g_FCL_EARN_REASON_CODE HXT_SUM_HOURS_WORKED.FCL_EARN_REASON_CODE%TYPE;--C421

27: g_HOURS NUMBER;
28: g_TIME_IN DATE;
29: g_TIME_OUT DATE;
30: g_ELEMENT_TYPE_ID NUMBER;
31: g_FCL_EARN_REASON_CODE HXT_SUM_HOURS_WORKED.FCL_EARN_REASON_CODE%TYPE;--C421
32: g_FFV_COST_CENTER_ID NUMBER;
33: g_FFV_LABOR_ACCOUNT_ID NUMBER;
34: g_TAS_ID NUMBER;
35: g_LOCATION_ID NUMBER;

Line 37: g_HRW_COMMENT HXT_SUM_HOURS_WORKED.HRW_COMMENT%TYPE;--C421

33: g_FFV_LABOR_ACCOUNT_ID NUMBER;
34: g_TAS_ID NUMBER;
35: g_LOCATION_ID NUMBER;
36: g_SHT_ID NUMBER;
37: g_HRW_COMMENT HXT_SUM_HOURS_WORKED.HRW_COMMENT%TYPE;--C421
38: g_FFV_RATE_CODE_ID NUMBER;
39: g_RATE_MULTIPLE NUMBER;
40: g_HOURLY_RATE NUMBER;
41: g_AMOUNT NUMBER;

Line 42: g_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421

38: g_FFV_RATE_CODE_ID NUMBER;
39: g_RATE_MULTIPLE NUMBER;
40: g_HOURLY_RATE NUMBER;
41: g_AMOUNT NUMBER;
42: g_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421
43: g_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421
44: g_SEQNO NUMBER;
45: g_CREATED_BY NUMBER;
46: g_CREATION_DATE DATE;

Line 43: g_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421

39: g_RATE_MULTIPLE NUMBER;
40: g_HOURLY_RATE NUMBER;
41: g_AMOUNT NUMBER;
42: g_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421
43: g_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421
44: g_SEQNO NUMBER;
45: g_CREATED_BY NUMBER;
46: g_CREATION_DATE DATE;
47: g_LAST_UPDATED_BY NUMBER;

Line 55: g_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;

51: g_LATE_STOP NUMBER;
52: g_STANDARD_START NUMBER;
53: g_STANDARD_STOP NUMBER;
54: g_PROJECT_ID NUMBER;
55: g_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
56: g_PAY_STATUS CHAR(1);
57: g_PA_STATUS CHAR(1);
58: g_PERIOD_START_DATE DATE;
59: g_RETRO_BATCH_ID NUMBER;

Line 102: g_hol_FCL_EARN_REASON_CODE HXT_SUM_HOURS_WORKED.FCL_EARN_REASON_CODE%TYPE;--C421

98: g_hol_HOURS NUMBER;
99: g_hol_TIME_IN DATE;
100: g_hol_TIME_OUT DATE;
101: g_hol_ELEMENT_TYPE_ID NUMBER;
102: g_hol_FCL_EARN_REASON_CODE HXT_SUM_HOURS_WORKED.FCL_EARN_REASON_CODE%TYPE;--C421
103: g_hol_FFV_COST_CENTER_ID NUMBER;
104: g_hol_FFV_LABOR_ACCOUNT_ID NUMBER;
105: g_hol_TAS_ID NUMBER;
106: g_hol_LOCATION_ID NUMBER;

Line 108: g_hol_HRW_COMMENT HXT_SUM_HOURS_WORKED.HRW_COMMENT%TYPE;--C421

104: g_hol_FFV_LABOR_ACCOUNT_ID NUMBER;
105: g_hol_TAS_ID NUMBER;
106: g_hol_LOCATION_ID NUMBER;
107: g_hol_SHT_ID NUMBER;
108: g_hol_HRW_COMMENT HXT_SUM_HOURS_WORKED.HRW_COMMENT%TYPE;--C421
109: g_hol_FFV_RATE_CODE_ID NUMBER;
110: g_hol_RATE_MULTIPLE NUMBER;
111: g_hol_HOURLY_RATE NUMBER;
112: g_hol_AMOUNT NUMBER;

Line 113: g_hol_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421

109: g_hol_FFV_RATE_CODE_ID NUMBER;
110: g_hol_RATE_MULTIPLE NUMBER;
111: g_hol_HOURLY_RATE NUMBER;
112: g_hol_AMOUNT NUMBER;
113: g_hol_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421
114: g_hol_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421
115: g_hol_SEQNO NUMBER;
116: g_hol_CREATED_BY NUMBER;
117: g_hol_CREATION_DATE DATE;

Line 114: g_hol_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421

110: g_hol_RATE_MULTIPLE NUMBER;
111: g_hol_HOURLY_RATE NUMBER;
112: g_hol_AMOUNT NUMBER;
113: g_hol_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421
114: g_hol_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421
115: g_hol_SEQNO NUMBER;
116: g_hol_CREATED_BY NUMBER;
117: g_hol_CREATION_DATE DATE;
118: g_hol_LAST_UPDATED_BY NUMBER;

Line 126: g_hol_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;

122: g_hol_LATE_STOP NUMBER;
123: g_hol_STANDARD_START NUMBER;
124: g_hol_STANDARD_STOP NUMBER;
125: g_hol_PROJECT_ID NUMBER;
126: g_hol_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
127: g_hol_PAY_STATUS CHAR(1);
128: g_hol_PA_STATUS CHAR(1);
129: g_hol_PERIOD_START_DATE DATE;
130: g_hol_RETRO_BATCH_ID NUMBER;

Line 134: g_hol_STATE_NAME hxt_sum_hours_worked_f.state_name%type;

130: g_hol_RETRO_BATCH_ID NUMBER;
131: g_hol_DT_UPDATE_MODE VARCHAR2(30);
132: g_hol_include_yn VARCHAR2(1);
133: g_hol_start_day_of_week VARCHAR2(30);
134: g_hol_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
135: g_hol_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
136: g_hol_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
137: g_hol_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
138:

Line 135: g_hol_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;

131: g_hol_DT_UPDATE_MODE VARCHAR2(30);
132: g_hol_include_yn VARCHAR2(1);
133: g_hol_start_day_of_week VARCHAR2(30);
134: g_hol_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
135: g_hol_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
136: g_hol_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
137: g_hol_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
138:
139: g_hol_location VARCHAR2(500);

Line 136: g_hol_CITY_NAME hxt_sum_hours_worked_f.city_name%type;

132: g_hol_include_yn VARCHAR2(1);
133: g_hol_start_day_of_week VARCHAR2(30);
134: g_hol_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
135: g_hol_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
136: g_hol_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
137: g_hol_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
138:
139: g_hol_location VARCHAR2(500);
140:

Line 137: g_hol_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;

133: g_hol_start_day_of_week VARCHAR2(30);
134: g_hol_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
135: g_hol_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
136: g_hol_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
137: g_hol_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
138:
139: g_hol_location VARCHAR2(500);
140:
141:

Line 148: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;

144: --Flags for checking which shift diff premium gets paid for a segment chunk
145: --
146: g_sdf_rule_completed VARCHAR2(1);
147: g_sdf_carryover DATE;
148: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
149: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
150: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
151: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
152:

Line 149: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;

145: --
146: g_sdf_rule_completed VARCHAR2(1);
147: g_sdf_carryover DATE;
148: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
149: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
150: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
151: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
152:
153:

Line 150: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;

146: g_sdf_rule_completed VARCHAR2(1);
147: g_sdf_carryover DATE;
148: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
149: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
150: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
151: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
152:
153:
154: --Function and Procedure declarations

Line 151: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;

147: g_sdf_carryover DATE;
148: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
149: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
150: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
151: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
152:
153:
154: --Function and Procedure declarations
155:

Line 297: FROM hxt_sum_hours_worked_f sum

293: -- less than any actual value we get, while 99999999999 is always greater than the actual
294: -- values. In the below cursor, we want the NULL values to appear greater than the ones with values.
295: CURSOR more_details
296: IS SELECT 1
297: FROM hxt_sum_hours_worked_f sum
298: WHERE tim_id = g_hol_tim_id
299: AND g_sum_session_date BETWEEN sum.effective_start_date
300: AND sum.effective_end_date
301: AND ( date_worked > g_hol_date_worked

Line 552: FROM hxt_sum_hours_worked_f sum

548:
549: CURSOR get_other_summary(p_seq_no IN NUMBER,
550: p_date IN DATE)
551: IS SELECT 1
552: FROM hxt_sum_hours_worked_f sum
553: WHERE seqno > p_seq_no
554: AND tim_id = g_hol_tim_id
555: AND g_sum_session_date BETWEEN sum.effective_start_date
556: AND sum.effective_end_date

Line 564: FROM hxt_sum_hours_worked_f sum

560:
561: CURSOR get_next_summary(p_time_in IN DATE,
562: p_date IN DATE)
563: IS SELECT 1
564: FROM hxt_sum_hours_worked_f sum
565: WHERE time_in > p_time_in
566: AND g_sum_session_date BETWEEN sum.effective_start_date
567: AND sum.effective_end_date
568: AND tim_id = g_hol_tim_id

Line 578: hxt_sum_hours_worked_f sum,

574: CURSOR get_holiday_overtime
575: IS
576: SELECT NVL(SUM(det.hours),0)
577: FROM hxt_det_hours_worked_f det,
578: hxt_sum_hours_worked_f sum,
579: hxt_earning_rules er,
580: hxt_pay_element_types_f_ddf_v elem
581: WHERE det.tim_id = g_hol_tim_id
582: AND sum.id = det.parent_id

Line 620: FROM hxt_sum_hours_worked sum,

616: CURSOR get_other_holidays(p_tim_id IN NUMBER,
617: p_date_worked IN DATE,
618: p_hol_id IN NUMBER)
619: IS SELECT 1
620: FROM hxt_sum_hours_worked sum,
621: hxt_holiday_days hhd
622: WHERE tim_id = p_tim_id
623: AND sum.date_worked > p_date_worked
624: AND hhd.hcl_id = p_hol_id

Line 664: FROM hxt_sum_hours_worked_f SUM,

660: l_element_string VARCHAR2(200);
661:
662: l_sql VARCHAR2(32000) :=
663: 'SELECT NVL(sum(sum.hours),0)
664: FROM hxt_sum_hours_worked_f SUM,
665: hxt_det_hours_worked_f DET
666: WHERE sum.tim_id = :tim_id
667: AND sum.id = det.parent_id
668: AND sum.element_type_id IS NULL

Line 828: FROM hxt_sum_hours_worked_f sum,

824: ROWIDTOCHAR(det.rowid),
825: det.tim_id,
826: det.parent_id
827: BULK COLLECT INTO l_det_tab
828: FROM hxt_sum_hours_worked_f sum,
829: hxt_det_hours_worked_f det
830: WHERE sum.element_type_id IS NULL
831: AND sum.id = det.parent_id
832: AND SYSDATE BETWEEN sum.effective_start_date

Line 2236: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

2232: SELECT '1'
2233: INTO error_code
2234: FROM SYS.DUAL
2235: WHERE EXISTS (SELECT hrw.id
2236: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
2237: WHERE hrw.tim_id = g_TIM_ID
2238: AND hrw.date_worked = g_DATE_WORKED
2239: AND hrw.time_in IS NOT NULL
2240: AND hrw.element_type_id = hei.element_type_id

Line 2247: FROM hxt_sum_hours_worked hrw

2243: AND hei.effective_end_date
2244: AND NVL(hei.exclude_from_explosion, 'N') <> 'Y'
2245: UNION
2246: SELECT hrw.id
2247: FROM hxt_sum_hours_worked hrw
2248: WHERE hrw.tim_id = g_TIM_ID
2249: AND hrw.date_worked = g_DATE_WORKED
2250: AND hrw.time_in IS NOT NULL
2251: AND hrw.element_type_id is null

Line 2258: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

2254: SELECT '1'
2255: INTO error_code
2256: FROM SYS.DUAL
2257: WHERE EXISTS (SELECT hrw.id
2258: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
2259: WHERE hrw.tim_id = g_TIM_ID
2260: AND hrw.date_worked = g_DATE_WORKED
2261: AND hrw.time_in IS NULL
2262: AND hrw.hours<>0

Line 2270: FROM hxt_sum_hours_worked hrw

2266: AND hei.effective_end_date
2267: AND NVL(hei.exclude_from_explosion, 'N') <> 'Y'
2268: UNION
2269: SELECT hrw.id
2270: FROM hxt_sum_hours_worked hrw
2271: WHERE hrw.tim_id = g_TIM_ID
2272: AND hrw.date_worked = g_DATE_WORKED
2273: AND hrw.time_in IS NULL
2274: AND hrw.hours<>0

Line 4296: FROM hxt_sum_hours_worked_f sum

4292: p_tim_id IN NUMBER,
4293: p_id IN NUMBER,
4294: p_date_worked IN DATE)
4295: IS SELECT sum(hours)
4296: FROM hxt_sum_hours_worked_f sum
4297: WHERE p_session_date BETWEEN sum.effective_start_date
4298: AND sum.effective_end_date
4299: AND date_worked = p_date_worked
4300: AND tim_id = p_tim_id