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.PAY_CONTINUOUS_CALC dependencies on PAY_DYN_TRIGGERS

Line 79: if (pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then

75: l_calc_date := p_calc_date;
76: end if;
77: --
78: -- Setup the event_type
79: if (pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
80: l_event_type := p_event_type;
81: else
82: l_event_type := pay_dyn_triggers.g_dyt_mode;
83: end if;

Line 82: l_event_type := pay_dyn_triggers.g_dyt_mode;

78: -- Setup the event_type
79: if (pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
80: l_event_type := p_event_type;
81: else
82: l_event_type := pay_dyn_triggers.g_dyt_mode;
83: end if;
84: --
85: hr_utility.set_location('pay_continuous_calc.event_update', 10);
86: /* Search the cache does this event exist in the cache */

Line 1012: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

1008: end if;
1009: --
1010: l_noted_value := null;
1011: --
1012: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
1013: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
1014: --
1015: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1016: l_mode := 'D';

Line 1013: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

1009: --
1010: l_noted_value := null;
1011: --
1012: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
1013: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
1014: --
1015: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1016: l_mode := 'D';
1017: else

Line 1015: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then

1011: --
1012: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
1013: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
1014: --
1015: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1016: l_mode := 'D';
1017: else
1018: l_mode := pay_dyn_triggers.g_dyt_mode;
1019: end if;

Line 1018: l_mode := pay_dyn_triggers.g_dyt_mode;

1014: --
1015: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1016: l_mode := 'D';
1017: else
1018: l_mode := pay_dyn_triggers.g_dyt_mode;
1019: end if;
1020: l_effective_date := p_old_effective_start_date;
1021: l_column_name := null;
1022: l_old_value := null;

Line 1027: l_mode := pay_dyn_triggers.g_dyt_mode;

1023: l_new_value := null;
1024: l_noted_value := p_old_ELEMENT_TYPE_ID;
1025: --
1026: else
1027: l_mode := pay_dyn_triggers.g_dyt_mode;
1028: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
1029: --
1030: l_effective_date := p_new_effective_end_date;
1031: l_column_name := 'EFFECTIVE_END_DATE';

Line 1028: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then

1024: l_noted_value := p_old_ELEMENT_TYPE_ID;
1025: --
1026: else
1027: l_mode := pay_dyn_triggers.g_dyt_mode;
1028: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
1029: --
1030: l_effective_date := p_new_effective_end_date;
1031: l_column_name := 'EFFECTIVE_END_DATE';
1032: l_old_value := p_old_effective_end_date;

Line 1035: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'

1031: l_column_name := 'EFFECTIVE_END_DATE';
1032: l_old_value := p_old_effective_end_date;
1033: l_new_value := p_new_effective_end_date;
1034: --
1035: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
1036: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
1037: --
1038: l_effective_date := p_old_effective_start_date;
1039: l_column_name := 'EFFECTIVE_END_DATE';

Line 1036: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then

1032: l_old_value := p_old_effective_end_date;
1033: l_new_value := p_new_effective_end_date;
1034: --
1035: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
1036: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
1037: --
1038: l_effective_date := p_old_effective_start_date;
1039: l_column_name := 'EFFECTIVE_END_DATE';
1040: l_old_value := p_old_effective_end_date;

Line 11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

Line 11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11092: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

Line 11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11092: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11093: --
11094: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11095: l_mode := 'D';

Line 11092: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11092: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11093: --
11094: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11095: l_mode := 'D';
11096: else

Line 11094: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then

11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11092: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11093: --
11094: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11095: l_mode := 'D';
11096: else
11097: l_mode := pay_dyn_triggers.g_dyt_mode;
11098: end if;

Line 11097: l_mode := pay_dyn_triggers.g_dyt_mode;

11093: --
11094: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11095: l_mode := 'D';
11096: else
11097: l_mode := pay_dyn_triggers.g_dyt_mode;
11098: end if;
11099: l_effective_date := p_old_effective_start_date;
11100: l_column_name := null;
11101: l_old_value := null;

Line 11105: l_mode := pay_dyn_triggers.g_dyt_mode;

11101: l_old_value := null;
11102: l_new_value := null;
11103: --
11104: else
11105: l_mode := pay_dyn_triggers.g_dyt_mode;
11106: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11107: --
11108: l_effective_date := p_new_effective_end_date;
11109: l_column_name := 'EFFECTIVE_END_DATE';

Line 11106: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then

11102: l_new_value := null;
11103: --
11104: else
11105: l_mode := pay_dyn_triggers.g_dyt_mode;
11106: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11107: --
11108: l_effective_date := p_new_effective_end_date;
11109: l_column_name := 'EFFECTIVE_END_DATE';
11110: l_old_value := p_old_effective_end_date;

Line 11113: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'

11109: l_column_name := 'EFFECTIVE_END_DATE';
11110: l_old_value := p_old_effective_end_date;
11111: l_new_value := p_new_effective_end_date;
11112: --
11113: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11114: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11115: --
11116: l_effective_date := p_old_effective_start_date;
11117: l_column_name := 'EFFECTIVE_END_DATE';

Line 11114: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then

11110: l_old_value := p_old_effective_end_date;
11111: l_new_value := p_new_effective_end_date;
11112: --
11113: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11114: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11115: --
11116: l_effective_date := p_old_effective_start_date;
11117: l_column_name := 'EFFECTIVE_END_DATE';
11118: l_old_value := p_old_effective_end_date;

Line 11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

Line 11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11674: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

Line 11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11674: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11675: --
11676: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11677: l_mode := 'D';

Line 11674: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11674: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11675: --
11676: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11677: l_mode := 'D';
11678: else

Line 11676: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then

11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11674: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11675: --
11676: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11677: l_mode := 'D';
11678: else
11679: l_mode := pay_dyn_triggers.g_dyt_mode;
11680: end if;

Line 11679: l_mode := pay_dyn_triggers.g_dyt_mode;

11675: --
11676: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11677: l_mode := 'D';
11678: else
11679: l_mode := pay_dyn_triggers.g_dyt_mode;
11680: end if;
11681: l_effective_date := p_old_effective_start_date;
11682: l_column_name := null;
11683: l_old_value := null;

Line 11687: l_mode := pay_dyn_triggers.g_dyt_mode;

11683: l_old_value := null;
11684: l_new_value := null;
11685: --
11686: else
11687: l_mode := pay_dyn_triggers.g_dyt_mode;
11688: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11689: --
11690: l_effective_date := p_new_effective_end_date;
11691: l_column_name := 'EFFECTIVE_END_DATE';

Line 11688: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then

11684: l_new_value := null;
11685: --
11686: else
11687: l_mode := pay_dyn_triggers.g_dyt_mode;
11688: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11689: --
11690: l_effective_date := p_new_effective_end_date;
11691: l_column_name := 'EFFECTIVE_END_DATE';
11692: l_old_value := p_old_effective_end_date;

Line 11695: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'

11691: l_column_name := 'EFFECTIVE_END_DATE';
11692: l_old_value := p_old_effective_end_date;
11693: l_new_value := p_new_effective_end_date;
11694: --
11695: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11696: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11697: --
11698: l_effective_date := p_old_effective_start_date;
11699: l_column_name := 'EFFECTIVE_END_DATE';

Line 11696: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then

11692: l_old_value := p_old_effective_end_date;
11693: l_new_value := p_new_effective_end_date;
11694: --
11695: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11696: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11697: --
11698: l_effective_date := p_old_effective_start_date;
11699: l_column_name := 'EFFECTIVE_END_DATE';
11700: l_old_value := p_old_effective_end_date;

Line 11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

Line 11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11976: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

Line 11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11976: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11977: --
11978: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11979: l_mode := 'D';

Line 11976: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11976: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11977: --
11978: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11979: l_mode := 'D';
11980: else

Line 11978: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then

11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11976: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11977: --
11978: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11979: l_mode := 'D';
11980: else
11981: l_mode := pay_dyn_triggers.g_dyt_mode;
11982: end if;

Line 11981: l_mode := pay_dyn_triggers.g_dyt_mode;

11977: --
11978: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11979: l_mode := 'D';
11980: else
11981: l_mode := pay_dyn_triggers.g_dyt_mode;
11982: end if;
11983: l_effective_date := p_old_effective_start_date;
11984: l_column_name := null;
11985: l_old_value := null;

Line 11989: l_mode := pay_dyn_triggers.g_dyt_mode;

11985: l_old_value := null;
11986: l_new_value := null;
11987: --
11988: else
11989: l_mode := pay_dyn_triggers.g_dyt_mode;
11990: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11991: --
11992: l_effective_date := p_new_effective_end_date;
11993: l_column_name := 'EFFECTIVE_END_DATE';

Line 11990: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then

11986: l_new_value := null;
11987: --
11988: else
11989: l_mode := pay_dyn_triggers.g_dyt_mode;
11990: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11991: --
11992: l_effective_date := p_new_effective_end_date;
11993: l_column_name := 'EFFECTIVE_END_DATE';
11994: l_old_value := p_old_effective_end_date;

Line 11997: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'

11993: l_column_name := 'EFFECTIVE_END_DATE';
11994: l_old_value := p_old_effective_end_date;
11995: l_new_value := p_new_effective_end_date;
11996: --
11997: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11998: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11999: --
12000: l_effective_date := p_old_effective_start_date;
12001: l_column_name := 'EFFECTIVE_END_DATE';

Line 11998: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then

11994: l_old_value := p_old_effective_end_date;
11995: l_new_value := p_new_effective_end_date;
11996: --
11997: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11998: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11999: --
12000: l_effective_date := p_old_effective_start_date;
12001: l_column_name := 'EFFECTIVE_END_DATE';
12002: l_old_value := p_old_effective_end_date;

Line 12261: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

12257: if (g_override_cc = TRUE) then
12258: return;
12259: end if;
12260: --
12261: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12262: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12263: --
12264: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12265: l_mode := 'D';

Line 12262: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

12258: return;
12259: end if;
12260: --
12261: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12262: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12263: --
12264: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12265: l_mode := 'D';
12266: else

Line 12264: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then

12260: --
12261: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12262: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12263: --
12264: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12265: l_mode := 'D';
12266: else
12267: l_mode := pay_dyn_triggers.g_dyt_mode;
12268: end if;

Line 12267: l_mode := pay_dyn_triggers.g_dyt_mode;

12263: --
12264: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12265: l_mode := 'D';
12266: else
12267: l_mode := pay_dyn_triggers.g_dyt_mode;
12268: end if;
12269: l_effective_date := p_old_effective_start_date;
12270: l_column_name := null;
12271: l_old_value := null;

Line 12275: l_mode := pay_dyn_triggers.g_dyt_mode;

12271: l_old_value := null;
12272: l_new_value := null;
12273: --
12274: else
12275: l_mode := pay_dyn_triggers.g_dyt_mode;
12276: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
12277: --
12278: l_effective_date := p_new_effective_end_date;
12279: l_column_name := 'EFFECTIVE_END_DATE';

Line 12276: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then

12272: l_new_value := null;
12273: --
12274: else
12275: l_mode := pay_dyn_triggers.g_dyt_mode;
12276: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
12277: --
12278: l_effective_date := p_new_effective_end_date;
12279: l_column_name := 'EFFECTIVE_END_DATE';
12280: l_old_value := p_old_effective_end_date;

Line 12283: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'

12279: l_column_name := 'EFFECTIVE_END_DATE';
12280: l_old_value := p_old_effective_end_date;
12281: l_new_value := p_new_effective_end_date;
12282: --
12283: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
12284: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
12285: --
12286: l_effective_date := p_old_effective_start_date;
12287: l_column_name := 'EFFECTIVE_END_DATE';

Line 12284: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then

12280: l_old_value := p_old_effective_end_date;
12281: l_new_value := p_new_effective_end_date;
12282: --
12283: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
12284: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
12285: --
12286: l_effective_date := p_old_effective_start_date;
12287: l_column_name := 'EFFECTIVE_END_DATE';
12288: l_old_value := p_old_effective_end_date;