PACKAGE: APPS.CN_TSR_PVT

Source

1 PACKAGE CN_TSR_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvtsrs.pls 115.5 2002/11/21 21:19:59 hlchen ship $ */
3 
4 TYPE tsr_rec_type IS RECORD
5   (
6    tsr_emp_no            VARCHAR2(30)           := NULL,
7    tsr_name              VARCHAR2(80)           := NULL,
8    mgr_emp_no            VARCHAR2(30)           := NULL,
9    mgr_name              VARCHAR2(80)           := NULL,
10    tsr_srp_id            NUMBER := NULL,
11    tsr_mgr_id            NUMBER := NULL
12    );
13 
14 TYPE tsr_tbl_type IS
15    TABLE OF tsr_rec_type INDEX BY BINARY_INTEGER ;
16 
17 -- Global variable that represent missing values.
18 
19    G_MISS_TSR_REC   tsr_rec_type;
20    G_MISS_TSR_TBL   tsr_tbl_type;
21 
22 
23 -- Start of comments
24 -- API name    : Get_Tsr_Data
25 -- Type        : Private.
26 -- Pre-reqs    : None.
27 -- Usage       :
28 --
29 -- Desc        :
30 --
31 --
32 --
33 -- Parameters  :
34 -- IN          :  p_api_version       NUMBER      Require
35 --                p_init_msg_list     VARCHAR2    Optional
36 --                    Default = FND_API.G_FALSE
37 --                p_commit            VARCHAR2    Optional
38 --                    Default = FND_API.G_FALSE
39 --                p_validation_level  NUMBER      Optional
40 --                    Default = FND_API.G_VALID_LEVEL_FULL
41 -- OUT         :  x_return_status     VARCHAR2(1)
42 --                x_msg_count         NUMBER
43 --                x_msg_data          VARCHAR2(2000)
44 -- IN          :  p_mgr_id            NUMBER
45 --                p_comp_group_id     NUMBER
46 --                p_org_code          VARCHAR2
47 --                p_period_id         NUMBER
48 --                p_start_row         NUMBER
49 --                p_rows              NUMBER
50 -- OUT         :  x_tsr_data          tsr_tbl_type
51 --                x_total_rows        NUMBER
52 -- Version     :  Current version     1.0
53 --                Initial version     1.0
54 --
55 -- Notes       :  Note text
56 --
57 -- End of comments
58 
59 
60 PROCEDURE Get_Tsr_Data
61   (
62    p_api_version               IN    NUMBER,
63    p_init_msg_list             IN    VARCHAR2 := FND_API.G_FALSE,
64    p_commit                    IN    VARCHAR2 := FND_API.G_FALSE,
65    p_validation_level          IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL,
66    x_return_status             OUT NOCOPY   VARCHAR2,
67    x_msg_count                 OUT NOCOPY   NUMBER,
68    x_msg_data                  OUT NOCOPY   VARCHAR2,
69    p_mgr_id                    IN    NUMBER,
70    p_comp_group_id             IN    NUMBER,
71    p_org_code                  IN    VARCHAR2,
72    p_period_id                 IN    DATE,
73    p_start_row                 IN    NUMBER,
74    p_rows                      IN    NUMBER,
75    x_tsr_data                  OUT NOCOPY   tsr_tbl_type,
76    x_total_rows                OUT NOCOPY   NUMBER,
77    download                     IN      VARCHAR2 := 'N'
78    );
79 
80 END CN_TSR_PVT;
81