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 628: UPDATE hxt_det_hours_worked_f

624: RAISE l_adjusting_error;
625: END IF;
626:
627: -- Update the expired (now adjusted) row so we don't pick it up again.
628: UPDATE hxt_det_hours_worked_f
629: SET pa_status = 'A'
630: WHERE rowid = l_expired_rec.row_id;
631:
632: ELSE

Line 638: UPDATE hxt_det_hours_worked_f

634: -- Update expired rows matching exactly to 'D' for dead
635: -- No new identical PA transaction will be sent because one already exists in PA
636: -- The retro detail row replacing this one will be set to 'C' complete outside of the loops
637:
638: UPDATE hxt_det_hours_worked_f
639: SET pa_status = 'D'
640: WHERE rowid = l_expired_rec.row_id;
641:
642: END IF; -- identical entry

Line 806: UPDATE hxt_det_hours_worked_f

802: RAISE l_adjusting_error;
803: END IF;
804:
805: -- Update the expired (now adjusted) row so we don't pick it up again.
806: UPDATE hxt_det_hours_worked_f
807: SET pa_status = 'A'
808: WHERE rowid = l_expired_rec.row_id;
809:
810: ELSE

Line 815: UPDATE hxt_det_hours_worked_f

811: -- Update expired rows matching exactly to 'D' for dead
812: -- No new PA transaction will be sent because one already exists
813: -- The retro detail row replacing this one will be set to 'C' outside of the loops
814:
815: UPDATE hxt_det_hours_worked_f
816: SET pa_status = 'D'
817: WHERE rowid = l_expired_rec.row_id;
818:
819: END IF; -- identical hours entry

Line 1036: UPDATE hxt_det_hours_worked_f

1032: RAISE l_backout_error;
1033: END IF;
1034: END IF; -- base or premium hours
1035:
1036: UPDATE hxt_det_hours_worked_f
1037: SET pa_status = 'B'
1038: WHERE rowid = l_backout_rec.row_id;
1039:
1040: END LOOP; -- backout transactions