DBA Data[Home] [Help]

APPS.PAY_JP_UITE_ARCH_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 94: FUNCTION get_life_ins_org_id(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

90: );
91: --
92: TYPE gt_insert_wage_info IS TABLE OF gt_wage_info INDEX BY BINARY_INTEGER;
93: --
94: FUNCTION get_life_ins_org_id(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
95: ,p_effective_date IN DATE)
96: --************************************************************************
97: -- FUNCTION
98: -- get_life_ins_org_id

Line 153: FUNCTION get_ei_type(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

149: RAISE;
150: RETURN NULL;
151: END get_life_ins_org_id;
152: --
153: FUNCTION get_ei_type(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
154: ,p_effective_date IN DATE)
155: --************************************************************************
156: -- FUNCTION
157: -- get_ei_type

Line 212: FUNCTION get_term_rpt_flag(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

208: RAISE;
209: RETURN NULL;
210: END get_ei_type;
211: --
212: FUNCTION get_term_rpt_flag(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
213: ,p_effective_date IN DATE)
214: --************************************************************************
215: -- FUNCTION
216: -- get_ei_type

Line 271: FUNCTION get_ei_qualify_date(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

267: RAISE;
268: RETURN NULL;
269: END get_term_rpt_flag;
270: --
271: FUNCTION get_ei_qualify_date(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,p_effective_date IN DATE)
273: --************************************************************************
274: -- FUNCTION
275: -- get_ei_type

Line 330: FUNCTION get_ei_dis_qual_date(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

326: RAISE;
327: RETURN NULL;
328: END get_ei_qualify_date;
329: --
330: FUNCTION get_ei_dis_qual_date(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
331: ,p_effective_date IN DATE)
332: --************************************************************************
333: -- FUNCTION
334: -- get_ei_type

Line 390: FUNCTION get_ui_num(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

386: RAISE;
387: RETURN NULL;
388: END get_ei_dis_qual_date;
389: --
390: FUNCTION get_ui_num(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
391: ,p_effective_date IN DATE)
392: --************************************************************************
393: -- FUNCTION
394: -- get_ui_num

Line 687: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

683: --
684:
685: PROCEDURE proc_insert_row( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
686: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
687: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
688: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
689: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
690: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
691: ,p_hire_date IN per_periods_of_service.date_start%TYPE

Line 879: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

875: END proc_insert_row;
876: --
877: PROCEDURE proc_sal_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
878: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
879: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
880: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
883: ,p_hire_date IN per_periods_of_service.date_start%TYPE

Line 1735: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1731: END proc_sal_arch;
1732: --
1733:
1734: PROCEDURE proc_spb_arch(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1735: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1736: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1737: ,p_period_start_date IN per_time_periods.start_date%TYPE
1738: ,p_period_end_date IN per_time_periods.end_date%TYPE
1739: ,p_payroll_id IN NUMBER)

Line 1889: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1885: END proc_spb_arch;
1886: --
1887: PROCEDURE proc_term_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1888: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
1889: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1890: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1891: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
1892: )
1893: --***************************************************************************

Line 2699: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

2695: --
2696: -- Local Variables
2697: ln_action_info_id pay_action_information.action_information_id%TYPE;
2698: ln_obj_version_num pay_action_information.object_version_number%TYPE;
2699: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
2700: lc_procedure VARCHAR2(200);
2701: ld_ins_start_date per_time_periods.start_date%TYPE;
2702: --
2703: BEGIN