APPS.JTF_QUALIFIER_PVT dependencies on JTF_SEEDED_QUAL

Line 131: FROM JTF_SEEDED_QUAL

127: IS
128:
129: CURSOR c_chk_qual_name (l_qual_name VARCHAR2) IS
130: SELECT seeded_qual_id
131: FROM JTF_SEEDED_QUAL
132: WHERE UPPER(name) = UPPER(l_qual_name);
133:
134: l_seeded_qual_id_csr NUMBER;
135:

Line 166: JTF_SEEDED_QUAL_PKG.INSERT_ROW(

162: l_seed_qual_rec.seeded_qual_id := NULL;
163: END IF;
164:
165: -- Call INSERT table handler
166: JTF_SEEDED_QUAL_PKG.INSERT_ROW(
167: X_Rowid => l_rowid,
168: X_SEEDED_QUAL_ID => l_seed_qual_rec.seeded_qual_id,
169: X_LAST_UPDATE_DATE => l_seed_qual_rec.LAST_UPDATE_DATE,
170: X_LAST_UPDATED_BY => l_seed_qual_rec.LAST_UPDATED_BY,

Line 188: FND_MESSAGE.Set_Token ('ROW', 'JTF_SEEDED_QUAL_B');

184:
185: -- Debug message
186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
187: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:name exists');
188: FND_MESSAGE.Set_Token ('ROW', 'JTF_SEEDED_QUAL_B');
189: FND_MSG_PUB.ADD;
190: END IF;
191:
192: END IF;

Line 224: JTF_SEEDED_QUAL_PKG.UPDATE_ROW(

220: -- initialise local seeded qualifier record
221: l_seed_qual_rec := p_seed_qual_rec;
222:
223: -- Call UPDATE table handler
224: JTF_SEEDED_QUAL_PKG.UPDATE_ROW(
225: X_Rowid => l_rowid,
226: X_SEEDED_QUAL_ID => l_seed_qual_rec.seeded_qual_id,
227: X_LAST_UPDATE_DATE => l_seed_qual_rec.LAST_UPDATE_DATE,
228: X_LAST_UPDATED_BY => l_seed_qual_rec.LAST_UPDATED_BY,

Line 264: JTF_SEEDED_QUAL_PKG.DELETE_ROW ( X_SEEDED_QUAL_ID => p_seeded_qual_id);

260: -- Initialise API return status to success
261: l_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: -- Call DELETE table handler
264: JTF_SEEDED_QUAL_PKG.DELETE_ROW ( X_SEEDED_QUAL_ID => p_seeded_qual_id);
265:
266: -- save status
267: x_return_status := l_return_status;
268:

Line 625: /* check FK reference to JTF_SEEDED_QUAL */

621:
622:
623: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY ) THEN
624:
625: /* check FK reference to JTF_SEEDED_QUAL */
626: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
627: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM ) THEN
628:
629: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (

Line 632: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)

628:
629: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
630: l_qual_usgs_rec.seeded_qual_id,
631: 'SEEDED_QUAL_ID',
632: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)
633: THEN
634: l_return_status := FND_API.G_RET_STS_ERROR;
635: END IF;
636: END IF;