APPS.HR_PAY_INTERFACE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 837: -- pay_element_entries_f.

833: --
834: -- This procedure returns an error if an attempt is being made to
835: -- perform a Datetrack purge of an element entry. Certain types of Datetrack
836: -- delete are allowable, so we cannot simply prevent all deletes against
837: -- pay_element_entries_f.
838: --
839: -- If we try to access pay_element_entries_f from a delete trigger on
840: -- the same table, we hit a mutating table error. So we must perform
841: -- the delete check against a different table to that against which the

Line 839: -- If we try to access pay_element_entries_f from a delete trigger on

835: -- perform a Datetrack purge of an element entry. Certain types of Datetrack
836: -- delete are allowable, so we cannot simply prevent all deletes against
837: -- pay_element_entries_f.
838: --
839: -- If we try to access pay_element_entries_f from a delete trigger on
840: -- the same table, we hit a mutating table error. So we must perform
841: -- the delete check against a different table to that against which the
842: -- delete trigger is created.
843: --

Line 846: -- rows are deleted from pay_element_entries_f before they are deleted from

842: -- delete trigger is created.
843: --
844: -- We are making use of the validation rule that states that each
845: -- element entry must have at least one entry value. Within a commit unit,
846: -- rows are deleted from pay_element_entries_f before they are deleted from
847: -- pay_element_entry_values_f.
848: --
849: -- So the delete trigger is created against pay_element_entry_values_f, and
850: -- this procedure looks at pay_element_entries_f. The user is attempting a

Line 850: -- this procedure looks at pay_element_entries_f. The user is attempting a

846: -- rows are deleted from pay_element_entries_f before they are deleted from
847: -- pay_element_entry_values_f.
848: --
849: -- So the delete trigger is created against pay_element_entry_values_f, and
850: -- this procedure looks at pay_element_entries_f. The user is attempting a
851: -- Datetrack purge if there are no parent element entries that match
852: -- the element entry value that is being deleted.
853: --
854: -- This procedure uses the global g_ele_start_date to verify if the

Line 866: l_attrib1 pay_element_entries_f.attribute1%TYPE := NULL;

862: -- Attribute1 in pay_element_types_f is from this point
863: -- to be used as a flag to identify that it is a deduction element
864: --
865: dummy integer;
866: l_attrib1 pay_element_entries_f.attribute1%TYPE := NULL;
867:
868: BEGIN
869: --
870: IF g_ele_start_date <= TRUNC(sysdate) THEN

Line 874: FROM pay_element_entries_f

870: IF g_ele_start_date <= TRUNC(sysdate) THEN
871:
872: SELECT COUNT(element_entry_id)
873: INTO dummy
874: FROM pay_element_entries_f
875: WHERE element_entry_id = g_ele_entry_id;
876: --
877: IF (dummy = 0) THEN
878: SELECT pt.attribute1

Line 913: pay_element_entries_f.element_link_id%TYPE,

909:
910: --
911: -------------------------------------------------------------------------
912: PROCEDURE set_ele_var_ids(p_ele_link_id
913: pay_element_entries_f.element_link_id%TYPE,
914: p_ele_entry_id
915: pay_element_entries_f.element_entry_id%TYPE,
916: p_ele_start_date
917: pay_element_entries_f.effective_start_date%TYPE,

Line 915: pay_element_entries_f.element_entry_id%TYPE,

911: -------------------------------------------------------------------------
912: PROCEDURE set_ele_var_ids(p_ele_link_id
913: pay_element_entries_f.element_link_id%TYPE,
914: p_ele_entry_id
915: pay_element_entries_f.element_entry_id%TYPE,
916: p_ele_start_date
917: pay_element_entries_f.effective_start_date%TYPE,
918: p_ele_person_id
919: per_all_people_f.person_id%TYPE)

Line 917: pay_element_entries_f.effective_start_date%TYPE,

913: pay_element_entries_f.element_link_id%TYPE,
914: p_ele_entry_id
915: pay_element_entries_f.element_entry_id%TYPE,
916: p_ele_start_date
917: pay_element_entries_f.effective_start_date%TYPE,
918: p_ele_person_id
919: per_all_people_f.person_id%TYPE)
920: -------------------------------------------------------------------------
921: -- This procedure stores the global variables for