1 Package OZF_TERR_LEVELS_PVT AUTHID CURRENT_USER AS
2 /*$Header: ozfvtlvs.pls 120.2 2005/09/23 10:50:02 yzhao noship $*/
3 /*
4 ---------------------------------------------------------------------
5 -- PROCEDURE
6 --
7 --
8 -- HISTORY
9 -- 03/07/2000 mpande Created.
10 -- 06/09/2005 kdass Bug 4415878 SQL Repository Fix - removed update_terr_levels as it is not used anywhere
11 ---------------------------------------------------------------------
12 */
13
14 /* Start of comments for Insert_SelectDefns API definition
15 API Name : OZF_TERR_LEVELS_PVT.Create_terr_hierarchy
16 Type : Private
17 Function :
18 Pre-reqs : None
19 IN : p_api_version IN NUMBER Required,
20 p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE,
21 p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE,
22 p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL,
23 ERRBUF OUT NOCOPY VARCHAR2 Required for concurrent manager
24 RETCODE OUT NOCOPY NUMBER Required for concurrent manager
25 p_start_node_id IN NUMBER Required :value comes from the topmost node of jtf territories
26 OUT NOCOPY : x_return_status OUT VARCHAR2(1) Required
27 x_msg_count OUT NOCOPY NUMBER Optional
28 x_msg_data OUT NOCOPY VARCHAR2(2000) Optional
29
30
31 Version : Current version 1.0
32 Creation of package body and the body
33
34 Notes : Version 1.0
35 Create_terr_hierarchy API :
36 This API accepts IN parameters of a table of record type
37 and inserts records into AMS_TERR_LEVELS_ALL table.
38 */
39
40 -- This is wrapper for the concurrent process to be called
41 PROCEDURE Create_Terr_Hierarchy
42 (ERRBUF OUT NOCOPY VARCHAR2
43 ,RETCODE OUT NOCOPY NUMBER
44 ,p_start_node_id IN NUMBER
45 );
46
47 -- This the package to import the territory APIS and create
48 PROCEDURE Insert_Terr_Levels
49 (p_api_version IN NUMBER := 1
50 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
51 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
52 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,p_start_node_id IN NUMBER
57 );
58
59 -- This the package to import all territories defined under Trade Management
60 PROCEDURE bulk_insert_terr_levels (
61 p_api_version IN NUMBER
62 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
63 ,p_commit IN VARCHAR2 := fnd_api.g_false
64 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 );
69
70
71 -- This the package to delete the a definite territory sturucture from our schema
72 PROCEDURE Delete_Terr_Levels
73 (p_api_version IN NUMBER
74 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
75 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
76 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,p_hierarchy_id IN NUMBER
81 );
82
83 END;