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 689: WHEN FND_API.G_EXC_ERROR

685:
686: --
687: EXCEPTION
688: /*
689: WHEN FND_API.G_EXC_ERROR
690: THEN
691: wf_core.context('pa_hr_update_pa_objects',
692: 'start_date_change',
693: itemtype,

Line 701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

697: if (l_savepoint) then
698: rollback to l_org_struct_element_change ;
699: End if;
700:
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
702: THEN
703: wf_core.context('pa_hr_update_pa_objects',
704: 'start_date_change',
705: itemtype,

Line 872: /* WHEN FND_API.G_EXC_ERROR

868: log_message('l_return_status: '||l_return_status);
869:
870: --
871: EXCEPTION
872: /* WHEN FND_API.G_EXC_ERROR
873: THEN
874: wf_core.context('pa_hr_update_pa_objects',
875: 'start_date_change',
876: itemtype,

Line 888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

884: p_item_key => itemkey,
885: p_msg_count => l_msg_count,
886: p_msg_data => l_msg_data);
887:
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
889: THEN
890: wf_core.context('pa_hr_update_pa_objects',
891: 'start_date_change',
892: itemtype,

Line 1045: /* WHEN FND_API.G_EXC_ERROR

1041:
1042:
1043: --
1044: EXCEPTION
1045: /* WHEN FND_API.G_EXC_ERROR
1046: THEN
1047: wf_core.context('pa_hr_update_pa_entities',
1048: 'Full_Name_Change',
1049: itemtype,

Line 1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1058: p_msg_count => l_msg_count,
1059: p_msg_data => l_msg_data);
1060: resultout := wf_engine.eng_completed||':'||'F';
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1063: THEN
1064: wf_core.context('pa_hr_update_pa_entities',
1065: 'Full_Name_Change',
1066: itemtype,

Line 1235: /* WHEN FND_API.G_EXC_ERROR

1231: END IF;
1232:
1233: --
1234: EXCEPTION
1235: /* WHEN FND_API.G_EXC_ERROR
1236: THEN
1237: If (l_savepoint) then
1238: rollback to l_ou_change ;
1239: End if;

Line 1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1250:
1251: resultout := wf_engine.eng_completed||':'||'F';
1252: -- RAISE;
1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1255: THEN
1256:
1257: If (l_savepoint) then
1258: rollback to l_ou_change ;

Line 1437: /* WHEN FND_API.G_EXC_ERROR

1433:
1434:
1435: --
1436: EXCEPTION
1437: /* WHEN FND_API.G_EXC_ERROR
1438: THEN
1439: If (l_savepoint) then
1440: rollback to l_valid_grade_change ;
1441: End if;

Line 1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1450: p_msg_count => l_msg_count,
1451: p_msg_data => l_msg_data);
1452: resultout := wf_engine.eng_completed||':'||'F';
1453:
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1455: THEN
1456: If (l_savepoint) then
1457: rollback to l_valid_grade_change ;
1458: End if;

Line 1607: /* WHEN FND_API.G_EXC_ERROR

1603: END IF;
1604:
1605:
1606: EXCEPTION
1607: /* WHEN FND_API.G_EXC_ERROR
1608: THEN
1609: If (l_savepoint) then
1610: rollback to l_job_level_change ;
1611: End if;

Line 1626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1622: p_msg_data => l_msg_data);
1623:
1624: resultout := wf_engine.eng_completed||':'||'F';
1625:
1626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1627: THEN
1628: If (l_savepoint) then
1629: rollback to l_job_level_change ;
1630: End if;

Line 1855: /* WHEN FND_API.G_EXC_ERROR

1851:
1852:
1853:
1854: EXCEPTION
1855: /* WHEN FND_API.G_EXC_ERROR
1856: THEN
1857: If (l_savepoint) then
1858: rollback to l_address_change ;
1859: end if;

Line 1875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1871: p_msg_data => l_msg_data);
1872:
1873: resultout := wf_engine.eng_completed||':'||'F';
1874:
1875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1876: THEN
1877: If (l_savepoint) then
1878: rollback to l_address_change ;
1879: End if;

Line 2109: /* WHEN FND_API.G_EXC_ERROR

2105: END IF;
2106:
2107: --
2108: EXCEPTION
2109: /* WHEN FND_API.G_EXC_ERROR
2110: THEN
2111: If (l_savepoint) then
2112: rollback to l_project_org_change ;
2113: end if;

Line 2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2125:
2126: resultout := wf_engine.eng_completed||':'||'F';
2127: --RAISE;
2128:
2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2130: THEN
2131: If (l_savepoint) then
2132: rollback to l_project_org_change ;
2133: End if;

Line 2309: /* WHEN FND_API.G_EXC_ERROR

2305: END IF;
2306:
2307: --
2308: EXCEPTION
2309: /* WHEN FND_API.G_EXC_ERROR
2310: THEN
2311: If (l_savepoint) then
2312: rollback to l_job_rel_change ;
2313: End if;

Line 2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2324: p_msg_data => l_msg_data);
2325:
2326: resultout := wf_engine.eng_completed||':'||'F';
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2329: THEN
2330: If (l_savepoint) then
2331: rollback to l_job_rel_change ;
2332: End if;

Line 2451: l_final_return_status := FND_API.G_RET_STS_SUCCESS ;

2447: --
2448: -- Initialize workflow item attributes
2449: --
2450:
2451: l_final_return_status := FND_API.G_RET_STS_SUCCESS ;
2452:
2453: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2454: itemkey => itemkey,
2455: aname => 'CALLING_MODE' );

Line 2597: ,p_commit => FND_API.G_FALSE

2593: l_savepoint := true;
2594: pa_r_project_resources_pub.create_resource (
2595: p_api_version => 1.0
2596: ,p_init_msg_list => NULL
2597: ,p_commit => FND_API.G_FALSE
2598: ,p_validate_only => NULL
2599: ,p_max_msg_count => NULL
2600: ,p_internal => 'Y'
2601: ,p_person_id => l_person_id

Line 2655: ,p_commit => FND_API.G_FALSE

2651: -- call the work flow to update pa objects
2652: pa_r_project_resources_pub.create_resource (
2653: p_api_version => 1.0
2654: ,p_init_msg_list => NULL
2655: ,p_commit => FND_API.G_FALSE
2656: ,p_validate_only => NULL
2657: ,p_max_msg_count => NULL
2658: ,p_internal => 'Y'
2659: ,p_person_id => l_person_id

Line 2790: ,p_commit => FND_API.G_FALSE

2786:
2787: pa_r_project_resources_pub.create_resource (
2788: p_api_version => 1.0
2789: ,p_init_msg_list => NULL
2790: ,p_commit => FND_API.G_FALSE
2791: ,p_validate_only => NULL
2792: ,p_max_msg_count => NULL
2793: ,p_internal => 'Y'
2794: ,p_person_id => l_person_id

Line 2998: WHEN FND_API.G_EXC_ERROR THEN

2994: resultout := wf_engine.eng_completed||':'||'F';
2995: END IF;
2996:
2997: EXCEPTION
2998: WHEN FND_API.G_EXC_ERROR THEN
2999: If (l_savepoint) then
3000: rollback to l_assignment_change ;
3001: end if;
3002:

Line 3029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3025:
3026: resultout := wf_engine.eng_completed||':'||'F';
3027: --RAISE;
3028:
3029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3030: If (l_savepoint) then
3031: rollback to l_assignment_change ;
3032: End if;
3033:

Line 3152: (p_encoded => FND_API.G_FALSE,

3148: EXIT;
3149: END IF;
3150:
3151: pa_interface_utils_pub.get_messages
3152: (p_encoded => FND_API.G_FALSE,
3153: p_msg_index => i,
3154: p_msg_count => p_msg_count ,
3155: p_msg_data => p_msg_data ,
3156: p_data => l_data,

Line 3212: x_return_status := FND_API.G_RET_STS_SUCCESS;

3208: l_err_stack VARCHAR2(2000);
3209:
3210: BEGIN
3211:
3212: x_return_status := FND_API.G_RET_STS_SUCCESS;
3213:
3214: -- Get a unique identifier for this specific workflow
3215: --
3216: SELECT pa_workflow_itemkey_s.nextval

Line 3310: x_return_status := FND_API.G_RET_STS_ERROR;

3306:
3307: EXCEPTION
3308: WHEN OTHERS THEN
3309:
3310: x_return_status := FND_API.G_RET_STS_ERROR;
3311: x_msg_count := 1;
3312: x_msg_data := substr(SQLERRM,1,240);
3313: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_PA_ENTITIES',
3314: p_procedure_name => 'create_fte_sync_wf');

Line 3317: (p_encoded => FND_API.G_TRUE,

3313: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_PA_ENTITIES',
3314: p_procedure_name => 'create_fte_sync_wf');
3315: If x_msg_count = 1 THEN
3316: pa_interface_utils_pub.get_messages
3317: (p_encoded => FND_API.G_TRUE,
3318: p_msg_index => 1,
3319: p_msg_count => x_msg_count,
3320: p_msg_data => x_msg_data,
3321: p_data => x_msg_data,