APPS.JTF_QUALIFIER_PVT dependencies on JTF_QUAL_USGS

Line 26: -- JTF_QUAL_USGS table

22: -- HISTORY
23: -- 07/15/99 JDOCHERT Created
24: -- 03/28/00 VNEDUNGA Adding new columns for eliminating
25: -- dependency to AS_INTERESTS in
26: -- JTF_QUAL_USGS table
27: --
28: -- End of Comments
29: --
30:

Line 586: FROM JTF_QUAL_USGS

582:
583: -- cursor to check that Unique Key constraint not violated
584: CURSOR c_chk_uk_violation (p_seeded_qual_id NUMBER, p_qual_type_usg_id NUMBER) IS
585: SELECT 'X'
586: FROM JTF_QUAL_USGS
587: WHERE seeded_qual_id = p_seeded_qual_id
588: AND qual_type_usg_id = p_qual_type_usg_id;
589:
590: l_return_csr VARCHAR2(1);

Line 679: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');

675:
676: /* Debug message */
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
678: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');
679: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');
680: FND_MSG_PUB.ADD;
681: END IF;
682:
683: END IF; /* c_chk_uk_violation%FOUND */

Line 794: JTF_QUAL_USGS_PKG.INSERT_ROW(

790:
791: l_qual_usgs_rec.qual_usg_id := NULL;
792: END IF;
793: -- Call INSERT table handler
794: JTF_QUAL_USGS_PKG.INSERT_ROW(
795: X_Rowid => l_rowid,
796: X_QUAL_USG_ID => l_qual_usgs_rec.QUAL_USG_ID,
797: X_LAST_UPDATE_DATE => l_qual_usgs_rec.LAST_UPDATE_DATE,
798: X_LAST_UPDATED_BY => l_qual_usgs_rec.LAST_UPDATED_BY,

Line 886: JTF_QUAL_USGS_PKG.UPDATE_ROW(

882: -- (vinoo and jdochert)
883:
884: -- Call UPDATE table handler
885:
886: JTF_QUAL_USGS_PKG.UPDATE_ROW(
887: X_Rowid => l_rowid,
888: X_QUAL_USG_ID => l_qual_usgs_rec.QUAL_USG_ID,
889: X_LAST_UPDATE_DATE => l_qual_usgs_rec.LAST_UPDATE_DATE,
890: X_LAST_UPDATED_BY => l_qual_usgs_rec.LAST_UPDATED_BY,

Line 960: FROM JTF_QUAL_USGS

956:
957: /* seeded qualifier record does not have more than one child */
958: CURSOR c_chk_sq_child ( p_seeded_qual_id NUMBER, p_qual_usg_id NUMBER ) IS
959: SELECT qual_usg_id
960: FROM JTF_QUAL_USGS
961: WHERE seeded_qual_id = p_seeded_qual_id
962: AND qual_usg_id <> p_qual_usg_id;
963:
964: /* cursor to check if qualifier usage record is seeded */

Line 967: FROM JTF_QUAL_USGS

963:
964: /* cursor to check if qualifier usage record is seeded */
965: CURSOR c_chk_seeded_flag ( p_qual_usg_id NUMBER ) IS
966: SELECT qual_usg_id
967: FROM JTF_QUAL_USGS
968: WHERE seeded_flag = 'Y'
969: AND qual_usg_id = p_qual_usg_id;
970:
971: /* cursor to check if qualifier usage is used in a territory definition */

Line 1089: JTF_QUAL_USGS_PKG.DELETE_ROW ( X_QUAL_USG_ID => p_qual_usg_id);

1085: -- Initialise API return status to success
1086: l_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088: -- Call UPDATE table handler
1089: JTF_QUAL_USGS_PKG.DELETE_ROW ( X_QUAL_USG_ID => p_qual_usg_id);
1090:
1091: -- save status
1092: x_return_status := l_return_status;
1093: