APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TYPE_QTYPE_USGS_PKG

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 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: --