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.PA_HR_UPDATE_API dependencies on PER_GRADES

Line 102: -- whenever a grade,sequence,jobmapping columns in per_grades,per_valid_grades,pa_job_relationships

98:
99: -- This Procedure will get a list of all affected jobs due to change in the grade,
100: -- sequence or mapping and then calls to PRM API GET_JOB_LEVEL in a loop which actually
101: -- updates the levels in the denorm table
102: -- whenever a grade,sequence,jobmapping columns in per_grades,per_valid_grades,pa_job_relationships
103: -- respectively updated,workflow will kickoff this api from the database trigger on table
104: -- per_grades,Per_valid_grades,pa_job_relationships
105: -- Requirements for calling this api from triggers different entities.
106: -- Per_Grades_Entity--

Line 104: -- per_grades,Per_valid_grades,pa_job_relationships

100: -- sequence or mapping and then calls to PRM API GET_JOB_LEVEL in a loop which actually
101: -- updates the levels in the denorm table
102: -- whenever a grade,sequence,jobmapping columns in per_grades,per_valid_grades,pa_job_relationships
103: -- respectively updated,workflow will kickoff this api from the database trigger on table
104: -- per_grades,Per_valid_grades,pa_job_relationships
105: -- Requirements for calling this api from triggers different entities.
106: -- Per_Grades_Entity--
107: -- IN Parameters
108: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new -- for INSERT trigger

Line 106: -- Per_Grades_Entity--

102: -- whenever a grade,sequence,jobmapping columns in per_grades,per_valid_grades,pa_job_relationships
103: -- respectively updated,workflow will kickoff this api from the database trigger on table
104: -- per_grades,Per_valid_grades,pa_job_relationships
105: -- Requirements for calling this api from triggers different entities.
106: -- Per_Grades_Entity--
107: -- IN Parameters
108: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new -- for INSERT trigger
109: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new,P_per_grades_sequence_old -- for UPDATE
110: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_old --- for DELETE trigger

Line 108: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new -- for INSERT trigger

104: -- per_grades,Per_valid_grades,pa_job_relationships
105: -- Requirements for calling this api from triggers different entities.
106: -- Per_Grades_Entity--
107: -- IN Parameters
108: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new -- for INSERT trigger
109: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new,P_per_grades_sequence_old -- for UPDATE
110: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_old --- for DELETE trigger
111: -- Per_Valid_Grades Entity--
112: -- IN Parameters

Line 109: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new,P_per_grades_sequence_old -- for UPDATE

105: -- Requirements for calling this api from triggers different entities.
106: -- Per_Grades_Entity--
107: -- IN Parameters
108: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new -- for INSERT trigger
109: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new,P_per_grades_sequence_old -- for UPDATE
110: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_old --- for DELETE trigger
111: -- Per_Valid_Grades Entity--
112: -- IN Parameters
113: -- P_calling_mode,P_per_valid_grade_job_id,P_per_valid_grade_id_new -- for INSERT

Line 110: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_old --- for DELETE trigger

106: -- Per_Grades_Entity--
107: -- IN Parameters
108: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new -- for INSERT trigger
109: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_new,P_per_grades_sequence_old -- for UPDATE
110: -- P_calling_mode,P_per_grades_grade_id,P_per_grades_sequence_old --- for DELETE trigger
111: -- Per_Valid_Grades Entity--
112: -- IN Parameters
113: -- P_calling_mode,P_per_valid_grade_job_id,P_per_valid_grade_id_new -- for INSERT
114: -- P_calling_mode,P_per_valid_grade_job_id,P_per_valid_grade_id_new,P_per_valid_grade_id_old -- UPDATE

Line 125: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL

121: -- P_calling_mode,P_from_job_id_old,P_to_job_id_old,P_from_job_group_id,P_to_job_group_id -- DELETE
122:
123: PROCEDURE update_job_levels
124: ( P_calling_mode IN VARCHAR2
125: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
126: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
127: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
128: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
129: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL

Line 126: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL

122:
123: PROCEDURE update_job_levels
124: ( P_calling_mode IN VARCHAR2
125: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
126: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
127: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
128: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
129: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
130: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL

Line 127: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL

123: PROCEDURE update_job_levels
124: ( P_calling_mode IN VARCHAR2
125: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
126: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
127: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
128: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
129: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
130: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
131: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL

Line 129: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL

125: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
126: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
127: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
128: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
129: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
130: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
131: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
132: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
133: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL

Line 130: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL

126: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
127: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
128: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
129: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
130: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
131: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
132: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
133: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
134: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL