PACKAGE: APPS.CN_COMP_GRP_HIER_PUB

Source

1 PACKAGE cn_comp_grp_hier_pub AUTHID CURRENT_USER AS
2 -- $Header: cnpcghrs.pls 115.3 2002/01/28 20:02:22 pkm ship      $
3 -- cg_salesrep_id will keep comp_group_id as well as salesrep_id
4 TYPE comp_group_rec IS RECORD(
5 	level				VARCHAR2(10),
6 	cg_salesrep_name		VARCHAR2(80),
7      	cg_salesrep_id			NUMBER,
8 	parent_comp_group_id		NUMBER,
9 	grp_or_name_flag		VARCHAR2(10),
10 	role_name			VARCHAR2(80),
11 	role_id				NUMBER,
12 	start_date_active		DATE,
13 	end_date_active			DATE,
14 	start_cg_id			NUMBER,
15 	end_cg_id			NUMBER,
16 	image				VARCHAR2(10),
17 	expand				VARCHAR2(10));
18 
19 TYPE comp_group_tbl IS TABLE OF comp_group_rec
20 INDEX BY BINARY_INTEGER;
21 
22 PROCEDURE get_comp_group_hier(
23      p_api_version              IN   NUMBER,
24      p_init_msg_list            IN   VARCHAR2 := FND_API.G_FALSE,
25      p_validation_level         IN   VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
26      p_salesrep_id              IN   NUMBER ,
27      p_comp_group_id            IN   NUMBER,
28      p_focus_cg_id              IN   NUMBER,
29      p_expand                   IN   CHAR,
30      p_date                     IN   DATE,
31      x_mgr_tbl                  OUT  comp_group_tbl,
32      l_mgr_count                OUT  NUMBER,
33      x_period_year              OUT  VARCHAR2,
34      x_return_status            OUT  VARCHAR2,
35      x_msg_count                OUT  NUMBER,
36      x_msg_data                 OUT  VARCHAR2,
37      x_loading_status           OUT  VARCHAR2);
38 
39 END cn_comp_grp_hier_pub;