[Home] [Help]
3588: g_user_id,
3589: g_sysdatetime,
3590: g_login_id,
3591: trunc(g_sess_date),
3592: hr_general.end_of_time);
3593: */
3594:
3595: /* Call dml to insert new timecard. */
3596: IF g_debug
3614: p_last_update_login => g_login_id,
3615: p_payroll_id => i_payroll_id,
3616: p_status => NULL,
3617: p_effective_start_date => TRUNC (g_sess_date),
3618: p_effective_end_date => hr_general.end_of_time,
3619: p_object_version_number => l_object_version_number
3620: );
3621: --
3622: o_timecard_id := l_timecard_id;
5060: i_rate_multiple,
5061: i_hourly_rate,
5062: i_amount,
5063: TRUNC(g_sess_date),
5064: hr_general.end_of_time);
5065: */
5066:
5067: /* Call dml to insert hours */
5068: hxt_dml.insert_hxt_sum_hours_worked
5096: p_last_update_login => i_last_update_login,
5097: p_actual_time_in => i_start_time,
5098: p_actual_time_out => i_end_time,
5099: p_effective_start_date => TRUNC (g_sess_date),
5100: p_effective_end_date => hr_general.end_of_time,
5101: p_project_id => i_project_id,
5102: p_prev_wage_code => i_wage_code,
5103: p_job_id => NULL,
5104: p_earn_pol_id => i_earn_pol_id,
5350: i_rate_multiple, -- SIR290 tsm.rate_multiple,
5351: i_hourly_rate, -- SIR290 tsm.hourly_rate,
5352: i_amount, -- SIR290 tsm.amount,
5353: trunc(g_sess_date),
5354: hr_general.end_of_time
5355: FROM HXT_SUM_HOURS_WORKED_F TSM
5356: WHERE ROWID = v_row_id;
5357: */
5358: SELECT tsm.ID, tsm.tim_id, tsm.seqno
5396: p_last_update_login => i_last_update_login,
5397: p_actual_time_in => i_start_time,
5398: p_actual_time_out => i_end_time,
5399: p_effective_start_date => TRUNC (g_sess_date),
5400: p_effective_end_date => hr_general.end_of_time,
5401: p_project_id => i_project_id,
5402: p_prev_wage_code => i_wage_code,
5403: p_job_id => NULL,
5404: p_earn_pol_id => i_earn_pol_id,
5746: i_last_update_login,
5747: i_start_date,
5748: NULL,
5749: TRUNC (g_sess_date),
5750: hr_general.end_of_time,
5751: i_project_id -- p_PROJECT_ID
5752: ,
5753: NULL -- p_job_id
5754: ,