APPS.PER_NL_ABSENCE_TRACK_PKG dependencies on HRUSERDT

Line 116: /*l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

112:
113: begin
114: -- Bug# 5476730, pass l_date_start instead of p_effective_date
115:
116: /*l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
117: 'ACTION',l_row_number,p_effective_date);
118: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
119: 'TIME_PERIOD',l_row_number,p_effective_date);
120: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

Line 118: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

114: -- Bug# 5476730, pass l_date_start instead of p_effective_date
115:
116: /*l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
117: 'ACTION',l_row_number,p_effective_date);
118: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
119: 'TIME_PERIOD',l_row_number,p_effective_date);
120: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
121: 'TIME_UNITS',l_row_number,p_effective_date); */
122: l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

Line 120: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

116: /*l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
117: 'ACTION',l_row_number,p_effective_date);
118: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
119: 'TIME_PERIOD',l_row_number,p_effective_date);
120: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
121: 'TIME_UNITS',l_row_number,p_effective_date); */
122: l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
123: 'ACTION',l_row_number,l_date_start);
124: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

Line 122: l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

118: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
119: 'TIME_PERIOD',l_row_number,p_effective_date);
120: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
121: 'TIME_UNITS',l_row_number,p_effective_date); */
122: l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
123: 'ACTION',l_row_number,l_date_start);
124: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
125: 'TIME_PERIOD',l_row_number,l_date_start);
126: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

Line 124: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

120: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
121: 'TIME_UNITS',l_row_number,p_effective_date); */
122: l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
123: 'ACTION',l_row_number,l_date_start);
124: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
125: 'TIME_PERIOD',l_row_number,l_date_start);
126: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
127: 'TIME_UNITS',l_row_number,l_date_start);
128: if l_units='D' then

Line 126: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,

122: l_action := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
123: 'ACTION',l_row_number,l_date_start);
124: l_time_period := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
125: 'TIME_PERIOD',l_row_number,l_date_start);
126: l_units := hruserdt.get_table_value(l_business_group_id,l_user_table_name,
127: 'TIME_UNITS',l_row_number,l_date_start);
128: if l_units='D' then
129: l_expected_date := l_date_start + l_time_period;
130: elsif l_units='W' then