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 10067: FROM hr_api_transaction_values tv

10063: ,p_time_end IN VARCHAR2
10064: ) IS
10065:
10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3

Line 10069: ,hr_api_transaction_values tv1

10065:
10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5

Line 10070: ,hr_api_transaction_values tv2

10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6

Line 10071: ,hr_api_transaction_values tv3

10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531

Line 10072: ,hr_api_transaction_values tv4

10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE

Line 10073: ,hr_api_transaction_values tv5

10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE
10077: ts.api_name = 'HR_LOA_SS.PROCESS_API'

Line 10074: ,hr_api_transaction_values tv6

10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE
10077: ts.api_name = 'HR_LOA_SS.PROCESS_API'
10078: and ts.UPDATE_PERSON_ID = p_person_id