APPS.OZF_TERR_LEVELS_PVT dependencies on OZF_TERR_LEVELS_PVT

Line 1: PACKAGE BODY ozf_terr_levels_pvt AS

1: PACKAGE BODY ozf_terr_levels_pvt AS
2: /*$Header: ozfvtlvb.pls 120.2.12010000.2 2008/08/08 09:31:51 ateotia ship $*/
3: /*---------------------------------------------------------------------
4: -- PROCEDURE
5: --

Line 17: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_TERR_LEVELS_PVT';

13: -- 01-Aug-2008 ateotia Bug # 5723438 fixed.
14: -- FP:11510-R12 5533277 - TERRITORY DETAIL'S END DATE IS NOT WORKING
15: ---------------------------------------------------------------------
16: */
17: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_TERR_LEVELS_PVT';
18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
19: g_bulk_limit CONSTANT NUMBER := 1000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
20:
21:

Line 74: ozf_terr_levels_pvt.delete_terr_levels (

70: -- if no hierarchy found then insert
71: -- 07/13/2001 mpande if found then delete and recreate it .
72: IF c_hier_exists%FOUND THEN
73: CLOSE c_hier_exists;
74: ozf_terr_levels_pvt.delete_terr_levels (
75: p_api_version => 1.0
76: ,p_init_msg_list => fnd_api.g_true
77: ,p_commit => fnd_api.g_false
78: ,p_validation_level => fnd_api.g_valid_level_full

Line 111: ozf_terr_levels_pvt.insert_terr_levels (

107: UPDATE ozf_terr_levels_all
108: SET active_flag = 'N';
109:
110: ozf_utility_pvt.write_conc_log ('Territory Insertion Call');
111: ozf_terr_levels_pvt.insert_terr_levels (
112: p_api_version => 1.0
113: ,p_init_msg_list => fnd_api.g_true
114: ,p_commit => fnd_api.g_false
115: ,p_validation_level => fnd_api.g_valid_level_full

Line 132: ozf_terr_levels_pvt.bulk_insert_terr_levels (

128:
129: ozf_utility_pvt.write_conc_log ('Bulk Territories Insertion Call');
130: -- Bug # 5723438 fixed by ateotia (-)
131:
132: ozf_terr_levels_pvt.bulk_insert_terr_levels (
133: p_api_version => 1.0
134: ,p_init_msg_list => fnd_api.g_true
135: ,p_commit => fnd_api.g_false
136: ,p_validation_level => fnd_api.g_valid_level_full

Line 568: ozf_terr_levels_pvt.insert_terr_levels (

564: OPEN c_get_all_root_nodes;
565: LOOP
566: FETCH c_get_all_root_nodes BULK COLLECT INTO l_terrIdTbl LIMIT g_bulk_limit;
567: FOR i IN NVL(l_terrIdTbl.FIRST, 1) .. NVL(l_terrIdTbl.LAST, 0) LOOP
568: ozf_terr_levels_pvt.insert_terr_levels (
569: p_api_version => 1.0
570: ,p_init_msg_list => fnd_api.g_true
571: ,p_commit => fnd_api.g_false
572: ,p_validation_level => fnd_api.g_valid_level_full