DBA Data[Home] [Help]

APPS.HR_GENERAL2 dependencies on ALL_TRIGGERS

Line 105: alogue 31-Mar-2004 115.44 3544109 Changed all_triggers to user_triggers.

101: for JP legislation
102: dcasemor 01-Mar-2004 115.42 3346940 Added supervisor_assignments_in_use.
103: dcasemor 11-Mar-2004 115.43 3346940 Changed supervisor_assignments_in_use
104: so it references a new profile option.
105: alogue 31-Mar-2004 115.44 3544109 Changed all_triggers to user_triggers.
106: kramajey 13-Jun-2005 115.45 4341787 Changed the join in the sql statement
107: in is_duplicate_person procedure
108: for performance in JP Legislation.
109: sgelvi 31-May-2006 115.46 Added hrms_efc_column function

Line 1017: l_ovn_trigger all_triggers.trigger_name%TYPE := null;

1013:
1014:
1015:
1016: --
1017: l_ovn_trigger all_triggers.trigger_name%TYPE := null;
1018: l_proc varchar2(72);
1019: --
1020: -- Local function establishes for a single database table
1021: -- if an OVN trigger exists and the full trigger name.

Line 1026: l_ovn_trigger_name all_triggers.trigger_name%TYPE := null;

1022: --
1023: function get_ovn_trigger
1024: (p_table_name in varchar2)
1025: return varchar2 is
1026: l_ovn_trigger_name all_triggers.trigger_name%TYPE := null;
1027: begin
1028: select alt.trigger_name
1029: into l_ovn_trigger_name
1030: from user_triggers alt