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.

APPS.PQH_GIN_UPD dependencies on PQH_GIN_SHD

Line 58: (p_rec in out nocopy pqh_gin_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pqh_gin_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 114: pqh_gin_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: pqh_gin_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: pqh_gin_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: pqh_gin_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 158: (p_rec in out nocopy pqh_gin_shd.g_rec_type

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure update_dml
158: (p_rec in out nocopy pqh_gin_shd.g_rec_type
159: ,p_effective_date in date
160: ,p_datetrack_mode in varchar2
161: ,p_validation_start_date in date
162: ,p_validation_end_date in date

Line 225: (p_rec in out nocopy pqh_gin_shd.g_rec_type

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_pre_update
225: (p_rec in out nocopy pqh_gin_shd.g_rec_type
226: ,p_effective_date in date
227: ,p_datetrack_mode in varchar2
228: ,p_validation_start_date in date
229: ,p_validation_end_date in date

Line 241: pqh_gin_shd.upd_effective_end_date

237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
241: pqh_gin_shd.upd_effective_end_date
242: (p_effective_date => p_effective_date
243: ,p_base_key_value => p_rec.global_index_id
244: ,p_new_effective_end_date => (p_validation_start_date - 1)
245: ,p_validation_start_date => p_validation_start_date

Line 310: (p_rec in out nocopy pqh_gin_shd.g_rec_type

306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_update
310: (p_rec in out nocopy pqh_gin_shd.g_rec_type
311: ,p_effective_date in date
312: ,p_datetrack_mode in varchar2
313: ,p_validation_start_date in date
314: ,p_validation_end_date in date

Line 368: (p_rec in pqh_gin_shd.g_rec_type

364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure post_update
368: (p_rec in pqh_gin_shd.g_rec_type
369: ,p_effective_date in date
370: ,p_datetrack_mode in varchar2
371: ,p_validation_start_date in date
372: ,p_validation_end_date in date

Line 411: => pqh_gin_shd.g_old_rec.effective_start_date

407: => p_rec.currency_code
408: ,p_object_version_number
409: => p_rec.object_version_number
410: ,p_effective_start_date_o
411: => pqh_gin_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => pqh_gin_shd.g_old_rec.effective_end_date
414: ,p_type_of_record_o
415: => pqh_gin_shd.g_old_rec.type_of_record

Line 413: => pqh_gin_shd.g_old_rec.effective_end_date

409: => p_rec.object_version_number
410: ,p_effective_start_date_o
411: => pqh_gin_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => pqh_gin_shd.g_old_rec.effective_end_date
414: ,p_type_of_record_o
415: => pqh_gin_shd.g_old_rec.type_of_record
416: ,p_gross_index_o
417: => pqh_gin_shd.g_old_rec.gross_index

Line 415: => pqh_gin_shd.g_old_rec.type_of_record

411: => pqh_gin_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => pqh_gin_shd.g_old_rec.effective_end_date
414: ,p_type_of_record_o
415: => pqh_gin_shd.g_old_rec.type_of_record
416: ,p_gross_index_o
417: => pqh_gin_shd.g_old_rec.gross_index
418: ,p_increased_index_o
419: => pqh_gin_shd.g_old_rec.increased_index

Line 417: => pqh_gin_shd.g_old_rec.gross_index

413: => pqh_gin_shd.g_old_rec.effective_end_date
414: ,p_type_of_record_o
415: => pqh_gin_shd.g_old_rec.type_of_record
416: ,p_gross_index_o
417: => pqh_gin_shd.g_old_rec.gross_index
418: ,p_increased_index_o
419: => pqh_gin_shd.g_old_rec.increased_index
420: ,p_basic_salary_rate_o
421: => pqh_gin_shd.g_old_rec.basic_salary_rate

Line 419: => pqh_gin_shd.g_old_rec.increased_index

415: => pqh_gin_shd.g_old_rec.type_of_record
416: ,p_gross_index_o
417: => pqh_gin_shd.g_old_rec.gross_index
418: ,p_increased_index_o
419: => pqh_gin_shd.g_old_rec.increased_index
420: ,p_basic_salary_rate_o
421: => pqh_gin_shd.g_old_rec.basic_salary_rate
422: ,p_housing_indemnity_rate_o
423: => pqh_gin_shd.g_old_rec.housing_indemnity_rate

Line 421: => pqh_gin_shd.g_old_rec.basic_salary_rate

417: => pqh_gin_shd.g_old_rec.gross_index
418: ,p_increased_index_o
419: => pqh_gin_shd.g_old_rec.increased_index
420: ,p_basic_salary_rate_o
421: => pqh_gin_shd.g_old_rec.basic_salary_rate
422: ,p_housing_indemnity_rate_o
423: => pqh_gin_shd.g_old_rec.housing_indemnity_rate
424: ,p_object_version_number_o
425: => pqh_gin_shd.g_old_rec.object_version_number

Line 423: => pqh_gin_shd.g_old_rec.housing_indemnity_rate

419: => pqh_gin_shd.g_old_rec.increased_index
420: ,p_basic_salary_rate_o
421: => pqh_gin_shd.g_old_rec.basic_salary_rate
422: ,p_housing_indemnity_rate_o
423: => pqh_gin_shd.g_old_rec.housing_indemnity_rate
424: ,p_object_version_number_o
425: => pqh_gin_shd.g_old_rec.object_version_number
426: ,p_currency_code_o
427: => pqh_gin_shd.g_old_rec.currency_code

Line 425: => pqh_gin_shd.g_old_rec.object_version_number

421: => pqh_gin_shd.g_old_rec.basic_salary_rate
422: ,p_housing_indemnity_rate_o
423: => pqh_gin_shd.g_old_rec.housing_indemnity_rate
424: ,p_object_version_number_o
425: => pqh_gin_shd.g_old_rec.object_version_number
426: ,p_currency_code_o
427: => pqh_gin_shd.g_old_rec.currency_code
428: );
429: --

Line 427: => pqh_gin_shd.g_old_rec.currency_code

423: => pqh_gin_shd.g_old_rec.housing_indemnity_rate
424: ,p_object_version_number_o
425: => pqh_gin_shd.g_old_rec.object_version_number
426: ,p_currency_code_o
427: => pqh_gin_shd.g_old_rec.currency_code
428: );
429: --
430: exception
431: --

Line 487: (p_rec in out nocopy pqh_gin_shd.g_rec_type

483: --
484: -- {End Of Comments}
485: -- ----------------------------------------------------------------------------
486: Procedure convert_defs
487: (p_rec in out nocopy pqh_gin_shd.g_rec_type
488: ) is
489: --
490: Begin
491: --

Line 499: pqh_gin_shd.g_old_rec.type_of_record;

495: -- is being used then we must set to the 'current' argument value.
496: --
497: If (p_rec.type_of_record = hr_api.g_varchar2) then
498: p_rec.type_of_record :=
499: pqh_gin_shd.g_old_rec.type_of_record;
500: End If;
501: If (p_rec.gross_index = hr_api.g_number) then
502: p_rec.gross_index :=
503: pqh_gin_shd.g_old_rec.gross_index;

Line 503: pqh_gin_shd.g_old_rec.gross_index;

499: pqh_gin_shd.g_old_rec.type_of_record;
500: End If;
501: If (p_rec.gross_index = hr_api.g_number) then
502: p_rec.gross_index :=
503: pqh_gin_shd.g_old_rec.gross_index;
504: End If;
505: If (p_rec.increased_index = hr_api.g_number) then
506: p_rec.increased_index :=
507: pqh_gin_shd.g_old_rec.increased_index;

Line 507: pqh_gin_shd.g_old_rec.increased_index;

503: pqh_gin_shd.g_old_rec.gross_index;
504: End If;
505: If (p_rec.increased_index = hr_api.g_number) then
506: p_rec.increased_index :=
507: pqh_gin_shd.g_old_rec.increased_index;
508: End If;
509: If (p_rec.basic_salary_rate = hr_api.g_number) then
510: p_rec.basic_salary_rate :=
511: pqh_gin_shd.g_old_rec.basic_salary_rate;

Line 511: pqh_gin_shd.g_old_rec.basic_salary_rate;

507: pqh_gin_shd.g_old_rec.increased_index;
508: End If;
509: If (p_rec.basic_salary_rate = hr_api.g_number) then
510: p_rec.basic_salary_rate :=
511: pqh_gin_shd.g_old_rec.basic_salary_rate;
512: End If;
513: If (p_rec.housing_indemnity_rate = hr_api.g_number) then
514: p_rec.housing_indemnity_rate :=
515: pqh_gin_shd.g_old_rec.housing_indemnity_rate;

Line 515: pqh_gin_shd.g_old_rec.housing_indemnity_rate;

511: pqh_gin_shd.g_old_rec.basic_salary_rate;
512: End If;
513: If (p_rec.housing_indemnity_rate = hr_api.g_number) then
514: p_rec.housing_indemnity_rate :=
515: pqh_gin_shd.g_old_rec.housing_indemnity_rate;
516: End If;
517: If (p_rec.currency_code = hr_api.g_varchar2) then
518: p_rec.currency_code :=
519: pqh_gin_shd.g_old_rec.currency_code;

Line 519: pqh_gin_shd.g_old_rec.currency_code;

515: pqh_gin_shd.g_old_rec.housing_indemnity_rate;
516: End If;
517: If (p_rec.currency_code = hr_api.g_varchar2) then
518: p_rec.currency_code :=
519: pqh_gin_shd.g_old_rec.currency_code;
520: End If;
521:
522: --
523: End convert_defs;

Line 531: ,p_rec in out nocopy pqh_gin_shd.g_rec_type

527: -- ----------------------------------------------------------------------------
528: Procedure upd
529: (p_effective_date in date
530: ,p_datetrack_mode in varchar2
531: ,p_rec in out nocopy pqh_gin_shd.g_rec_type
532: ) is
533: --
534: l_proc varchar2(72) := g_package||'upd';
535: l_validation_start_date date;

Line 547: pqh_gin_shd.lck

543: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
544: --
545: -- We must lock the row which we need to update.
546: --
547: pqh_gin_shd.lck
548: (p_effective_date => p_effective_date
549: ,p_datetrack_mode => p_datetrack_mode
550: ,p_global_index_id => p_rec.global_index_id
551: ,p_object_version_number => p_rec.object_version_number

Line 682: l_rec pqh_gin_shd.g_rec_type;

678: ,p_effective_start_date out nocopy date
679: ,p_effective_end_date out nocopy date
680: ) is
681: --
682: l_rec pqh_gin_shd.g_rec_type;
683: l_proc varchar2(72) := g_package||'upd';
684: l_datetrack_mode varchar2(30);
685: --
686: Begin

Line 693: pqh_gin_shd.convert_args

689: -- Call conversion function to turn arguments into the
690: -- l_rec structure.
691: --
692: l_rec :=
693: pqh_gin_shd.convert_args
694: (p_global_index_id
695: ,null
696: ,null
697: ,p_type_of_record