APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TYPE_QTYPE_USGS

Line 543: FROM jtf_type_qtype_usgs jtqu

539: --Declare cursor to get qualifiers Type usages
540: CURSOR c_gettypequaltypeusgs
541: IS
542: SELECT jtqu.type_qtype_usg_id
543: FROM jtf_type_qtype_usgs jtqu
544: WHERE jtqu.terr_type_id = l_terrtype_id
545: FOR UPDATE;
546:
547: --Declare cursor to get Terr Usages

Line 1076: FROM jtf_type_qtype_usgs jtqu

1072: jtqu.creation_date,
1073: jtqu.created_by,
1074: jtqu.last_update_login,
1075: jtqu.org_id
1076: FROM jtf_type_qtype_usgs jtqu
1077: WHERE jtqu.terr_type_id = p_terrtype_id
1078: FOR UPDATE;
1079:
1080: --Declare cursor to get Terr Usages

Line 2143: --dbms_ourtput.put_line('Create_TerrTypeQualType_Usage REC: Calling JTF_TYPE_QTYPE_USGS_PKG.Insert_Row');

2139: END IF;
2140: END IF;
2141:
2142: --
2143: --dbms_ourtput.put_line('Create_TerrTypeQualType_Usage REC: Calling JTF_TYPE_QTYPE_USGS_PKG.Insert_Row');
2144:
2145: /* Intialise to NULL if FND_API.G_MISS_NUM,
2146: ** otherwise used passed in value
2147: */

Line 2153: jtf_type_qtype_usgs_pkg.insert_row (

2149: l_typequaltype_usg_id := NULL;
2150: END IF;
2151:
2152: -- Call insert terr_Qual_Type_Usgs table handler
2153: jtf_type_qtype_usgs_pkg.insert_row (
2154: x_rowid => l_rowid,
2155: x_type_qtype_usg_id => l_typequaltype_usg_id,
2156: x_last_updated_by => p_typequaltypeusgs_rec.last_updated_by,
2157: x_last_update_date => p_typequaltypeusgs_rec.last_update_date,

Line 3452: FROM jtf_type_qtype_usgs

3448: creation_date,
3449: last_update_login,
3450: terr_type_id,
3451: qual_type_usg_id
3452: FROM jtf_type_qtype_usgs
3453: WHERE type_qtype_usg_id = l_type_qual_type_usg_id
3454: FOR UPDATE NOWAIT;
3455:
3456: --Local variable declaration

Line 3550: --dbms_ourtput.put_line('Update_TerrTypeQualType_Usage REC: JTF_TYPE_QTYPE_USGS_PKG.Update_Row');

3546: RAISE fnd_api.g_exc_error;
3547: END IF;
3548: END IF;
3549:
3550: --dbms_ourtput.put_line('Update_TerrTypeQualType_Usage REC: JTF_TYPE_QTYPE_USGS_PKG.Update_Row');
3551: jtf_type_qtype_usgs_pkg.update_row (
3552: x_rowid => l_rowid,
3553: x_type_qtype_usg_id => p_typequaltypeusgs_rec.type_qual_type_usg_id,
3554: x_last_updated_by => p_typequaltypeusgs_rec.last_updated_by,

Line 3551: jtf_type_qtype_usgs_pkg.update_row (

3547: END IF;
3548: END IF;
3549:
3550: --dbms_ourtput.put_line('Update_TerrTypeQualType_Usage REC: JTF_TYPE_QTYPE_USGS_PKG.Update_Row');
3551: jtf_type_qtype_usgs_pkg.update_row (
3552: x_rowid => l_rowid,
3553: x_type_qtype_usg_id => p_typequaltypeusgs_rec.type_qual_type_usg_id,
3554: x_last_updated_by => p_typequaltypeusgs_rec.last_updated_by,
3555: x_last_update_date => p_typequaltypeusgs_rec.last_update_date,

Line 4443: --dbms_ourtput.put_line('Delete_TerrTypeQualType_Usage PVT: Before Calling JTF_TYPE_QTYPE_USGS_PKG.Delete_Row');

4439:
4440: --Initialize the return status to success
4441: x_return_status := fnd_api.g_ret_sts_success;
4442: --
4443: --dbms_ourtput.put_line('Delete_TerrTypeQualType_Usage PVT: Before Calling JTF_TYPE_QTYPE_USGS_PKG.Delete_Row');
4444: jtf_type_qtype_usgs_pkg.delete_row (
4445: x_type_qtype_usg_id => p_terrtypequaltype_usg_id
4446: );
4447: --

Line 4444: jtf_type_qtype_usgs_pkg.delete_row (

4440: --Initialize the return status to success
4441: x_return_status := fnd_api.g_ret_sts_success;
4442: --
4443: --dbms_ourtput.put_line('Delete_TerrTypeQualType_Usage PVT: Before Calling JTF_TYPE_QTYPE_USGS_PKG.Delete_Row');
4444: jtf_type_qtype_usgs_pkg.delete_row (
4445: x_type_qtype_usg_id => p_terrtypequaltype_usg_id
4446: );
4447: --
4448: --

Line 4866: jtf_type_qtype_usgs jtqu

4862: SELECT 'x'
4863: INTO l_temp
4864: FROM jtf_qual_usgs jqu,
4865: jtf_qual_type_usgs jqtu,
4866: jtf_type_qtype_usgs jtqu
4867: WHERE jtqu.terr_type_id = p_terr_type_id
4868: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
4869: AND jqu.qual_usg_id = p_terrtypequal_rec.qual_usg_id
4870: AND jqu.enabled_flag = 'Y'