APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QUAL_ALL

Line 539: FROM JTF_TERR_QUAL_ALL

535: start with terr_id = v_Terr_Id;
536:
537: CURSOR C_TERR_QUAL_IDS ( p_Terr_Id IN NUMBER) IS
538: SELECT TERR_QUAL_ID
539: FROM JTF_TERR_QUAL_ALL
540: WHERE TERR_ID = p_Terr_Id;
541:
542:
543:

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

602: CLOSE C_TERR_QUAL_IDS;
603: END;
604:
605: --Delete Territory Qualifer records
606: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
607:
608: --Delete Territory qual type usgs
609: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;
610:

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

2363:
2364: UPDATE jtf_terr_ALL jt
2365: SET jt.num_qual = (
2366: SELECT COUNT(jtq.qual_usg_id)
2367: FROM jtf_terr_qual_ALL jtq, jtf_qual_usgs_ALL jqu, jtf_qual_type_usgs_ALL jqtu
2368: WHERE jtq.terr_id = jt.terr_id
2369: AND jtq.qual_usg_id = jqu.qual_usg_id
2370: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
2371: AND jqtu.qual_type_id = p_qual_type_id

Line 4274: From JTF_TERR_QUAL_ALL

4270: QUAL_USG_ID,
4271: USE_TO_NAME_FLAG,
4272: GENERATE_FLAG,
4273: OVERLAP_ALLOWED_FLAG
4274: From JTF_TERR_QUAL_ALL
4275: Where terr_qual_id = l_terr_qual_id
4276: FOR Update NOWAIT;
4277: --Local variable declaration
4278: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_Qualifier';

Line 5376: FROM jtf_terr_qual_ALL jtq

5372: /* anonymous block to get territory id */
5373: BEGIN
5374: SELECT terr_id
5375: INTO lp_terr_id
5376: FROM jtf_terr_qual_ALL jtq
5377: WHERE jtq.terr_qual_id = p_terr_qual_id;
5378: EXCEPTION
5379: WHEN NO_DATA_FOUND THEN
5380: NULL;

Line 5682: FROM JTF_TERR_QUAL_ALL

5678: IF ( p_Terr_Id IS NOT NULL ) AND
5679: ( P_Terr_Qual_Rec.Qual_Usg_Id IS NOT NULL ) Then
5680:
5681: SELECT COUNT(*) INTO l_qual_count
5682: FROM JTF_TERR_QUAL_ALL
5683: WHERE TERR_ID = p_Terr_Id
5684: AND QUAL_USG_ID = P_Terr_Qual_Rec.Qual_Usg_Id ;
5685:
5686: IF ( l_qual_count IS NOT NULL ) AND

Line 6923: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq

6919: jqu.display_sql1,
6920: jqu.display_sql2,
6921: jqu.display_sql3,
6922: html_lov_sql1
6923: from jtf_qual_usgs_ALL jqu, jtf_terr_qual_ALL jtq
6924: where jqu.qual_usg_id = jtq.qual_Usg_Id and
6925: jqu.org_id = jtq.org_id AND
6926: jtq.terr_qual_id = p_Terr_Qual_Id;
6927:

Line 9478: /* insert record IN JTF_TERR_QUAL_ALL */

9474: l_tmpl_terr_qual_rec.overlap_allowed_flag := l_dyn_qual_tbl(i).OVERLAP_ALLOWED_FLAG;
9475: l_tmpl_terr_qual_rec.qualifier_mode := l_dyn_qual_tbl(i).QUALIFIER_MODE;
9476: l_tmpl_terr_qual_rec.org_id := l_dyn_qual_tbl(i).ORG_ID;
9477:
9478: /* insert record IN JTF_TERR_QUAL_ALL */
9479: create_new_terr_qual_rec(l_new_terr_id, l_tmpl_terr_qual_rec, l_new_terr_qual_id);
9480:
9481: l_rec_index := l_dyn_qual_tbl(i).start_record + l_dyn_qual_tbl(i).current_record;
9482: