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.

[Home] [Help]

APPS.HR_LOA_SS dependencies on HR_API_TRANSACTION_VALUES

Line 5666: FROM hr_api_transaction_values tv

5662: ,p_time_end IN VARCHAR2
5663: ) IS
5664:
5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3

Line 5668: ,hr_api_transaction_values tv1

5664:
5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5

Line 5669: ,hr_api_transaction_values tv2

5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6

Line 5670: ,hr_api_transaction_values tv3

5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531

Line 5671: ,hr_api_transaction_values tv4

5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE

Line 5672: ,hr_api_transaction_values tv5

5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'

Line 5673: ,hr_api_transaction_values tv6

5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'
5677: and ts.UPDATE_PERSON_ID = p_person_id

Line 5865: -- in all but current transaction step id records of hr_api_transaction_values.

5861: hr_utility.set_location(l_proc, 30);
5862: return;
5863: else
5864: -- Replaced call to chk_overlap function because we should check for overlapping
5865: -- in all but current transaction step id records of hr_api_transaction_values.
5866:
5867: -- Need to check for null otherwise, we may get invalid month error
5868: IF p_date_start IS NOT NULL AND p_date_end IS NOT NULL AND
5869: p_time_start IS NOT NULL and p_time_end IS NOT NULL AND p_transaction_step_id IS NOT NULL

Line 6492: FROM hr_api_transaction_values tv

6488: ,p_time_end IN VARCHAR2
6489: ) IS
6490:
6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3

Line 6494: ,hr_api_transaction_values tv1

6490:
6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5

Line 6495: ,hr_api_transaction_values tv2

6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6

Line 6496: ,hr_api_transaction_values tv3

6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531

Line 6497: ,hr_api_transaction_values tv4

6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:

Line 6498: ,hr_api_transaction_values tv5

6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6502: WHERE

Line 6499: ,hr_api_transaction_values tv6

6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6502: WHERE
6503: ts.api_name = 'HR_LOA_SS.PROCESS_API'

Line 6706: -- in all but current transaction step id records of hr_api_transaction_values.

6702:
6703:
6704: -- Fix 2666959 Start
6705: -- Replaced call to chk_overlap function because we should check for overlapping
6706: -- in all but current transaction step id records of hr_api_transaction_values.
6707:
6708: -- Need to check for null otherwise, we may get invalid month error
6709: IF p_date_start IS NOT NULL AND p_date_end IS NOT NULL AND
6710: p_time_start IS NOT NULL and p_time_end IS NOT NULL AND p_transaction_step_id IS NOT NULL

Line 7665: || This procedure will retrieve data from hr_api_transaction_values

7661: || PROCEDURE: get_abs_from_tt
7662: ||---------------------------------------------------------------------------
7663: ||
7664: || Description:
7665: || This procedure will retrieve data from hr_api_transaction_values
7666: ||
7667: || Access Status:
7668: || Public.
7669: ||

Line 8053: || This procedure will retrieve data from hr_api_transaction_values

8049: || PROCEDURE: get_rtn_from_tt
8050: ||---------------------------------------------------------------------------
8051: ||
8052: || Description:
8053: || This procedure will retrieve data from hr_api_transaction_values
8054: ||
8055: || Access Status:
8056: || Public.
8057: ||

Line 8424: || This procedure will retrieve data from hr_api_transaction_values

8420: || PROCEDURE: get_upd_from_tt
8421: ||---------------------------------------------------------------------------
8422: ||
8423: || Description:
8424: || This procedure will retrieve data from hr_api_transaction_values
8425: ||
8426: || Access Status:
8427: || Public.
8428: ||

Line 9831: FROM hr_api_transaction_values tv

9827: ,p_time_end IN VARCHAR2
9828: ) IS
9829:
9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3

Line 9833: ,hr_api_transaction_values tv1

9829:
9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5

Line 9834: ,hr_api_transaction_values tv2

9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6

Line 9835: ,hr_api_transaction_values tv3

9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531

Line 9836: ,hr_api_transaction_values tv4

9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE

Line 9837: ,hr_api_transaction_values tv5

9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'

Line 9838: ,hr_api_transaction_values tv6

9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'
9842: and ts.UPDATE_PERSON_ID = p_person_id