[Home] [Help]
30: PROCEDURE RUN_ASSACT(
31: -----------------------------------------------------------------------
32: p_errbuf OUT NOCOPY VARCHAR2,
33: p_retcode OUT NOCOPY VARCHAR2,
34: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
31: -----------------------------------------------------------------------
32: p_errbuf OUT NOCOPY VARCHAR2,
33: p_retcode OUT NOCOPY VARCHAR2,
34: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;
42: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
43:
44: ----------------------------------------
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;
42: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
43:
44: ----------------------------------------
45: -- Cursor
46: ----------------------------------------
50: ppa.date_earned,
51: ppa.effective_date,
52: paa.assignment_id
53: from pay_payroll_actions ppa,
54: pay_assignment_actions paa
55: where paa.assignment_action_id=p_locked_assignment_action_id
56: and paa.action_status='C'
57: and ppa.payroll_action_id=paa.payroll_action_id
58: and ppa.action_type in ('R','Q','B','I')
60: --
61: PROCEDURE get_assignment_details(
62: p_errbuf OUT NOCOPY VARCHAR2,
63: p_retcode OUT NOCOPY VARCHAR2,
64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
106: --
107: PROCEDURE insert_row(
108: p_errbuf OUT NOCOPY VARCHAR2,
109: p_retcode OUT NOCOPY VARCHAR2,
110: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
111: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
112: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
114: p_value IN pay_jp_custom_pkg.value_rec)
107: PROCEDURE insert_row(
108: p_errbuf OUT NOCOPY VARCHAR2,
109: p_retcode OUT NOCOPY VARCHAR2,
110: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
111: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
112: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
114: p_value IN pay_jp_custom_pkg.value_rec)
115: IS
108: p_errbuf OUT NOCOPY VARCHAR2,
109: p_retcode OUT NOCOPY VARCHAR2,
110: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
111: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
112: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
114: p_value IN pay_jp_custom_pkg.value_rec)
115: IS
116: l_action_status VARCHAR2(1);
299: or action_information_category='JP_PRE_TAX_2')
300: and action_context_type='AAP'
301: and not exists(
302: select NULL
303: from pay_assignment_actions paa
304: where paa.assignment_action_id=pai.action_information1);
305:
306: commit;
307:
324: --
325:
326: CURSOR csr_assact IS
327: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
328: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
329: pay_payroll_actions ppa1, pay_assignment_actions paa1,
330: pay_action_information pai
331: WHERE ppa.business_group_id = p_business_group_id
332: AND ppa.payroll_id = p_payroll_id
325:
326: CURSOR csr_assact IS
327: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
328: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
329: pay_payroll_actions ppa1, pay_assignment_actions paa1,
330: pay_action_information pai
331: WHERE ppa.business_group_id = p_business_group_id
332: AND ppa.payroll_id = p_payroll_id
333: AND ppa.date_earned BETWEEN p_from_date AND p_to_date
341: AND ppa1.action_type = 'X';
342:
343: TYPE t_assact_rec IS RECORD(
344: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
345: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE);
346:
347: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
348:
349: l_assact_tab t_assact_tab;
380: l_payroll_action_id := l_assact_tab(l_count).payroll_action_id;
381:
382: SELECT COUNT(1)
383: INTO l_count
384: FROM pay_assignment_actions
385: WHERE payroll_action_id = l_payroll_action_id;
386:
387: IF (l_count=0) THEN
388: py_rollback_pkg.rollback_payroll_action(
406: PROCEDURE RUN_SINGLE_ASSACT(
407: -----------------------------------------------------------------------
408: p_errbuf OUT NOCOPY VARCHAR2,
409: p_retcode OUT NOCOPY VARCHAR2,
410: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) IS
411:
412: l_count NUMBER;
413:
414: l_errbuf VARCHAR2(255);