APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TERR_TYPE_USGS

Line 551: FROM jtf_terr_type_usgs jtu

547: --Declare cursor to get Terr Usages
548: CURSOR c_getterrtypeusgs
549: IS
550: SELECT jtu.terr_type_usg_id
551: FROM jtf_terr_type_usgs jtu
552: WHERE jtu.terr_type_id = l_terrtype_id
553: FOR UPDATE;
554:
555: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Territory';

Line 1092: FROM jtf_terr_type_usgs jtu

1088: jtu.creation_date,
1089: jtu.created_by,
1090: jtu.last_update_login,
1091: jtu.org_id
1092: FROM jtf_terr_type_usgs jtu
1093: WHERE jtu.terr_type_id = p_terrtype_id
1094: FOR UPDATE;
1095:
1096: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Territory_Type';

Line 1906: -- dbms_ourtput.put_line('Create_TerrType_Usages PVT: Inside Loop JTF_TERR_TYPE_USGS_PKG.Insert_Row');

1902: FOR l_counter IN 1 .. l_terrtypeusgs_tbl_count
1903: LOOP
1904: --
1905: BEGIN
1906: -- dbms_ourtput.put_line('Create_TerrType_Usages PVT: Inside Loop JTF_TERR_TYPE_USGS_PKG.Insert_Row');
1907: -- Initialize API return status to success
1908: x_return_status := fnd_api.g_ret_sts_success;
1909:
1910: IF (p_validation_level >= fnd_api.g_valid_level_full)

Line 1952: jtf_terr_type_usgs_pkg.insert_row (

1948: l_terrtypeusg_id := NULL;
1949: END IF;
1950:
1951: --
1952: jtf_terr_type_usgs_pkg.insert_row (
1953: x_rowid => l_rowid,
1954: x_terr_type_usg_id => l_terrtypeusg_id,
1955: x_last_update_date => p_terrtypeusgs_tbl (l_counter).last_update_date,
1956: x_last_updated_by => p_terrtypeusgs_tbl (l_counter).last_updated_by,

Line 3110: FROM jtf_terr_type_usgs

3106: creation_date,
3107: last_update_login,
3108: terr_type_id,
3109: source_id
3110: FROM jtf_terr_type_usgs
3111: WHERE terr_type_usg_id = l_terr_type_usg_id
3112: FOR UPDATE NOWAIT;
3113:
3114: --Local variable declaration

Line 3210: --dbms_ourtput.put_line('Update_TerrType_Usages REC: Before Calling JTF_TERR_TYPE_USGS_PKG.Update_Row');

3206: RAISE fnd_api.g_exc_error;
3207: END IF;
3208: End If;
3209:
3210: --dbms_ourtput.put_line('Update_TerrType_Usages REC: Before Calling JTF_TERR_TYPE_USGS_PKG.Update_Row');
3211: -- Call insert terr_Qual_Type_Usgs table handler
3212: jtf_terr_type_usgs_pkg.update_row (
3213: x_rowid => l_rowid,
3214: x_terr_type_usg_id => p_terrtypeusgs_rec.terr_type_usg_id,

Line 3212: jtf_terr_type_usgs_pkg.update_row (

3208: End If;
3209:
3210: --dbms_ourtput.put_line('Update_TerrType_Usages REC: Before Calling JTF_TERR_TYPE_USGS_PKG.Update_Row');
3211: -- Call insert terr_Qual_Type_Usgs table handler
3212: jtf_terr_type_usgs_pkg.update_row (
3213: x_rowid => l_rowid,
3214: x_terr_type_usg_id => p_terrtypeusgs_rec.terr_type_usg_id,
3215: x_last_update_date => p_terrtypeusgs_rec.last_update_date,
3216: x_last_updated_by => p_terrtypeusgs_rec.last_updated_by,

Line 4304: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: Before Calling JTF_TERR_TYPE_USGS_PKG.Delete_Row');

4300:
4301: --Initialize the return status to success
4302: x_return_status := fnd_api.g_ret_sts_success;
4303: --
4304: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: Before Calling JTF_TERR_TYPE_USGS_PKG.Delete_Row');
4305: jtf_terr_type_usgs_pkg.delete_row (
4306: x_terr_type_usg_id => p_terrtypeusg_id
4307: );
4308: --

Line 4305: jtf_terr_type_usgs_pkg.delete_row (

4301: --Initialize the return status to success
4302: x_return_status := fnd_api.g_ret_sts_success;
4303: --
4304: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: Before Calling JTF_TERR_TYPE_USGS_PKG.Delete_Row');
4305: jtf_terr_type_usgs_pkg.delete_row (
4306: x_terr_type_usg_id => p_terrtypeusg_id
4307: );
4308: --
4309: --Prepare message name

Line 5230: FROM jtf_terr_type_usgs jtu, jtf_qual_type_usgs jqtu

5226: l_qual_type_usg_id := p_type_qualtypeusgs_rec.qual_type_usg_id;
5227: --Check the qual_type_usg_id specified is valid
5228: SELECT 1
5229: INTO l_dummy
5230: FROM jtf_terr_type_usgs jtu, jtf_qual_type_usgs jqtu
5231: WHERE jtu.terr_type_id = p_terr_type_id
5232: AND jtu.source_id = jqtu.source_id
5233: AND jqtu.qual_type_usg_id = l_qual_type_usg_id;
5234: EXCEPTION