APPS.PA_HR_UPDATE_API dependencies on PER_VALID_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 111: -- Per_Valid_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
115: -- P_calling_mode,P_per_valid_grade_job_id,P_per_valid_grade_id_old -- for DELETE trigger

Line 128: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL

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
132: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL