[Home] [Help]
PACKAGE: APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG
Source
1 package JTY_WEBADI_OTH_TERR_DWNL_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfowdps.pls 120.16 2011/04/26 05:34:40 sseshaiy ship $ */
3
4 -- ===========================================================================+
5
6 -- | Copyright (c) 1999 Oracle Corporation |
7 -- | Redwood Shores, California, USA |
8 -- | All rights reserved. |
9 -- +===========================================================================
10 -- Start of Comments
11 -- ---------------------------------------------------
12 -- PACKAGE NAME: JTY_OTH_WEBADI_PKG
13 -- ---------------------------------------------------
14 --
15 -- PURPOSE
16 --
17 -- WebAdi Other Territory Upload package.
18 --
19 --
20 -- Procedures:
21 -- (see below for specification)
22 --
23 -- NOTES
24 -- This package is publicly available for use
25 --
26 -- HISTORY
27 -- 08/18/2005 mhtran created
28
29 -- ===============================================================
30 -- End of Comments
31
35 TYPE num_winners_tbl_type is table of JTF_TERR_ALL.NUM_WINNERS%TYPE;
32 TYPE terr_id_tbl_type is table of JTF_TERR_ALL.TERR_ID%TYPE;
33 TYPE terr_name_tbl_type is table of JTF_TERR_ALL.NAME%TYPE;
34 TYPE rank_tbl_type is table of JTF_TERR_ALL.RANK%TYPE;
36 TYPE date_tbl_type is table of JTF_TERR_ALL.START_DATE_ACTIVE%TYPE;
37 TYPE terr_type_name_tbl_type is table of jtf_terr_types_all.name%TYPE;
38 TYPE terr_type_id_tbl_type is table of jtf_terr_types_all.terr_type_id%TYPE;
39 TYPE org_name_tbl_type is table of HR_OPERATING_UNITS.NAME%TYPE;
40 TYPE ATTRIBUTE_CATEGORY_TBL_type is table of JTF_TERR_ALL.ATTRIBUTE_CATEGORY%TYPE;
41 TYPE ATTRIBUTE_TBL_type is table of JTF_TERR_ALL.ATTRIBUTE1%TYPE;
42
43 TYPE terr_rec_type IS RECORD
44 ( terr_id terr_id_tbl_type,
45 terr_name terr_name_tbl_type,
46 rank rank_tbl_type,
47 num_winners num_winners_tbl_type,
48 start_date date_tbl_type,
49 end_date date_tbl_type,
50 terr_type_name terr_type_name_tbl_type,
51 terr_type_id terr_type_id_tbl_type,
52 parent_terr_id terr_id_tbl_type,
53 org_name org_name_tbl_type,
54 hierarchy terr_name_tbl_type,
55 ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY_tbl_type,
56 ATTRIBUTE1 ATTRIBUTE_tbl_type,
57 ATTRIBUTE2 ATTRIBUTE_tbl_type,
58 ATTRIBUTE3 ATTRIBUTE_tbl_type,
59 ATTRIBUTE4 ATTRIBUTE_tbl_type,
60 ATTRIBUTE5 ATTRIBUTE_tbl_type,
61 ATTRIBUTE6 ATTRIBUTE_tbl_type,
62 ATTRIBUTE7 ATTRIBUTE_tbl_type,
63 ATTRIBUTE8 ATTRIBUTE_tbl_type,
64 ATTRIBUTE9 ATTRIBUTE_tbl_type,
65 ATTRIBUTE10 ATTRIBUTE_tbl_type,
66 ATTRIBUTE11 ATTRIBUTE_tbl_type,
67 ATTRIBUTE12 ATTRIBUTE_tbl_type,
68 ATTRIBUTE13 ATTRIBUTE_tbl_type,
69 ATTRIBUTE14 ATTRIBUTE_tbl_type,
70 ATTRIBUTE15 ATTRIBUTE_tbl_type
71 );
72
73 PROCEDURE populate_webadi_interface( p_usage_id IN NUMBER
74 , p_user_id IN NUMBER
75 , p_terr_id IN NUMBER
76 , p_org_id IN NUMBER
77 , p_type_id in NUMBER
78 , p_mode IN VARCHAR2 DEFAULT 'NODE'
79 , p_view IN VARCHAR2 DEFAULT 'TERR'
80 , p_geo_type IN NUMBER
81 , p_active IN DATE
82 , p_terr_id_array IN VARCHAR2 DEFAULT NULL
83 , x_seq OUT NOCOPY VARCHAR2
84 , x_retcode OUT NOCOPY VARCHAR2
85 , x_errbuf OUT NOCOPY VARCHAR2 );
86 FUNCTION get_resource_name(p_resource_type VARCHAR2, p_resource_id NUMBER, p_group_id NUMBER, p_role_id VARCHAR2, p_role VARCHAR2) RETURN VARCHAR;
87 FUNCTION get_group_name(p_resource_type VARCHAR, p_group_id NUMBER, p_resource_id NUMBER) RETURN VARCHAR;
88 FUNCTION get_role_name(p_resource_type VARCHAR, p_role VARCHAR2) RETURN VARCHAR;
89 FUNCTION get_email(p_resource_type VARCHAR, p_resource_id NUMBER) RETURN VARCHAR;
90
91 END JTY_WEBADI_OTH_TERR_DWNL_PKG;