APPS.JTF_TERR_MERGE_PUB dependencies on JTF_TERR_VALUES_ALL

Line 49: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR

45: SAVEPOINT TERRITORY_PARTY_MERGE_PUB;
46:
47: x_return_status := fnd_api.g_ret_sts_success;
48:
49: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR
50: p_parent_entity_name <> 'HZ_PARTIES' ) THEN
51:
52: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
53: fnd_message.set_token('P_ENTITY',p_entity_name);

Line 63: UPDATE jtf_terr_values_all jtv

59: END IF;
60:
61: IF (p_from_FK_id <> p_to_FK_id) THEN
62:
63: UPDATE jtf_terr_values_all jtv
64: SET jtv.low_value_char_id = p_to_fk_id
65: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
66: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
67: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login

Line 133: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR

129:
130: x_return_status := fnd_api.g_ret_sts_success;
131:
132:
133: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR
134: p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
135:
136: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
137: fnd_message.set_token('P_ENTITY', p_entity_name);

Line 147: UPDATE jtf_terr_values_all jtv

143: END IF;
144:
145: IF (p_from_FK_id <> p_to_FK_id) THEN
146:
147: UPDATE jtf_terr_values_all jtv
148: SET jtv.low_value_char_id = p_to_fk_id
149: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
150: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
151: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login