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 1033: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

1029: end if;
1030: --
1031: l_noted_value := null;
1032: --
1033: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
1034: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
1035: --
1036: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1037: l_mode := 'D';

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

1030: --
1031: l_noted_value := null;
1032: --
1033: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
1034: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
1035: --
1036: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1037: l_mode := 'D';
1038: else

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

1032: --
1033: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
1034: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
1035: --
1036: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1037: l_mode := 'D';
1038: else
1039: l_mode := pay_dyn_triggers.g_dyt_mode;
1040: end if;

Line 1039: l_mode := pay_dyn_triggers.g_dyt_mode;

1035: --
1036: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
1037: l_mode := 'D';
1038: else
1039: l_mode := pay_dyn_triggers.g_dyt_mode;
1040: end if;
1041: l_effective_date := p_old_effective_start_date;
1042: l_column_name := null;
1043: l_old_value := null;

Line 1048: l_mode := pay_dyn_triggers.g_dyt_mode;

1044: l_new_value := null;
1045: l_noted_value := p_old_ELEMENT_TYPE_ID;
1046: --
1047: else
1048: l_mode := pay_dyn_triggers.g_dyt_mode;
1049: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
1050: --
1051: l_effective_date := p_new_effective_end_date;
1052: l_column_name := 'EFFECTIVE_END_DATE';

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

1045: l_noted_value := p_old_ELEMENT_TYPE_ID;
1046: --
1047: else
1048: l_mode := pay_dyn_triggers.g_dyt_mode;
1049: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
1050: --
1051: l_effective_date := p_new_effective_end_date;
1052: l_column_name := 'EFFECTIVE_END_DATE';
1053: l_old_value := p_old_effective_end_date;

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

1052: l_column_name := 'EFFECTIVE_END_DATE';
1053: l_old_value := p_old_effective_end_date;
1054: l_new_value := p_new_effective_end_date;
1055: --
1056: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
1057: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
1058: --
1059: /*Bug 12556910 */
1060: open processed_recurring_entries(p_old_element_entry_id,p_old_effective_end_date);

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

1053: l_old_value := p_old_effective_end_date;
1054: l_new_value := p_new_effective_end_date;
1055: --
1056: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
1057: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
1058: --
1059: /*Bug 12556910 */
1060: open processed_recurring_entries(p_old_element_entry_id,p_old_effective_end_date);
1061: fetch processed_recurring_entries into lv_processed;

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

11115: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

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

11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11124: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

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

11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11124: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11125: --
11126: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11127: l_mode := 'D';

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

11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11124: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11125: --
11126: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11127: l_mode := 'D';
11128: else

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

11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11124: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11125: --
11126: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11127: l_mode := 'D';
11128: else
11129: l_mode := pay_dyn_triggers.g_dyt_mode;
11130: end if;

Line 11129: l_mode := pay_dyn_triggers.g_dyt_mode;

11125: --
11126: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11127: l_mode := 'D';
11128: else
11129: l_mode := pay_dyn_triggers.g_dyt_mode;
11130: end if;
11131: l_effective_date := p_old_effective_start_date;
11132: l_column_name := null;
11133: l_old_value := null;

Line 11137: l_mode := pay_dyn_triggers.g_dyt_mode;

11133: l_old_value := null;
11134: l_new_value := null;
11135: --
11136: else
11137: l_mode := pay_dyn_triggers.g_dyt_mode;
11138: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11139: --
11140: l_effective_date := p_new_effective_end_date;
11141: l_column_name := 'EFFECTIVE_END_DATE';

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

11134: l_new_value := null;
11135: --
11136: else
11137: l_mode := pay_dyn_triggers.g_dyt_mode;
11138: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11139: --
11140: l_effective_date := p_new_effective_end_date;
11141: l_column_name := 'EFFECTIVE_END_DATE';
11142: l_old_value := p_old_effective_end_date;

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

11141: l_column_name := 'EFFECTIVE_END_DATE';
11142: l_old_value := p_old_effective_end_date;
11143: l_new_value := p_new_effective_end_date;
11144: --
11145: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11146: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11147: --
11148: l_effective_date := p_old_effective_start_date;
11149: l_column_name := 'EFFECTIVE_END_DATE';

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

11142: l_old_value := p_old_effective_end_date;
11143: l_new_value := p_new_effective_end_date;
11144: --
11145: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11146: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11147: --
11148: l_effective_date := p_old_effective_start_date;
11149: l_column_name := 'EFFECTIVE_END_DATE';
11150: l_old_value := p_old_effective_end_date;

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

11697: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

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

11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11706: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

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

11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11706: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11707: --
11708: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11709: l_mode := 'D';

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

11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11706: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11707: --
11708: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11709: l_mode := 'D';
11710: else

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

11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11706: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
11707: --
11708: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11709: l_mode := 'D';
11710: else
11711: l_mode := pay_dyn_triggers.g_dyt_mode;
11712: end if;

Line 11711: l_mode := pay_dyn_triggers.g_dyt_mode;

11707: --
11708: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
11709: l_mode := 'D';
11710: else
11711: l_mode := pay_dyn_triggers.g_dyt_mode;
11712: end if;
11713: l_effective_date := p_old_effective_start_date;
11714: l_column_name := null;
11715: l_old_value := null;

Line 11719: l_mode := pay_dyn_triggers.g_dyt_mode;

11715: l_old_value := null;
11716: l_new_value := null;
11717: --
11718: else
11719: l_mode := pay_dyn_triggers.g_dyt_mode;
11720: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11721: --
11722: l_effective_date := p_new_effective_end_date;
11723: l_column_name := 'EFFECTIVE_END_DATE';

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

11716: l_new_value := null;
11717: --
11718: else
11719: l_mode := pay_dyn_triggers.g_dyt_mode;
11720: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
11721: --
11722: l_effective_date := p_new_effective_end_date;
11723: l_column_name := 'EFFECTIVE_END_DATE';
11724: l_old_value := p_old_effective_end_date;

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

11723: l_column_name := 'EFFECTIVE_END_DATE';
11724: l_old_value := p_old_effective_end_date;
11725: l_new_value := p_new_effective_end_date;
11726: --
11727: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11728: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11729: --
11730: l_effective_date := p_old_effective_start_date;
11731: l_column_name := 'EFFECTIVE_END_DATE';

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

11724: l_old_value := p_old_effective_end_date;
11725: l_new_value := p_new_effective_end_date;
11726: --
11727: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
11728: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
11729: --
11730: l_effective_date := p_old_effective_start_date;
11731: l_column_name := 'EFFECTIVE_END_DATE';
11732: l_old_value := p_old_effective_end_date;

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

11999: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

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

12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12008: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

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

12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12008: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12009: --
12010: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12011: l_mode := 'D';

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

12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12008: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12009: --
12010: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12011: l_mode := 'D';
12012: else

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

12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12008: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12009: --
12010: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12011: l_mode := 'D';
12012: else
12013: l_mode := pay_dyn_triggers.g_dyt_mode;
12014: end if;

Line 12013: l_mode := pay_dyn_triggers.g_dyt_mode;

12009: --
12010: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12011: l_mode := 'D';
12012: else
12013: l_mode := pay_dyn_triggers.g_dyt_mode;
12014: end if;
12015: l_effective_date := p_old_effective_start_date;
12016: l_column_name := null;
12017: l_old_value := null;

Line 12021: l_mode := pay_dyn_triggers.g_dyt_mode;

12017: l_old_value := null;
12018: l_new_value := null;
12019: --
12020: else
12021: l_mode := pay_dyn_triggers.g_dyt_mode;
12022: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
12023: --
12024: l_effective_date := p_new_effective_end_date;
12025: l_column_name := 'EFFECTIVE_END_DATE';

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

12018: l_new_value := null;
12019: --
12020: else
12021: l_mode := pay_dyn_triggers.g_dyt_mode;
12022: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
12023: --
12024: l_effective_date := p_new_effective_end_date;
12025: l_column_name := 'EFFECTIVE_END_DATE';
12026: l_old_value := p_old_effective_end_date;

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

12025: l_column_name := 'EFFECTIVE_END_DATE';
12026: l_old_value := p_old_effective_end_date;
12027: l_new_value := p_new_effective_end_date;
12028: --
12029: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
12030: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
12031: --
12032: l_effective_date := p_old_effective_start_date;
12033: l_column_name := 'EFFECTIVE_END_DATE';

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

12026: l_old_value := p_old_effective_end_date;
12027: l_new_value := p_new_effective_end_date;
12028: --
12029: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
12030: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
12031: --
12032: l_effective_date := p_old_effective_start_date;
12033: l_column_name := 'EFFECTIVE_END_DATE';
12034: l_old_value := p_old_effective_end_date;

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

12289: if (g_override_cc = TRUE) then
12290: return;
12291: end if;
12292: --
12293: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12294: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12295: --
12296: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12297: l_mode := 'D';

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

12290: return;
12291: end if;
12292: --
12293: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12294: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12295: --
12296: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12297: l_mode := 'D';
12298: else

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

12292: --
12293: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12294: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then
12295: --
12296: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12297: l_mode := 'D';
12298: else
12299: l_mode := pay_dyn_triggers.g_dyt_mode;
12300: end if;

Line 12299: l_mode := pay_dyn_triggers.g_dyt_mode;

12295: --
12296: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt) then
12297: l_mode := 'D';
12298: else
12299: l_mode := pay_dyn_triggers.g_dyt_mode;
12300: end if;
12301: l_effective_date := p_old_effective_start_date;
12302: l_column_name := null;
12303: l_old_value := null;

Line 12307: l_mode := pay_dyn_triggers.g_dyt_mode;

12303: l_old_value := null;
12304: l_new_value := null;
12305: --
12306: else
12307: l_mode := pay_dyn_triggers.g_dyt_mode;
12308: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
12309: --
12310: l_effective_date := p_new_effective_end_date;
12311: l_column_name := 'EFFECTIVE_END_DATE';

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

12304: l_new_value := null;
12305: --
12306: else
12307: l_mode := pay_dyn_triggers.g_dyt_mode;
12308: if (pay_dyn_triggers.g_dyt_mode = 'DELETE') then
12309: --
12310: l_effective_date := p_new_effective_end_date;
12311: l_column_name := 'EFFECTIVE_END_DATE';
12312: l_old_value := p_old_effective_end_date;

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

12311: l_column_name := 'EFFECTIVE_END_DATE';
12312: l_old_value := p_old_effective_end_date;
12313: l_new_value := p_new_effective_end_date;
12314: --
12315: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
12316: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
12317: --
12318: l_effective_date := p_old_effective_start_date;
12319: l_column_name := 'EFFECTIVE_END_DATE';

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

12312: l_old_value := p_old_effective_end_date;
12313: l_new_value := p_new_effective_end_date;
12314: --
12315: elsif (pay_dyn_triggers.g_dyt_mode = 'FUTURE_CHANGE'
12316: or pay_dyn_triggers.g_dyt_mode = 'DELETE_NEXT_CHANGE') then
12317: --
12318: l_effective_date := p_old_effective_start_date;
12319: l_column_name := 'EFFECTIVE_END_DATE';
12320: l_old_value := p_old_effective_end_date;