DBA Data[Home] [Help]

APPS.PER_HRWF_SYNCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 130: -- per_all_assignments_f%rowtype and p_action(INSERT, DELETE, UPDATE).

126: -- Pre Conditions:
127: -- None.
128: --
129: -- In Arguments:
130: -- per_all_assignments_f%rowtype and p_action(INSERT, DELETE, UPDATE).
131: --
132: -- Post Success:
133: -- Processing continues.
134: -- If the status is CURRENT then the routine WF_LOCAL_SYNCH.propagate_user_role

Line 147: p_rec in per_all_assignments_f%rowtype,

143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145:
146: procedure per_asg_wf(
147: p_rec in per_all_assignments_f%rowtype,
148: p_action in varchar2);
149: --
150: --
151: -- ----------------------------------------------------------------------------

Line 260: p_assignment_id per_all_assignments_f.assignment_id%type default null,

256: --
257:
258: Type srch_criteria_record is RECORD
259: (p_person_id per_all_people_f.person_id%type default null,
260: p_assignment_id per_all_assignments_f.assignment_id%type default null,
261: p_effective_start_date per_all_assignments_f.effective_start_date%type default null,
262: p_effective_end_date per_all_assignments_f.effective_end_date%type default null,
263: p_position_id per_all_assignments_f.position_id%type default null);
264:

Line 261: p_effective_start_date per_all_assignments_f.effective_start_date%type default null,

257:
258: Type srch_criteria_record is RECORD
259: (p_person_id per_all_people_f.person_id%type default null,
260: p_assignment_id per_all_assignments_f.assignment_id%type default null,
261: p_effective_start_date per_all_assignments_f.effective_start_date%type default null,
262: p_effective_end_date per_all_assignments_f.effective_end_date%type default null,
263: p_position_id per_all_assignments_f.position_id%type default null);
264:
265:

Line 262: p_effective_end_date per_all_assignments_f.effective_end_date%type default null,

258: Type srch_criteria_record is RECORD
259: (p_person_id per_all_people_f.person_id%type default null,
260: p_assignment_id per_all_assignments_f.assignment_id%type default null,
261: p_effective_start_date per_all_assignments_f.effective_start_date%type default null,
262: p_effective_end_date per_all_assignments_f.effective_end_date%type default null,
263: p_position_id per_all_assignments_f.position_id%type default null);
264:
265:
266: Type srch_criteria is table of srch_criteria_record INDEX BY BINARY_INTEGER;

Line 263: p_position_id per_all_assignments_f.position_id%type default null);

259: (p_person_id per_all_people_f.person_id%type default null,
260: p_assignment_id per_all_assignments_f.assignment_id%type default null,
261: p_effective_start_date per_all_assignments_f.effective_start_date%type default null,
262: p_effective_end_date per_all_assignments_f.effective_end_date%type default null,
263: p_position_id per_all_assignments_f.position_id%type default null);
264:
265:
266: Type srch_criteria is table of srch_criteria_record INDEX BY BINARY_INTEGER;
267: