DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_JP_WIC_PKG

Line 580: prev_jobs pay_jp_wic_pkg.t_prev_jobs,

576: widow varchar2(60),
577: special_widow varchar2(60),
578: widower varchar2(60),
579: working_student varchar2(60),
580: prev_jobs pay_jp_wic_pkg.t_prev_jobs,
581: null_dummy number);
582: --
583: type t_yea_wic_tbl is table of t_yea_wic_rec index by binary_integer;
584: --

Line 1734: l_certificate_info pay_jp_wic_pkg.t_certificate_info;

1730: is
1731: --
1732: l_proc varchar2(80) := c_package||'set_yea_wic_tbl';
1733: --
1734: l_certificate_info pay_jp_wic_pkg.t_certificate_info;
1735: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;
1736: l_submission_required_flag varchar2(1);
1737: l_withholding_tax_info pay_jp_wic_pkg.t_tax_info;
1738: --

Line 1735: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;

1731: --
1732: l_proc varchar2(80) := c_package||'set_yea_wic_tbl';
1733: --
1734: l_certificate_info pay_jp_wic_pkg.t_certificate_info;
1735: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;
1736: l_submission_required_flag varchar2(1);
1737: l_withholding_tax_info pay_jp_wic_pkg.t_tax_info;
1738: --
1739: l_yea_wic_ind_tbl_cnt number := 0;

Line 1737: l_withholding_tax_info pay_jp_wic_pkg.t_tax_info;

1733: --
1734: l_certificate_info pay_jp_wic_pkg.t_certificate_info;
1735: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;
1736: l_submission_required_flag varchar2(1);
1737: l_withholding_tax_info pay_jp_wic_pkg.t_tax_info;
1738: --
1739: l_yea_wic_ind_tbl_cnt number := 0;
1740: l_yea_wic_add_ind_tbl_cnt number := 0;
1741: --

Line 2055: pay_jp_wic_pkg.get_prev_jobs(

2051: --
2052: l_prev_jobs.delete;
2053: --l_prev_jobs := null;
2054: --
2055: pay_jp_wic_pkg.get_prev_jobs(
2056: p_assignment_id => l_csr_yea_wic_arch.assignment_id,
2057: p_action_sequence => l_csr_yea_wic_arch.action_sequence,
2058: p_business_group_id => g_business_group_id,
2059: p_effective_date => l_csr_yea_wic_arch.effective_date,

Line 2164: pay_jp_wic_pkg.get_certificate_info(

2160: --l_certificate_info.delete;
2161: l_prev_jobs.delete;
2162: l_submission_required_flag := null;
2163: --
2164: pay_jp_wic_pkg.get_certificate_info(
2165: p_assignment_action_id => l_csr_yea_wic_proc_no_arch.assignment_action_id,
2166: p_assignment_id => l_csr_yea_wic_proc_no_arch.assignment_id,
2167: p_action_sequence => l_csr_yea_wic_proc_no_arch.action_sequence,
2168: p_business_group_id => g_business_group_id,

Line 2274: pay_jp_wic_pkg.get_certificate_info(

2270: --l_certificate_info.delete;
2271: l_prev_jobs.delete;
2272: l_submission_required_flag := null;
2273: --
2274: pay_jp_wic_pkg.get_certificate_info(
2275: p_assignment_action_id => l_csr_yea_wic_proc.assignment_action_id,
2276: p_assignment_id => l_csr_yea_wic_proc.assignment_id,
2277: p_action_sequence => l_csr_yea_wic_proc.action_sequence,
2278: p_business_group_id => g_business_group_id,

Line 2725: p_prev_jobs in pay_jp_wic_pkg.t_prev_jobs)

2721: procedure set_data_pjob_tbl(
2722: p_assignment_action_id in number,
2723: p_assignment_id in number,
2724: p_employee_number in varchar2,
2725: p_prev_jobs in pay_jp_wic_pkg.t_prev_jobs)
2726: is
2727: --
2728: l_proc varchar2(80) := c_package||'set_data_pjob_tbl';
2729: --

Line 2734: p_pjob_info in pay_jp_wic_pkg.t_prev_job_info)

2730: l_pjob_cnt number;
2731: --
2732: procedure set_data_pjob_rec(
2733: p_rec_ind in number,
2734: p_pjob_info in pay_jp_wic_pkg.t_prev_job_info)
2735: is
2736: begin
2737: --
2738: g_data_pjob_tbl(p_rec_ind).employer_name := p_pjob_info.salary_payer_name_kanji;

Line 7346: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;

7342: l_assignment_id number;
7343: --
7344: l_data_tbl t_data_tbl;
7345: --
7346: l_prev_jobs pay_jp_wic_pkg.t_prev_jobs;
7347: --
7348: l_data_tbl_cnt number := 0;
7349: l_bon_tbl_cnt number := 0;
7350: l_yea_tbl_cnt number := 0;

Line 8571: pay_jp_wic_pkg.get_prev_jobs(

8567: and g_detail_debug = 'Y' then
8568: l_archini_step := 19;
8569: end if;
8570: --
8571: pay_jp_wic_pkg.get_prev_jobs(
8572: p_assignment_id => l_assignment_id,
8573: p_action_sequence => l_data_tbl(l_data_tbl_cnt).assact_action_sequence,
8574: p_business_group_id => g_business_group_id,
8575: p_effective_date => l_data_tbl(l_data_tbl_cnt).assact_effective_date,

Line 9323: pay_jp_wic_pkg.get_prev_jobs(

9319: and g_detail_debug = 'Y' then
9320: l_archini_step := 66;
9321: end if;
9322: --
9323: pay_jp_wic_pkg.get_prev_jobs(
9324: p_assignment_id => l_assignment_id,
9325: p_action_sequence => l_data_tbl(l_data_tbl_cnt).assact_action_sequence,
9326: p_business_group_id => g_business_group_id,
9327: p_effective_date => l_data_tbl(l_data_tbl_cnt).assact_effective_date,

Line 9730: pay_jp_wic_pkg.get_prev_jobs(

9726: and g_detail_debug = 'Y' then
9727: l_archini_step := 101;
9728: end if;
9729: --
9730: pay_jp_wic_pkg.get_prev_jobs(
9731: p_assignment_id => l_assignment_id,
9732: p_action_sequence => l_data_tbl(l_data_tbl_cnt).assact_action_sequence,
9733: p_business_group_id => g_business_group_id,
9734: p_effective_date => l_data_tbl(l_data_tbl_cnt).assact_effective_date,

Line 10600: pay_jp_wic_pkg.get_prev_jobs(

10596: and g_detail_debug = 'Y' then
10597: l_archini_step := 157;
10598: end if;
10599: --
10600: pay_jp_wic_pkg.get_prev_jobs(
10601: p_assignment_id => l_assignment_id,
10602: p_action_sequence => l_data_tbl(l_data_tbl_cnt).assact_action_sequence,
10603: p_business_group_id => g_business_group_id,
10604: p_effective_date => l_data_tbl(l_data_tbl_cnt).assact_effective_date,

Line 10998: pay_jp_wic_pkg.get_prev_jobs(

10994: and g_detail_debug = 'Y' then
10995: l_archini_step := 193;
10996: end if;
10997: --
10998: pay_jp_wic_pkg.get_prev_jobs(
10999: p_assignment_id => l_assignment_id,
11000: p_action_sequence => l_data_tbl(l_data_tbl_cnt).assact_action_sequence,
11001: p_business_group_id => g_business_group_id,
11002: p_effective_date => l_data_tbl(l_data_tbl_cnt).assact_effective_date,

Line 11882: pay_jp_wic_pkg.get_prev_jobs(

11878: and g_detail_debug = 'Y' then
11879: l_archini_step := 247;
11880: end if;
11881: --
11882: pay_jp_wic_pkg.get_prev_jobs(
11883: p_assignment_id => l_assignment_id,
11884: p_action_sequence => l_data_tbl(l_data_tbl_cnt).assact_action_sequence,
11885: p_business_group_id => g_business_group_id,
11886: p_effective_date => l_data_tbl(l_data_tbl_cnt).assact_effective_date,