APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TERR_TYPE_USGS_PKG

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