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.PAY_PUR_UPD dependencies on PAY_PUR_SHD

Line 58: (p_rec in out nocopy pay_pur_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_pur_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 83: pay_pur_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'user_row_id'
80: ,p_base_key_value => p_rec.user_row_id
81: );
82: --
83: pay_pur_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_user_rows_f Row
86: --
87: update pay_user_rows_f

Line 101: pay_pur_shd.g_api_dml := false; -- Unset the api dml status

97: where user_row_id = p_rec.user_row_id
98: and effective_start_date = p_validation_start_date
99: and effective_end_date = p_validation_end_date;
100: --
101: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: -- Set the effective start and end dates
104: --
105: p_rec.effective_start_date := p_validation_start_date;

Line 113: pay_pur_shd.g_api_dml := false; -- Unset the api dml status

109: hr_utility.set_location(' Leaving:'||l_proc, 15);
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
114: pay_pur_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

Line 114: pay_pur_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
114: pay_pur_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: pay_pur_shd.g_api_dml := false; -- Unset the api dml status

Line 118: pay_pur_shd.g_api_dml := false; -- Unset the api dml status

114: pay_pur_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: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
119: pay_pur_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: pay_pur_shd.g_api_dml := false; -- Unset the api dml status

Line 119: pay_pur_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: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
119: pay_pur_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;

Line 122: pay_pur_shd.g_api_dml := false; -- Unset the api dml status

118: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
119: pay_pur_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;
124: End dt_update_dml;
125: --
126: -- ----------------------------------------------------------------------------

Line 158: (p_rec in out nocopy pay_pur_shd.g_rec_type

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure update_dml
158: (p_rec in out nocopy pay_pur_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 pay_pur_shd.g_rec_type

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_pre_update
225: (p_rec in out nocopy pay_pur_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: pay_pur_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: pay_pur_shd.upd_effective_end_date
242: (p_effective_date => p_effective_date
243: ,p_base_key_value => p_rec.user_row_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 pay_pur_shd.g_rec_type

306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_update
310: (p_rec in out nocopy pay_pur_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 pay_pur_shd.g_rec_type

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

Line 411: => pay_pur_shd.g_old_rec.effective_start_date

407: => p_disable_units_check
408: ,p_disable_range_overlap_check
409: => p_disable_range_overlap_check
410: ,p_effective_start_date_o
411: => pay_pur_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => pay_pur_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => pay_pur_shd.g_old_rec.business_group_id

Line 413: => pay_pur_shd.g_old_rec.effective_end_date

409: => p_disable_range_overlap_check
410: ,p_effective_start_date_o
411: => pay_pur_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => pay_pur_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => pay_pur_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => pay_pur_shd.g_old_rec.legislation_code

Line 415: => pay_pur_shd.g_old_rec.business_group_id

411: => pay_pur_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => pay_pur_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => pay_pur_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => pay_pur_shd.g_old_rec.legislation_code
418: ,p_user_table_id_o
419: => pay_pur_shd.g_old_rec.user_table_id

Line 417: => pay_pur_shd.g_old_rec.legislation_code

413: => pay_pur_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => pay_pur_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => pay_pur_shd.g_old_rec.legislation_code
418: ,p_user_table_id_o
419: => pay_pur_shd.g_old_rec.user_table_id
420: ,p_row_low_range_or_name_o
421: => pay_pur_shd.g_old_rec.row_low_range_or_name

Line 419: => pay_pur_shd.g_old_rec.user_table_id

415: => pay_pur_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => pay_pur_shd.g_old_rec.legislation_code
418: ,p_user_table_id_o
419: => pay_pur_shd.g_old_rec.user_table_id
420: ,p_row_low_range_or_name_o
421: => pay_pur_shd.g_old_rec.row_low_range_or_name
422: ,p_display_sequence_o
423: => pay_pur_shd.g_old_rec.display_sequence

Line 421: => pay_pur_shd.g_old_rec.row_low_range_or_name

417: => pay_pur_shd.g_old_rec.legislation_code
418: ,p_user_table_id_o
419: => pay_pur_shd.g_old_rec.user_table_id
420: ,p_row_low_range_or_name_o
421: => pay_pur_shd.g_old_rec.row_low_range_or_name
422: ,p_display_sequence_o
423: => pay_pur_shd.g_old_rec.display_sequence
424: ,p_row_high_range_o
425: => pay_pur_shd.g_old_rec.row_high_range

Line 423: => pay_pur_shd.g_old_rec.display_sequence

419: => pay_pur_shd.g_old_rec.user_table_id
420: ,p_row_low_range_or_name_o
421: => pay_pur_shd.g_old_rec.row_low_range_or_name
422: ,p_display_sequence_o
423: => pay_pur_shd.g_old_rec.display_sequence
424: ,p_row_high_range_o
425: => pay_pur_shd.g_old_rec.row_high_range
426: ,p_object_version_number_o
427: => pay_pur_shd.g_old_rec.object_version_number

Line 425: => pay_pur_shd.g_old_rec.row_high_range

421: => pay_pur_shd.g_old_rec.row_low_range_or_name
422: ,p_display_sequence_o
423: => pay_pur_shd.g_old_rec.display_sequence
424: ,p_row_high_range_o
425: => pay_pur_shd.g_old_rec.row_high_range
426: ,p_object_version_number_o
427: => pay_pur_shd.g_old_rec.object_version_number
428: );
429: --

Line 427: => pay_pur_shd.g_old_rec.object_version_number

423: => pay_pur_shd.g_old_rec.display_sequence
424: ,p_row_high_range_o
425: => pay_pur_shd.g_old_rec.row_high_range
426: ,p_object_version_number_o
427: => pay_pur_shd.g_old_rec.object_version_number
428: );
429: --
430: exception
431: --

Line 487: (p_rec in out nocopy pay_pur_shd.g_rec_type

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

Line 499: pay_pur_shd.g_old_rec.business_group_id;

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

Line 503: pay_pur_shd.g_old_rec.legislation_code;

499: pay_pur_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.legislation_code = hr_api.g_varchar2) then
502: p_rec.legislation_code :=
503: pay_pur_shd.g_old_rec.legislation_code;
504: End If;
505: If (p_rec.user_table_id = hr_api.g_number) then
506: p_rec.user_table_id :=
507: pay_pur_shd.g_old_rec.user_table_id;

Line 507: pay_pur_shd.g_old_rec.user_table_id;

503: pay_pur_shd.g_old_rec.legislation_code;
504: End If;
505: If (p_rec.user_table_id = hr_api.g_number) then
506: p_rec.user_table_id :=
507: pay_pur_shd.g_old_rec.user_table_id;
508: End If;
509: If (p_rec.row_low_range_or_name = hr_api.g_varchar2) then
510: p_rec.row_low_range_or_name :=
511: pay_pur_shd.g_old_rec.row_low_range_or_name;

Line 511: pay_pur_shd.g_old_rec.row_low_range_or_name;

507: pay_pur_shd.g_old_rec.user_table_id;
508: End If;
509: If (p_rec.row_low_range_or_name = hr_api.g_varchar2) then
510: p_rec.row_low_range_or_name :=
511: pay_pur_shd.g_old_rec.row_low_range_or_name;
512: End If;
513: If (p_rec.display_sequence = hr_api.g_number) then
514: p_rec.display_sequence :=
515: pay_pur_shd.g_old_rec.display_sequence;

Line 515: pay_pur_shd.g_old_rec.display_sequence;

511: pay_pur_shd.g_old_rec.row_low_range_or_name;
512: End If;
513: If (p_rec.display_sequence = hr_api.g_number) then
514: p_rec.display_sequence :=
515: pay_pur_shd.g_old_rec.display_sequence;
516: End If;
517: If (p_rec.row_high_range = hr_api.g_varchar2) then
518: p_rec.row_high_range :=
519: pay_pur_shd.g_old_rec.row_high_range;

Line 519: pay_pur_shd.g_old_rec.row_high_range;

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

Line 530: ,p_rec in out nocopy pay_pur_shd.g_rec_type

526: -- ----------------------------------------------------------------------------
527: Procedure upd
528: (p_effective_date in date
529: ,p_datetrack_mode in varchar2
530: ,p_rec in out nocopy pay_pur_shd.g_rec_type
531: ,p_disable_units_check in boolean default false
532: ,p_disable_range_overlap_check in boolean default false
533: ) is
534: --

Line 548: pay_pur_shd.lck

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

Line 631: l_rec pay_pur_shd.g_rec_type;

627: ,p_effective_start_date out nocopy date
628: ,p_effective_end_date out nocopy date
629: ) is
630: --
631: l_rec pay_pur_shd.g_rec_type;
632: l_proc varchar2(72) := g_package||'upd';
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);

Line 641: pay_pur_shd.convert_args

637: -- Call conversion function to turn arguments into the
638: -- l_rec structure.
639: --
640: l_rec :=
641: pay_pur_shd.convert_args
642: (p_user_row_id
643: ,null
644: ,null
645: ,hr_api.g_number