DBA Data[Home] [Help]

APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_CTM_UTILITY_PVT

Line 5027: IF jtf_ctm_utility_pvt.fk_id_is_valid (

5023: IF p_terr_type_id IS NOT NULL
5024: THEN
5025: l_validate_id := p_terr_type_id;
5026:
5027: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5028: l_validate_id,
5029: 'TERR_TYPE_ID',
5030: 'JTF_TERR_TYPES'
5031: ) <>

Line 5055: IF jtf_ctm_utility_pvt.fk_id_is_valid (

5051: -- Validate the source_id
5052: l_validate_id := p_terrtypeusgs_rec.source_id;
5053:
5054: -- Make sure the foreign key source_id is valid
5055: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5056: l_validate_id,
5057: 'SOURCE_ID',
5058: 'JTF_SOURCES'
5059: ) <>

Line 5253: IF jtf_ctm_utility_pvt.fk_id_is_valid (

5249: -- TO_CHAR (l_validate_id) ||
5250: -- ')'
5251: --);
5252:
5253: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5254: l_validate_id,
5255: 'TERR_TYPE_ID',
5256: 'JTF_TERR_TYPES'
5257: ) <>