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
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
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
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
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
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
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
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
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: );
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
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
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