APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QUAL_ALL

Line 595: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id );

591: FOR c in c_Terr LOOP
592: --
593: --Delete Territory Values
594: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
595: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id );
596:
597: --Delete Territory Qualifer records
598: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
599:

Line 598: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;

594: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
595: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id );
596:
597: --Delete Territory Qualifer records
598: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
599:
600: --Delete Territory qual type usgs
601: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;
602:

Line 2266: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu

2262:
2263: UPDATE jtf_terr_ALL jt
2264: SET jt.num_qual = (
2265: SELECT COUNT(jtq.qual_usg_id)
2266: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu
2267: WHERE jtq.terr_id = jt.terr_id
2268: AND jtq.qual_usg_id = jqu.qual_usg_id
2269: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
2270: AND jqtu.qual_type_id = p_qual_type_id

Line 3899: From JTF_TERR_QUAL_ALL

3895: QUAL_USG_ID,
3896: USE_TO_NAME_FLAG,
3897: GENERATE_FLAG,
3898: OVERLAP_ALLOWED_FLAG
3899: From JTF_TERR_QUAL_ALL
3900: Where terr_qual_id = l_terr_qual_id
3901: FOR Update NOWAIT;
3902: --Local variable declaration
3903: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_Qualifier';

Line 4962: FROM jtf_terr_qual_ALL jtq

4958: /* anonymous block to get territory id */
4959: BEGIN
4960: SELECT terr_id
4961: INTO lp_terr_id
4962: FROM jtf_terr_qual_ALL jtq
4963: WHERE jtq.terr_qual_id = p_terr_qual_id;
4964: EXCEPTION
4965: WHEN NO_DATA_FOUND THEN
4966: NULL;

Line 6011: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq

6007: AS
6008: Cursor C_QualDef1 IS
6009: -- Get the qualifier usage related information
6010: select jqu.qual_col1_datatype, jqu.display_type, jqu.convert_to_id_flag
6011: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq
6012: where jqu.qual_usg_id = jtq.qual_Usg_Id and
6013: jqu.org_id = jtq.org_id AND
6014: jtq.terr_qual_id = p_Terr_Qual_Id;
6015:

Line 7914: /* insert record IN JTF_TERR_QUAL_ALL */

7910: l_tmpl_terr_qual_rec.overlap_allowed_flag := l_dyn_qual_tbl(i).OVERLAP_ALLOWED_FLAG;
7911: l_tmpl_terr_qual_rec.qualifier_mode := l_dyn_qual_tbl(i).QUALIFIER_MODE;
7912: l_tmpl_terr_qual_rec.org_id := l_dyn_qual_tbl(i).ORG_ID;
7913:
7914: /* insert record IN JTF_TERR_QUAL_ALL */
7915: create_new_terr_qual_rec(l_new_terr_id, l_tmpl_terr_qual_rec, l_new_terr_qual_id);
7916:
7917: l_rec_index := l_dyn_qual_tbl(i).start_record + l_dyn_qual_tbl(i).current_record;
7918: