APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_JP_EMPDET_REPORT_PKG

Line 1: PACKAGE BODY per_jp_empdet_report_pkg

1: PACKAGE BODY per_jp_empdet_report_pkg
2: -- $Header: pejperpt.pkb 120.0.12010000.25 2009/09/29 13:38:10 mpothala noship $
3: -- *************************************************************************
4: -- * Copyright (c) Oracle Corporation Japan,2009 Product Development.
5: -- * All rights reserved

Line 12: -- * This script creates the package body of per_jp_empdet_report_pkg

8: -- * PROGRAM NAME
9: -- * pejperpt.pkb
10: -- *
11: -- * DESCRIPTION
12: -- * This script creates the package body of per_jp_empdet_report_pkg
13: -- *
14: -- * DEPENDENCIES
15: -- * None
16: -- *

Line 59: gc_pkg_name VARCHAR2(30) := 'per_jp_empdet_report_pkg.';

55: g_write_xml CLOB;
56: g_xfdf_string CLOB;
57: gc_eol VARCHAR2(5) := fnd_global.local_chr(10);
58: gc_proc_name VARCHAR2(240);
59: gc_pkg_name VARCHAR2(30) := 'per_jp_empdet_report_pkg.';
60: gb_debug BOOLEAN;
61: gn_bg_id NUMBER;
62: gn_dummy NUMBER := -99 ;
63: gn_all_exclusions_flag NUMBER;

Line 270: RETURN per_jp_empdet_report_pkg.gt_job_tbl

266: --
267: -- CALLED BY
268: -- archive_code
269: --************************************************************************
270: RETURN per_jp_empdet_report_pkg.gt_job_tbl
271: AS
272: CURSOR lcu_job_history(p_mag_asg_action_id NUMBER)
273: IS
274: SELECT PJEDPJV.assignment_id

Line 285: lt_job_id per_jp_empdet_report_pkg.gt_job_tbl;

281: WHERE PJEDPJV.assignment_action_id = p_mag_asg_action_id
282: AND (PJEDPJV.employee_category IS NULL OR PJEDPJV.employee_category <> 'REHIRE')
283: ORDER BY PJEDPJV.end_date;
284: --
285: lt_job_id per_jp_empdet_report_pkg.gt_job_tbl;
286: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl;
287: ln_index NUMBER := 0;
288: ld_start_date VARCHAR2(20); -- Fix for the Bug 8843783
289: ln_count NUMBER:=0;

Line 286: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl;

282: AND (PJEDPJV.employee_category IS NULL OR PJEDPJV.employee_category <> 'REHIRE')
283: ORDER BY PJEDPJV.end_date;
284: --
285: lt_job_id per_jp_empdet_report_pkg.gt_job_tbl;
286: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl;
287: ln_index NUMBER := 0;
288: ld_start_date VARCHAR2(20); -- Fix for the Bug 8843783
289: ln_count NUMBER:=0;
290:

Line 1509: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783

1505: ,end_date per_assignments_f.effective_end_date%TYPE
1506: );--8740684
1507: TYPE gt_asmnt_tbl IS TABLE OF asmt_hist_type INDEX BY binary_integer; -- 8740684
1508: lt_asmnt_tbl gt_asmnt_tbl;--8740684
1509: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783
1510: lt_dis_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783
1511: --
1512: BEGIN
1513: --

Line 1510: lt_dis_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783

1506: );--8740684
1507: TYPE gt_asmnt_tbl IS TABLE OF asmt_hist_type INDEX BY binary_integer; -- 8740684
1508: lt_asmnt_tbl gt_asmnt_tbl;--8740684
1509: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783
1510: lt_dis_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783
1511: --
1512: BEGIN
1513: --
1514: vXMLTable.DELETE;

Line 2191: END per_jp_empdet_report_pkg;

2187: BEGIN
2188: pay_archive.remove_report_actions(p_payroll_action_id);
2189: END deinitialise;
2190:
2191: END per_jp_empdet_report_pkg;