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_PA_ENTITIES dependencies on FND_API

Line 115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND

111: --
112: -- bug 2840328:PA HR UPDATE TRIGGERS SHOULD NOT CREATE WF PROCESS IF NO RELEVANT CHANGES
113: -- We should not start workflow when no attribute of interest to PA has not been
114: -- changed on per_all_people_f, PER_ALL_ASSIGNMENTS_F.etc.
115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND
116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND

Line 116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND

112: -- bug 2840328:PA HR UPDATE TRIGGERS SHOULD NOT CREATE WF PROCESS IF NO RELEVANT CHANGES
113: -- We should not start workflow when no attribute of interest to PA has not been
114: -- changed on per_all_people_f, PER_ALL_ASSIGNMENTS_F.etc.
115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND
116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND

Line 117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND

113: -- We should not start workflow when no attribute of interest to PA has not been
114: -- changed on per_all_people_f, PER_ALL_ASSIGNMENTS_F.etc.
115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND
116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND

Line 118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND

114: -- changed on per_all_people_f, PER_ALL_ASSIGNMENTS_F.etc.
115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND
116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND

Line 119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND

115: IF ( nvl(p_start_date_old,FND_API.G_MISS_DATE) = nvl(p_start_date_new,FND_API.G_MISS_DATE) AND
116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND

Line 120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND

116: nvl(p_end_date_old,FND_API.G_MISS_DATE) = nvl(p_end_date_new,FND_API.G_MISS_DATE) AND
117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND

Line 121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND

117: nvl(p_org_id_old,FND_API.G_MISS_NUM) = nvl(p_org_id_new,FND_API.G_MISS_NUM) AND
118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND

Line 122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND

118: nvl(p_job_id_old,FND_API.G_MISS_NUM) = nvl(p_job_id_new,FND_API.G_MISS_NUM) AND
119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND

Line 123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND

119: nvl(p_job_level_old,FND_API.G_MISS_NUM) = nvl(p_job_level_new,FND_API.G_MISS_NUM) AND
120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND

Line 124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND

120: nvl(p_supervisor_old,FND_API.G_MISS_NUM) = nvl(p_supervisor_new,FND_API.G_MISS_NUM) AND
121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND

Line 125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND

121: nvl(p_primary_flag_old,FND_API.G_MISS_CHAR) = nvl(p_primary_flag_new,FND_API.G_MISS_CHAR) AND
122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND

Line 126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND

122: nvl(p_org_info1_old,FND_API.G_MISS_CHAR) = nvl(p_org_info1_new,FND_API.G_MISS_CHAR) AND
123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND

Line 127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND

123: nvl(p_jei_information2_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information2_new,FND_API.G_MISS_CHAR) AND
124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND

Line 128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND

124: nvl(p_jei_information3_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information3_new,FND_API.G_MISS_CHAR) AND
125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND

Line 129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND

125: nvl(p_jei_information4_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information4_new,FND_API.G_MISS_CHAR) AND
126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND
133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND

Line 130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND

126: nvl(p_jei_information6_old,FND_API.G_MISS_CHAR) = nvl(p_jei_information6_new,FND_API.G_MISS_CHAR) AND
127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND
133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND
134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN

Line 131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND

127: nvl(p_grade_id_old,FND_API.G_MISS_NUM) = nvl(p_grade_id_new,FND_API.G_MISS_NUM) AND
128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND
133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND
134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN
135: return;

Line 132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND

128: nvl(p_full_name_old,FND_API.G_MISS_CHAR) = nvl(p_full_name_new,FND_API.G_MISS_CHAR) AND
129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND
133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND
134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN
135: return;
136:

Line 133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND

129: nvl(p_country_old,FND_API.G_MISS_CHAR) = nvl(p_country_new,FND_API.G_MISS_CHAR) AND
130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND
133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND
134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN
135: return;
136:
137: -- When the trigger on PER_JOB_EXTRA_INFO is fired, we won't launch the WF in following cases

Line 134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN

130: nvl(p_city_old,FND_API.G_MISS_CHAR) = nvl(p_city_new,FND_API.G_MISS_CHAR) AND
131: nvl(p_region2_old,FND_API.G_MISS_CHAR) = nvl(p_region2_new,FND_API.G_MISS_CHAR) AND
132: nvl(p_inactive_date_old,FND_API.G_MISS_DATE) = nvl(p_inactive_date_new,FND_API.G_MISS_DATE) AND
133: nvl(p_from_job_id_old,FND_API.G_MISS_NUM) = nvl(p_from_job_id_new,FND_API.G_MISS_NUM) AND
134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN
135: return;
136:
137: -- When the trigger on PER_JOB_EXTRA_INFO is fired, we won't launch the WF in following cases
138: -- because we don't need to update pa_resources_denorm.

Line 597: WHEN FND_API.G_EXC_ERROR

593:
594: --
595: EXCEPTION
596: /*
597: WHEN FND_API.G_EXC_ERROR
598: THEN
599: wf_core.context('pa_hr_update_pa_objects',
600: 'start_date_change',
601: itemtype,

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

605: if (l_savepoint) then
606: rollback to l_org_struct_element_change ;
607: End if;
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
610: THEN
611: wf_core.context('pa_hr_update_pa_objects',
612: 'start_date_change',
613: itemtype,

Line 780: /* WHEN FND_API.G_EXC_ERROR

776: log_message('l_return_status: '||l_return_status);
777:
778: --
779: EXCEPTION
780: /* WHEN FND_API.G_EXC_ERROR
781: THEN
782: wf_core.context('pa_hr_update_pa_objects',
783: 'start_date_change',
784: itemtype,

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

792: p_item_key => itemkey,
793: p_msg_count => l_msg_count,
794: p_msg_data => l_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
797: THEN
798: wf_core.context('pa_hr_update_pa_objects',
799: 'start_date_change',
800: itemtype,

Line 953: /* WHEN FND_API.G_EXC_ERROR

949:
950:
951: --
952: EXCEPTION
953: /* WHEN FND_API.G_EXC_ERROR
954: THEN
955: wf_core.context('pa_hr_update_pa_entities',
956: 'Full_Name_Change',
957: itemtype,

Line 970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

966: p_msg_count => l_msg_count,
967: p_msg_data => l_msg_data);
968: resultout := wf_engine.eng_completed||':'||'F';
969:
970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
971: THEN
972: wf_core.context('pa_hr_update_pa_entities',
973: 'Full_Name_Change',
974: itemtype,

Line 1143: /* WHEN FND_API.G_EXC_ERROR

1139: END IF;
1140:
1141: --
1142: EXCEPTION
1143: /* WHEN FND_API.G_EXC_ERROR
1144: THEN
1145: If (l_savepoint) then
1146: rollback to l_ou_change ;
1147: End if;

Line 1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1158:
1159: resultout := wf_engine.eng_completed||':'||'F';
1160: -- RAISE;
1161:
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1163: THEN
1164:
1165: If (l_savepoint) then
1166: rollback to l_ou_change ;

Line 1345: /* WHEN FND_API.G_EXC_ERROR

1341:
1342:
1343: --
1344: EXCEPTION
1345: /* WHEN FND_API.G_EXC_ERROR
1346: THEN
1347: If (l_savepoint) then
1348: rollback to l_valid_grade_change ;
1349: End if;

Line 1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1358: p_msg_count => l_msg_count,
1359: p_msg_data => l_msg_data);
1360: resultout := wf_engine.eng_completed||':'||'F';
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1363: THEN
1364: If (l_savepoint) then
1365: rollback to l_valid_grade_change ;
1366: End if;

Line 1515: /* WHEN FND_API.G_EXC_ERROR

1511: END IF;
1512:
1513:
1514: EXCEPTION
1515: /* WHEN FND_API.G_EXC_ERROR
1516: THEN
1517: If (l_savepoint) then
1518: rollback to l_job_level_change ;
1519: End if;

Line 1534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1530: p_msg_data => l_msg_data);
1531:
1532: resultout := wf_engine.eng_completed||':'||'F';
1533:
1534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1535: THEN
1536: If (l_savepoint) then
1537: rollback to l_job_level_change ;
1538: End if;

Line 1763: /* WHEN FND_API.G_EXC_ERROR

1759:
1760:
1761:
1762: EXCEPTION
1763: /* WHEN FND_API.G_EXC_ERROR
1764: THEN
1765: If (l_savepoint) then
1766: rollback to l_address_change ;
1767: end if;

Line 1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1779: p_msg_data => l_msg_data);
1780:
1781: resultout := wf_engine.eng_completed||':'||'F';
1782:
1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1784: THEN
1785: If (l_savepoint) then
1786: rollback to l_address_change ;
1787: End if;

Line 1980: /* WHEN FND_API.G_EXC_ERROR

1976: END IF;
1977:
1978: --
1979: EXCEPTION
1980: /* WHEN FND_API.G_EXC_ERROR
1981: THEN
1982: If (l_savepoint) then
1983: rollback to l_project_org_change ;
1984: end if;

Line 2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1996:
1997: resultout := wf_engine.eng_completed||':'||'F';
1998: --RAISE;
1999:
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2001: THEN
2002: If (l_savepoint) then
2003: rollback to l_project_org_change ;
2004: End if;

Line 2180: /* WHEN FND_API.G_EXC_ERROR

2176: END IF;
2177:
2178: --
2179: EXCEPTION
2180: /* WHEN FND_API.G_EXC_ERROR
2181: THEN
2182: If (l_savepoint) then
2183: rollback to l_job_rel_change ;
2184: End if;

Line 2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2195: p_msg_data => l_msg_data);
2196:
2197: resultout := wf_engine.eng_completed||':'||'F';
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2200: THEN
2201: If (l_savepoint) then
2202: rollback to l_job_rel_change ;
2203: End if;

Line 2307: l_final_return_status := FND_API.G_RET_STS_SUCCESS ;

2303: --
2304: -- Initialize workflow item attributes
2305: --
2306:
2307: l_final_return_status := FND_API.G_RET_STS_SUCCESS ;
2308:
2309: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2310: itemkey => itemkey,
2311: aname => 'CALLING_MODE' );

Line 2438: ,p_commit => FND_API.G_FALSE

2434: l_savepoint := true;
2435: pa_r_project_resources_pub.create_resource (
2436: p_api_version => 1.0
2437: ,p_init_msg_list => NULL
2438: ,p_commit => FND_API.G_FALSE
2439: ,p_validate_only => NULL
2440: ,p_max_msg_count => NULL
2441: ,p_internal => 'Y'
2442: ,p_person_id => l_person_id

Line 2491: ,p_commit => FND_API.G_FALSE

2487: -- call the work flow to update pa objects
2488: pa_r_project_resources_pub.create_resource (
2489: p_api_version => 1.0
2490: ,p_init_msg_list => NULL
2491: ,p_commit => FND_API.G_FALSE
2492: ,p_validate_only => NULL
2493: ,p_max_msg_count => NULL
2494: ,p_internal => 'Y'
2495: ,p_person_id => l_person_id

Line 2620: ,p_commit => FND_API.G_FALSE

2616:
2617: pa_r_project_resources_pub.create_resource (
2618: p_api_version => 1.0
2619: ,p_init_msg_list => NULL
2620: ,p_commit => FND_API.G_FALSE
2621: ,p_validate_only => NULL
2622: ,p_max_msg_count => NULL
2623: ,p_internal => 'Y'
2624: ,p_person_id => l_person_id

Line 2806: WHEN FND_API.G_EXC_ERROR THEN

2802: resultout := wf_engine.eng_completed||':'||'F';
2803: END IF;
2804:
2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: If (l_savepoint) then
2808: rollback to l_assignment_change ;
2809: end if;
2810:

Line 2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2833:
2834: resultout := wf_engine.eng_completed||':'||'F';
2835: --RAISE;
2836:
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2838: If (l_savepoint) then
2839: rollback to l_assignment_change ;
2840: End if;
2841:

Line 2955: (p_encoded => FND_API.G_FALSE,

2951: EXIT;
2952: END IF;
2953:
2954: pa_interface_utils_pub.get_messages
2955: (p_encoded => FND_API.G_FALSE,
2956: p_msg_index => i,
2957: p_msg_count => p_msg_count ,
2958: p_msg_data => p_msg_data ,
2959: p_data => l_data,

Line 3015: x_return_status := FND_API.G_RET_STS_SUCCESS;

3011: l_err_stack VARCHAR2(2000);
3012:
3013: BEGIN
3014:
3015: x_return_status := FND_API.G_RET_STS_SUCCESS;
3016:
3017: -- Get a unique identifier for this specific workflow
3018: --
3019: SELECT pa_workflow_itemkey_s.nextval

Line 3113: x_return_status := FND_API.G_RET_STS_ERROR;

3109:
3110: EXCEPTION
3111: WHEN OTHERS THEN
3112:
3113: x_return_status := FND_API.G_RET_STS_ERROR;
3114: x_msg_count := 1;
3115: x_msg_data := substr(SQLERRM,1,240);
3116: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_PA_ENTITIES',
3117: p_procedure_name => 'create_fte_sync_wf');

Line 3120: (p_encoded => FND_API.G_TRUE,

3116: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_PA_ENTITIES',
3117: p_procedure_name => 'create_fte_sync_wf');
3118: If x_msg_count = 1 THEN
3119: pa_interface_utils_pub.get_messages
3120: (p_encoded => FND_API.G_TRUE,
3121: p_msg_index => 1,
3122: p_msg_count => x_msg_count,
3123: p_msg_data => x_msg_data,
3124: p_data => x_msg_data,