PACKAGE: APPS.PER_JP_REPORT_COMMON_PKG

Source

1 PACKAGE per_jp_report_common_pkg AUTHID CURRENT_USER
2 -- $Header: pejpcmrp.pkh 120.0.12010000.3 2009/06/08 14:32:48 spattem noship $
3 -- *************************************************************************
4 -- * Copyright (c) Oracle Corporation Japan,2009       Product Development.
5 -- * All rights reserved
6 -- *************************************************************************
7 -- *
8 -- * PROGRAM NAME
9 -- *  pejpcmrp.pkh
10 -- *
11 -- * DESCRIPTION
12 -- * This script creates the package header of per_jp_report_common_pkg.
13 -- *
14 -- * DEPENDENCIES
15 -- *   None
16 -- *
17 -- * CALLED BY
18 -- *   Concurrent Program
19 -- *
20 -- * LAST UPDATE DATE   08-JUN-2009
21 -- *   Date the program has been modified for the last time
22 -- *
23 -- * HISTORY
24 -- * =======
25 -- *
26 -- * DATE        AUTHOR(S)  VERSION           BUG NO     DESCRIPTION
27 -- * -----------+---------+-----------------+----------+----------------------------
28 -- * 26-MAY-2009 SPATTEM    120.0.12010000.1  8558615    Creation
29 -- * 08-JUN-2009 SPATTEM    120.0.12010000.2  8558615    Changes done as per review Comments
30 -- *************************************************************************
31 AS
32 --
33 TYPE gt_org_tbl IS TABLE of NUMBER INDEX BY binary_integer;
34 --
35 FUNCTION get_org_hirerachy(p_business_group_id     IN per_assignments_f.business_group_id%TYPE
36                           ,p_organization_id       IN per_assignments_f.organization_id%TYPE
37                           ,p_include_org_hierarchy IN VARCHAR2
38                           )
39 RETURN gt_org_tbl;
40 --
41 END per_jp_report_common_pkg;