APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_ENTRIES

Line 203: from pay_retro_entries pre

199: --
200: begin
201: select 1
202: into l_dummy
203: from pay_retro_entries pre
204: where retro_assignment_id = p_retro_asg_id
205: and retro_component_id = p_retro_comp_id
206: and element_entry_id = p_entry_id;
207: --

Line 887: PAY_RETRO_ENTRIES table.

883: /*
884: Procedure: create_retro_entry
885: Description:
886: This procedure creates an entry in the
887: PAY_RETRO_ENTRIES table.
888: */
889: procedure create_retro_entry(
890: p_retro_assignment_id IN NUMBER
891: , p_element_entry_id IN NUMBER

Line 901: INSERT INTO pay_retro_entries

897: , p_system_reprocess_date IN DATE) is
898: --
899: Begin
900: --
901: INSERT INTO pay_retro_entries
902: ( retro_assignment_id
903: , element_entry_id
904: , reprocess_date
905: , effective_date

Line 928: PAY_RETRO_ENTRIES table.

924: /*
925: Procedure: maintain_retro_entry
926: Description:
927: This procedure creates and maintains an entry in the
928: PAY_RETRO_ENTRIES table.
929: */
930: procedure maintain_retro_entry
931: (
932: p_retro_assignment_id IN NUMBER

Line 945: l_retro_component_id pay_retro_entries.retro_component_id%type;

941: l_min_reprocess_date date;
942: l_min_effective_date date;
943: l_min_sys_reprocess_date date;
944: l_owner_type varchar2(30);
945: l_retro_component_id pay_retro_entries.retro_component_id%type;
946: n_min_reprocess_date date;
947: n_min_effective_date date;
948: n_min_sys_reprocess_date date;
949: n_owner_type varchar2(30);

Line 950: n_retro_component_id pay_retro_entries.retro_component_id%type;

946: n_min_reprocess_date date;
947: n_min_effective_date date;
948: n_min_sys_reprocess_date date;
949: n_owner_type varchar2(30);
950: n_retro_component_id pay_retro_entries.retro_component_id%type;
951: --
952: begin
953: --
954: select reprocess_date,

Line 964: from pay_retro_entries

960: l_min_effective_date,
961: l_owner_type,
962: l_min_sys_reprocess_date,
963: l_retro_component_id
964: from pay_retro_entries
965: where retro_assignment_id = p_retro_assignment_id
966: and element_entry_id = p_element_entry_id;
967: --
968: -- The reprocess and effective dates are always the least if a row exists

Line 1002: update pay_retro_entries

998: l_min_effective_date <> n_min_effective_date OR
999: l_min_sys_reprocess_date <> n_min_sys_reprocess_date OR
1000: l_owner_type <> n_owner_type OR
1001: l_retro_component_id <> n_retro_component_id) then
1002: update pay_retro_entries
1003: set reprocess_date = n_min_reprocess_date,
1004: effective_date = n_min_effective_date,
1005: retro_component_id = n_retro_component_id,
1006: owner_type = n_owner_type,

Line 1059: pay_retro_entries pre

1055: pre.retro_component_id,
1056: pre.owner_type,
1057: pre.system_reprocess_date
1058: from pay_retro_assignments pra,
1059: pay_retro_entries pre
1060: where pra.assignment_id = p_assignment_id
1061: and pra.retro_assignment_action_id is null
1062: and pra.retro_assignment_id = pre.retro_assignment_id;
1063: --

Line 1091: delete from pay_retro_entries

1087: unprocrec.retro_component_id,
1088: unprocrec.owner_type,
1089: unprocrec.system_reprocess_date
1090: );
1091: delete from pay_retro_entries
1092: where element_entry_id = unprocrec.element_entry_id
1093: and retro_assignment_id = unprocrec.retro_assignment_id;
1094: --
1095: end loop;