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.BEN_IRC_UTIL dependencies on HR_API

Line 17: nvl(p_pay_proposal_rec_old.PAY_PROPOSAL_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PAY_PROPOSAL_ID,hr_api.g_number )

13: begin
14: -- dbms_output.put_line('Entering pay');
15:
16: if
17: nvl(p_pay_proposal_rec_old.PAY_PROPOSAL_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PAY_PROPOSAL_ID,hr_api.g_number )
18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)
19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )

Line 18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)

14: -- dbms_output.put_line('Entering pay');
15:
16: if
17: nvl(p_pay_proposal_rec_old.PAY_PROPOSAL_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PAY_PROPOSAL_ID,hr_api.g_number )
18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)
19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )

Line 19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )

15:
16: if
17: nvl(p_pay_proposal_rec_old.PAY_PROPOSAL_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PAY_PROPOSAL_ID,hr_api.g_number )
18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)
19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )

Line 20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )

16: if
17: nvl(p_pay_proposal_rec_old.PAY_PROPOSAL_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PAY_PROPOSAL_ID,hr_api.g_number )
18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)
19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )

Line 21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )

17: nvl(p_pay_proposal_rec_old.PAY_PROPOSAL_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PAY_PROPOSAL_ID,hr_api.g_number )
18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)
19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )

Line 22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )

18: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY_N ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY_N ,hr_api.g_number)
19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )

Line 23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )

19: OR nvl(p_pay_proposal_rec_old.ASSIGNMENT_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.ASSIGNMENT_ID,hr_api.g_number )
20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )

Line 24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )

20: OR nvl(p_pay_proposal_rec_old.EVENT_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.EVENT_ID ,hr_api.g_number )
21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )

Line 25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )

21: OR nvl(p_pay_proposal_rec_old.BUSINESS_GROUP_ID ,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.BUSINESS_GROUP_ID,hr_api.g_number )
22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )

Line 26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )

22: OR nvl(p_pay_proposal_rec_old.FORCED_RANKING,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.FORCED_RANKING,hr_api.g_number )
23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )

Line 27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )

23: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_REVIEW_ID,hr_api.g_number ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_REVIEW_ID,hr_api.g_number )
24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )

Line 28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )

24: OR nvl(p_pay_proposal_rec_old.APPROVED,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.APPROVED,hr_api.g_varchar2 )
25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )

Line 29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )

25: OR nvl(p_pay_proposal_rec_old.MULTIPLE_COMPONENTS,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.MULTIPLE_COMPONENTS,hr_api.g_varchar2 )
26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )

Line 30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )

26: OR nvl(p_pay_proposal_rec_old.CHANGE_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.CHANGE_DATE ,hr_api.g_date )
27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )

Line 31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )

27: OR nvl(p_pay_proposal_rec_old.LAST_CHANGE_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.LAST_CHANGE_DATE ,hr_api.g_date )
28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )

Line 32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )

28: OR nvl(p_pay_proposal_rec_old.NEXT_PERF_REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_PERF_REVIEW_DATE,hr_api.g_date )
29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )

Line 33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )

29: OR nvl(p_pay_proposal_rec_old.NEXT_SAL_REVIEW_DATE,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.NEXT_SAL_REVIEW_DATE,hr_api.g_date )
30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )

Line 34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )

30: OR nvl(p_pay_proposal_rec_old.PERFORMANCE_RATING,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PERFORMANCE_RATING,hr_api.g_varchar2 )
31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )

Line 35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )

31: OR nvl(p_pay_proposal_rec_old.PROPOSAL_REASON,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSAL_REASON,hr_api.g_varchar2 )
32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )

Line 36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )

32: OR nvl(p_pay_proposal_rec_old.PROPOSED_SALARY ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.PROPOSED_SALARY,hr_api.g_varchar2 )
33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )

Line 37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )

33: OR nvl(p_pay_proposal_rec_old.REVIEW_DATE ,hr_api.g_date ) <> nvl(p_pay_proposal_rec_new.REVIEW_DATE,hr_api.g_date )
34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )

Line 38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )

34: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE_CATEGORY,hr_api.g_varchar2 )
35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )

Line 39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )

35: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE1,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE1,hr_api.g_varchar2 )
36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )

Line 40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )

36: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE2 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE2,hr_api.g_varchar2 )
37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)

Line 41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )

37: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE3 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE3,hr_api.g_varchar2 )
38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)

Line 42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )

38: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE4,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE4,hr_api.g_varchar2 )
39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)

Line 43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )

39: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE5 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE5,hr_api.g_varchar2 )
40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)

Line 44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)

40: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE6,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE6 ,hr_api.g_varchar2 )
41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)

Line 45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)

41: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE7 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE7,hr_api.g_varchar2 )
42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)

Line 46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)

42: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE8 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE8,hr_api.g_varchar2 )
43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)

Line 47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)

43: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE9 ,hr_api.g_varchar2 ) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE9,hr_api.g_varchar2 )
44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)

Line 48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)

44: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE10 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE10 ,hr_api.g_varchar2)
45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)

Line 49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)

45: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE11 ,hr_api.g_varchar2)
46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)

Line 50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)

46: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE12 ,hr_api.g_varchar2)
47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)
54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)

Line 51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)

47: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE13 ,hr_api.g_varchar2)
48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)
54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)
55: OR nvl(p_pay_proposal_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_pay_proposal_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number )

Line 52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)

48: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE14 ,hr_api.g_varchar2)
49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)
54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)
55: OR nvl(p_pay_proposal_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_pay_proposal_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number )
56: then

Line 53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)

49: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE15 ,hr_api.g_varchar2)
50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)
54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)
55: OR nvl(p_pay_proposal_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_pay_proposal_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number )
56: then
57: return true;

Line 54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)

50: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE16 ,hr_api.g_varchar2)
51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)
54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)
55: OR nvl(p_pay_proposal_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_pay_proposal_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number )
56: then
57: return true;
58: else

Line 55: OR nvl(p_pay_proposal_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_pay_proposal_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number )

51: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE17 ,hr_api.g_varchar2)
52: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE18 ,hr_api.g_varchar2)
53: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE19 ,hr_api.g_varchar2)
54: OR nvl(p_pay_proposal_rec_old.ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_pay_proposal_rec_new.ATTRIBUTE20 ,hr_api.g_varchar2)
55: OR nvl(p_pay_proposal_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_pay_proposal_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number )
56: then
57: return true;
58: else
59: return false;

Line 76: nvl(p_offer_assignment_rec_old.RECRUITER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITER_ID,hr_api.g_number)

72: begin
73: --dbms_output.put_line('Entering offer');
74:
75: if
76: nvl(p_offer_assignment_rec_old.RECRUITER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITER_ID,hr_api.g_number)
77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)
78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)

Line 77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)

73: --dbms_output.put_line('Entering offer');
74:
75: if
76: nvl(p_offer_assignment_rec_old.RECRUITER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITER_ID,hr_api.g_number)
77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)
78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)

Line 78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)

74:
75: if
76: nvl(p_offer_assignment_rec_old.RECRUITER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITER_ID,hr_api.g_number)
77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)
78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)

Line 79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)

75: if
76: nvl(p_offer_assignment_rec_old.RECRUITER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITER_ID,hr_api.g_number)
77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)
78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)

Line 80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)

76: nvl(p_offer_assignment_rec_old.RECRUITER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITER_ID,hr_api.g_number)
77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)
78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)

Line 81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)

77: OR nvl(p_offer_assignment_rec_old.GRADE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_ID,hr_api.g_number)
78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)

Line 82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)

78: OR nvl(p_offer_assignment_rec_old.POSITION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSITION_ID,hr_api.g_number)
79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)

Line 83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)

79: OR nvl(p_offer_assignment_rec_old.JOB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.JOB_ID,hr_api.g_number)
80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)

Line 84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)

80: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)

Line 85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)

81: OR nvl(p_offer_assignment_rec_old.PAYROLL_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAYROLL_ID,hr_api.g_number)
82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)

Line 86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)

82: OR nvl(p_offer_assignment_rec_old.LOCATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.LOCATION_ID,hr_api.g_number)
83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)

Line 87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)

83: OR nvl(p_offer_assignment_rec_old.PERSON_REFERRED_BY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_REFERRED_BY_ID,hr_api.g_number)
84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)

Line 88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)

84: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ID,hr_api.g_number)
85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)

Line 89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)

85: OR nvl(p_offer_assignment_rec_old.SPECIAL_CEILING_STEP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)

Line 90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)

86: OR nvl(p_offer_assignment_rec_old.PERSON_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERSON_ID,hr_api.g_number)
87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)

Line 91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)

87: OR nvl(p_offer_assignment_rec_old.RECRUITMENT_ACTIVITY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)

Line 92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)

88: OR nvl(p_offer_assignment_rec_old.SOURCE_ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOURCE_ORGANIZATION_ID,hr_api.g_number)
89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)

Line 93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)

89: OR nvl(p_offer_assignment_rec_old.ORGANIZATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ORGANIZATION_ID,hr_api.g_number)
90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)

Line 94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)

90: OR nvl(p_offer_assignment_rec_old.PEOPLE_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PEOPLE_GROUP_ID,hr_api.g_number)
91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)

Line 95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)

91: OR nvl(p_offer_assignment_rec_old.SOFT_CODING_KEYFLEX_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)

Line 96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)

92: OR nvl(p_offer_assignment_rec_old.VACANCY_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VACANCY_ID,hr_api.g_number)
93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)

Line 97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)

93: OR nvl(p_offer_assignment_rec_old.PAY_BASIS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PAY_BASIS_ID,hr_api.g_number)
94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)

Line 98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)

94: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_SEQUENCE,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_SEQUENCE,hr_api.g_number)
95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)

Line 99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)

95: OR nvl(p_offer_assignment_rec_old.APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICATION_ID,hr_api.g_number)
96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)

Line 100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)

96: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)

Line 101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)

97: OR nvl(p_offer_assignment_rec_old.CHANGE_REASON ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.CHANGE_REASON ,hr_api.g_varchar2)
98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)

Line 102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)

98: OR nvl(p_offer_assignment_rec_old.COMMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COMMENT_ID,hr_api.g_number)
99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)

Line 103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)

99: OR nvl(p_offer_assignment_rec_old.DATE_PROBATION_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.DATE_PROBATION_END,hr_api.g_date)
100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)

Line 104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)

100: OR nvl(p_offer_assignment_rec_old.DEFAULT_CODE_COMB_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.DEFAULT_CODE_COMB_ID,hr_api.g_number)
101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)

Line 105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)

101: OR nvl(p_offer_assignment_rec_old.EMPLOYMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYMENT_CATEGORY,hr_api.g_varchar2)
102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)

Line 106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)

102: OR nvl(p_offer_assignment_rec_old.FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.FREQUENCY ,hr_api.g_varchar2)
103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)

Line 107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)

103: OR nvl(p_offer_assignment_rec_old.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.INTERNAL_ADDRESS_LINE,hr_api.g_varchar2)
104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)

Line 108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)

104: OR nvl(p_offer_assignment_rec_old.MANAGER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.MANAGER_FLAG,hr_api.g_varchar2)
105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)

Line 109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)

105: OR nvl(p_offer_assignment_rec_old.NORMAL_HOURS ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NORMAL_HOURS ,hr_api.g_number)
106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)

Line 110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)

106: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD ,hr_api.g_number)
107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)

Line 111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)

107: OR nvl(p_offer_assignment_rec_old.PERF_REVIEW_PERIOD_FREQUENCY,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PERF_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)

Line 112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)

108: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_SERVICE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_SERVICE_ID,hr_api.g_number)
109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)

Line 113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)

109: OR nvl(p_offer_assignment_rec_old.PROBATION_PERIOD,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROBATION_PERIOD,hr_api.g_number)
110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)

Line 114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)

110: OR nvl(p_offer_assignment_rec_old.PROBATION_UNIT ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROBATION_UNIT,hr_api.g_varchar2)
111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)

Line 115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)

111: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD,hr_api.g_number)
112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)

Line 116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)

112: OR nvl(p_offer_assignment_rec_old.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SAL_REVIEW_PERIOD_FREQUENCY ,hr_api.g_varchar2)
113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)

Line 117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)

113: OR nvl(p_offer_assignment_rec_old.SET_OF_BOOKS_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SET_OF_BOOKS_ID,hr_api.g_number)
114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)

Line 118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)

114: OR nvl(p_offer_assignment_rec_old.SOURCE_TYPE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.SOURCE_TYPE,hr_api.g_varchar2)
115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)

Line 119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)

115: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_FINISH,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_FINISH ,hr_api.g_varchar2)
116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)

Line 120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)

116: OR nvl(p_offer_assignment_rec_old.TIME_NORMAL_START ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TIME_NORMAL_START,hr_api.g_varchar2)
117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)

Line 121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)

117: OR nvl(p_offer_assignment_rec_old.REQUEST_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.REQUEST_ID,hr_api.g_number)
118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)

Line 122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)

118: OR nvl(p_offer_assignment_rec_old.PROGRAM_APPLICATION_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_APPLICATION_ID,hr_api.g_number)
119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)

Line 123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)

119: OR nvl(p_offer_assignment_rec_old.PROGRAM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PROGRAM_ID,hr_api.g_number)
120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)

Line 124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)

120: OR nvl(p_offer_assignment_rec_old.PROGRAM_UPDATE_DATE,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROGRAM_UPDATE_DATE,hr_api.g_date)
121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)

Line 125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)

121: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE_CATEGORY ,hr_api.g_varchar2)
122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)

Line 126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)

122: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE1 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE1,hr_api.g_varchar2)
123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)

Line 127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)

123: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE2 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE2 ,hr_api.g_varchar2)
124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)

Line 128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)

124: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE3 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE3 ,hr_api.g_varchar2)
125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)

Line 129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)

125: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE4 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE4 ,hr_api.g_varchar2)
126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)

Line 130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)

126: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE5 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE5 ,hr_api.g_varchar2)
127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)

Line 131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)

127: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE6 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE6,hr_api.g_varchar2)
128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)

Line 132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)

128: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE7 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE7 ,hr_api.g_varchar2)
129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)

Line 133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)

129: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE8 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE8 ,hr_api.g_varchar2)
130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)

Line 134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)

130: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE9 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE9 ,hr_api.g_varchar2)
131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)

Line 135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)

131: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE10,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE10,hr_api.g_varchar2)
132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)

Line 136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)

132: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE11 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE11,hr_api.g_varchar2)
133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)

Line 137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)

133: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE12 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE12 ,hr_api.g_varchar2)
134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)

Line 138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)

134: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE13 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE13 ,hr_api.g_varchar2)
135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)

Line 139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)

135: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE14 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE14 ,hr_api.g_varchar2)
136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)

Line 140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)

136: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE15 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE15 ,hr_api.g_varchar2)
137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)

Line 141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)

137: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE16 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE16 ,hr_api.g_varchar2)
138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)

Line 142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)

138: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE17 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE17 ,hr_api.g_varchar2)
139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)

Line 143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)

139: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE18 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE18 ,hr_api.g_varchar2)
140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)

Line 144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)

140: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE19 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE19 ,hr_api.g_varchar2)
141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)

Line 145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)

141: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE20 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE20 ,hr_api.g_varchar2)
142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)

Line 146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)

142: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE21 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE21 ,hr_api.g_varchar2)
143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)

Line 147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)

143: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE22 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE22 ,hr_api.g_varchar2)
144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)

Line 148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)

144: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE23 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE23 ,hr_api.g_varchar2)
145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)

Line 149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)

145: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE24 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE24 ,hr_api.g_varchar2)
146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)

Line 150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)

146: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE25 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE25 ,hr_api.g_varchar2)
147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)

Line 151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)

147: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE26 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE26 ,hr_api.g_varchar2)
148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)

Line 152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)

148: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE27 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE27 ,hr_api.g_varchar2)
149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)

Line 153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)

149: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE28 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE28 ,hr_api.g_varchar2)
150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)

Line 154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)

150: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE29 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE29 ,hr_api.g_varchar2)
151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)

Line 155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)

151: OR nvl(p_offer_assignment_rec_old.ASS_ATTRIBUTE30 ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASS_ATTRIBUTE30 ,hr_api.g_varchar2)
152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)

Line 156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)

152: OR nvl(p_offer_assignment_rec_old.TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.TITLE ,hr_api.g_varchar2)
153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)

Line 157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)

153: OR nvl(p_offer_assignment_rec_old.OBJECT_VERSION_NUMBER ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.OBJECT_VERSION_NUMBER,hr_api.g_number)
154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)

Line 158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)

154: OR nvl(p_offer_assignment_rec_old.BARGAINING_UNIT_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.BARGAINING_UNIT_CODE ,hr_api.g_varchar2)
155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)

Line 159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)

155: OR nvl(p_offer_assignment_rec_old.LABOUR_UNION_MEMBER_FLAG,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.LABOUR_UNION_MEMBER_FLAG ,hr_api.g_varchar2)
156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)

Line 160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)

156: OR nvl(p_offer_assignment_rec_old.HOURLY_SALARIED_CODE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.HOURLY_SALARIED_CODE ,hr_api.g_varchar2)
157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)

Line 161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)

157: OR nvl(p_offer_assignment_rec_old.CONTRACT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CONTRACT_ID,hr_api.g_number)
158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)

Line 162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)

158: OR nvl(p_offer_assignment_rec_old.COLLECTIVE_AGREEMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)

Line 163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)

159: OR nvl(p_offer_assignment_rec_old.CAGR_ID_FLEX_NUM ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_ID_FLEX_NUM ,hr_api.g_number)
160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)

Line 164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)

160: OR nvl(p_offer_assignment_rec_old.CAGR_GRADE_DEF_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.CAGR_GRADE_DEF_ID,hr_api.g_number)
161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)

Line 165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)

161: OR nvl(p_offer_assignment_rec_old.ESTABLISHMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.ESTABLISHMENT_ID,hr_api.g_number)
162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)

Line 166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)

162: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD ,hr_api.g_number)
163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)

Line 167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)

163: OR nvl(p_offer_assignment_rec_old.NOTICE_PERIOD_UOM ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.NOTICE_PERIOD_UOM ,hr_api.g_varchar2)
164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)

Line 168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)

164: OR nvl(p_offer_assignment_rec_old.EMPLOYEE_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.EMPLOYEE_CATEGORY ,hr_api.g_varchar2)
165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)

Line 169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)

165: OR nvl(p_offer_assignment_rec_old.WORK_AT_HOME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.WORK_AT_HOME ,hr_api.g_varchar2)
166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)

Line 170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)

166: OR nvl(p_offer_assignment_rec_old.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.JOB_POST_SOURCE_NAME ,hr_api.g_varchar2)
167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)

Line 171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)

167: OR nvl(p_offer_assignment_rec_old.POSTING_CONTENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.POSTING_CONTENT_ID,hr_api.g_number)
168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)

Line 172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)

168: OR nvl(p_offer_assignment_rec_old.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PERIOD_OF_PLACEMENT_DATE_START,hr_api.g_date)
169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)

Line 173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)

169: OR nvl(p_offer_assignment_rec_old.VENDOR_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_ID,hr_api.g_number)
170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)

Line 174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)

170: OR nvl(p_offer_assignment_rec_old.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_EMPLOYEE_NUMBER ,hr_api.g_varchar2)
171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)

Line 175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)

171: OR nvl(p_offer_assignment_rec_old.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.VENDOR_ASSIGNMENT_NUMBER ,hr_api.g_varchar2)
172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)

Line 176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)

172: OR nvl(p_offer_assignment_rec_old.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.ASSIGNMENT_CATEGORY ,hr_api.g_varchar2)
173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)
180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)

Line 177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)

173: OR nvl(p_offer_assignment_rec_old.PROJECT_TITLE ,hr_api.g_varchar2) <> nvl(p_offer_assignment_rec_new.PROJECT_TITLE ,hr_api.g_varchar2)
174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)
180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)
181: OR nvl(p_offer_assignment_rec_old.BUSINESS_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.BUSINESS_GROUP_ID,hr_api.g_number)

Line 178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)

174: OR nvl(p_offer_assignment_rec_old.APPLICANT_RANK ,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.APPLICANT_RANK ,hr_api.g_number)
175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)
180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)
181: OR nvl(p_offer_assignment_rec_old.BUSINESS_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.BUSINESS_GROUP_ID,hr_api.g_number)
182:

Line 179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)

175: OR nvl(p_offer_assignment_rec_old.GRADE_LADDER_PGM_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.GRADE_LADDER_PGM_ID,hr_api.g_number)
176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)
180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)
181: OR nvl(p_offer_assignment_rec_old.BUSINESS_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.BUSINESS_GROUP_ID,hr_api.g_number)
182:
183: then

Line 180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)

176: OR nvl(p_offer_assignment_rec_old.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.SUPERVISOR_ASSIGNMENT_ID,hr_api.g_number)
177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)
180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)
181: OR nvl(p_offer_assignment_rec_old.BUSINESS_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.BUSINESS_GROUP_ID,hr_api.g_number)
182:
183: then
184: return true;

Line 181: OR nvl(p_offer_assignment_rec_old.BUSINESS_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.BUSINESS_GROUP_ID,hr_api.g_number)

177: OR nvl(p_offer_assignment_rec_old.VENDOR_SITE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.VENDOR_SITE_ID,hr_api.g_number)
178: OR nvl(p_offer_assignment_rec_old.PO_HEADER_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_HEADER_ID,hr_api.g_number)
179: OR nvl(p_offer_assignment_rec_old.PO_LINE_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.PO_LINE_ID,hr_api.g_number)
180: OR nvl(p_offer_assignment_rec_old.PROJECTED_ASSIGNMENT_END,hr_api.g_date) <> nvl(p_offer_assignment_rec_new.PROJECTED_ASSIGNMENT_END,hr_api.g_date)
181: OR nvl(p_offer_assignment_rec_old.BUSINESS_GROUP_ID,hr_api.g_number) <> nvl(p_offer_assignment_rec_new.BUSINESS_GROUP_ID,hr_api.g_number)
182:
183: then
184: return true;
185: else