APPS.HXT_RETRO_PA dependencies on HXT_DET_HOURS_WORKED_F

Line 146: UPDATE hxt_det_hours_worked_f

142: g_err_effective_start := l_timecard_rec.effective_start_date;
143: g_err_effective_end := l_timecard_rec.effective_end_date;
144:
145: -- Update all retro rows processed to show completed
146: UPDATE hxt_det_hours_worked_f
147: SET pa_status = 'C'
148: WHERE rowid IN (SELECT d.rowid
149: FROM hxt_det_hours_worked_x d
150: WHERE d.pa_status = 'R'

Line 240: Values in the pa_status column on the hxt_det_hours_worked_f (details) table

236: non_eff_wage_rate_transfer()
237: Processing of transfer to Project Accounting for all Time details not
238: processed as a part of the Effective Wage Rate Logic.
239:
240: Values in the pa_status column on the hxt_det_hours_worked_f (details) table
241: should be interpreted as follows:
242:
243: P - pending: this row has not yet been successfully processed by any transfer Logic
244:

Line 378: FROM hxt_det_hours_worked_f detf

374: c_job_id NUMBER)IS
375: SELECT detf.hours,
376: detf.id,
377: detf.rowid row_id
378: FROM hxt_det_hours_worked_f detf
379: WHERE detf.parent_id = c_parent_id
380: AND detf.project_id = c_project_id
381: AND NVL(detf.tas_id,-1) = NVL(c_task_id,-1)
382: AND detf.element_type_id = c_element_type_id

Line 424: FROM hxt_det_hours_worked_f det,

420: asg.organization_id,
421: det.element_type_id, --SIR162
422: asg.assignment_id,
423: asg.assignment_number
424: FROM hxt_det_hours_worked_f det,
425: per_pay_proposals pro,
426: per_pay_bases ppb,
427: hr_lookups fcl, --FORMS60
428: hr_lookups fcl2, --FORMS60

Line 641: UPDATE hxt_det_hours_worked_f

637: RAISE l_adjusting_error;
638: END IF;
639:
640: -- Update the expired (now adjusted) row so we don't pick it up again.
641: UPDATE hxt_det_hours_worked_f
642: SET pa_status = 'A'
643: WHERE rowid = l_expired_rec.row_id;
644:
645: ELSE

Line 651: UPDATE hxt_det_hours_worked_f

647: -- Update expired rows matching exactly to 'D' for dead
648: -- No new identical PA transaction will be sent because one already exists in PA
649: -- The retro detail row replacing this one will be set to 'C' complete outside of the loops
650:
651: UPDATE hxt_det_hours_worked_f
652: SET pa_status = 'D'
653: WHERE rowid = l_expired_rec.row_id;
654:
655: END IF; -- identical entry

Line 819: UPDATE hxt_det_hours_worked_f

815: RAISE l_adjusting_error;
816: END IF;
817:
818: -- Update the expired (now adjusted) row so we don't pick it up again.
819: UPDATE hxt_det_hours_worked_f
820: SET pa_status = 'A'
821: WHERE rowid = l_expired_rec.row_id;
822:
823: ELSE

Line 828: UPDATE hxt_det_hours_worked_f

824: -- Update expired rows matching exactly to 'D' for dead
825: -- No new PA transaction will be sent because one already exists
826: -- The retro detail row replacing this one will be set to 'C' outside of the loops
827:
828: UPDATE hxt_det_hours_worked_f
829: SET pa_status = 'D'
830: WHERE rowid = l_expired_rec.row_id;
831:
832: END IF; -- identical hours entry

Line 1049: UPDATE hxt_det_hours_worked_f

1045: RAISE l_backout_error;
1046: END IF;
1047: END IF; -- base or premium hours
1048:
1049: UPDATE hxt_det_hours_worked_f
1050: SET pa_status = 'B'
1051: WHERE rowid = l_backout_rec.row_id;
1052:
1053: END LOOP; -- backout transactions