PACKAGE: APPS.CN_PSUM_PVT

Source

1 PACKAGE CN_psum_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvpsums.pls 115.5 2002/11/21 21:15:55 hlchen ship $ */
3 -- Start of comments
4 -- API name    : Get_psum_Data
5 -- Type        : Private.
6 -- Pre-reqs    : None.
7 -- Usage       :
8 --
9 -- Desc        :
10 --
11 --
12 --
13 -- Parameters  :
14 -- IN          :  p_api_version       NUMBER      Require
15 --                p_init_msg_list     VARCHAR2    Optional
16 --                    Default = FND_API.G_FALSE
17 --                p_commit            VARCHAR2    Optional
18 --                    Default = FND_API.G_FALSE
19 --                p_validation_level  NUMBER      Optional
20 --                    Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT         :  x_return_status     VARCHAR2(1)
22 --                x_msg_count         NUMBER
23 --                x_msg_data          VARCHAR2(2000)
24 -- IN          :  p_mgr_id            NUMBER
25 --                p_comp_group_id     NUMBER
26 --                p_org_code          VARCHAR2
27 --                p_period_id         NUMBER
28 --                p_start_row         NUMBER
29 --                p_rows              NUMBER
30 -- OUT         :  x_psum_data          psum_tbl_type
31 --                x_total_rows        NUMBER
32 -- Version     :  Current version     1.0
33 --                Initial version     1.0
34 --
35 -- Notes       :  Note text
36 --
37 -- End of comments
38 
39 type psum_rec_type IS RECORD
40   (
41      mgr_id         NUMBER,
42      mgr_name           VARCHAR2(360),
43      srp_role_id        NUMBER,
44      srp_id             number,
45      overlay_flag       varchar2(1),
46      non_std_flag       varchar2(1),
47      role_id            NUMBER,
48      role_name          VARCHAR2(60),
49      job_title_id       NUMBER,
50      job_discretion     VARCHAR2(80),
51      status             VARCHAR2(30),
52      plan_activate_status VARCHAR2(30),
53      club_eligible_flag VARCHAR2(1),
54      org_code           VARCHAR2(30),
55      start_date         date,
56      end_date           date,
57      group_id           number
58      );
59 
60 type psum_tbl_type IS table OF psum_rec_type INDEX BY binary_integer;
61 
62 
63 PROCEDURE Get_Psum_Data
64   (
65    p_api_version               IN    NUMBER,
66    p_init_msg_list             IN    VARCHAR2 := FND_API.G_FALSE,
67    p_commit                    IN    VARCHAR2 := FND_API.G_FALSE,
68    p_validation_level          IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL,
69    x_return_status             OUT NOCOPY   VARCHAR2,
70    x_msg_count                 OUT NOCOPY   NUMBER,
71    x_msg_data                  OUT NOCOPY   VARCHAR2,
72    p_mgr_id                    IN    NUMBER,
73    p_comp_group_id             IN    NUMBER,
74    p_mgr_dtl_flag              IN    VARCHAR2,
75    p_effective_date            IN    DATE,
76    x_psum_data                 OUT NOCOPY   psum_tbl_type,
77    x_total_rows                OUT NOCOPY   NUMBER
78    );
79 
80 PROCEDURE Get_MO_Psum_Data
81   (
82    p_api_version               IN    NUMBER,
83    p_init_msg_list             IN    VARCHAR2 := FND_API.G_FALSE,
84    p_commit                    IN    VARCHAR2 := FND_API.G_FALSE,
85    p_validation_level          IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL,
86    x_return_status             OUT NOCOPY   VARCHAR2,
87    x_msg_count                 OUT NOCOPY   NUMBER,
88    x_msg_data                  OUT NOCOPY   VARCHAR2,
89    p_mgr_id                    IN    NUMBER,
90    p_comp_group_id             IN    NUMBER,
91    p_mgr_dtl_flag              IN    VARCHAR2,
92    p_effective_date            IN    DATE,
93    p_is_multiorg               IN    VARCHAR2,
94    x_psum_data                 OUT NOCOPY   psum_tbl_type,
95    x_total_rows                OUT NOCOPY   NUMBER
96    );
97 END CN_psum_PVT;
98