APPS.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TERR_TYPE_QUAL

Line 535: FROM jtf_terr_type_qual jtq

531: --Declare cursor to get Terr Qualifier
532: CURSOR c_getterrtypequal
533: IS
534: SELECT jtq.terr_type_qual_id
535: FROM jtf_terr_type_qual jtq
536: WHERE jtq.terr_type_id = l_terrtype_id
537: FOR UPDATE;
538:
539: --Declare cursor to get qualifiers Type usages

Line 1060: FROM jtf_terr_type_qual jtq

1056: jtq.overlap_allowed_flag,
1057: jtq.in_use_flag,
1058: jtq.qualifier_mode,
1059: jtq.org_id
1060: FROM jtf_terr_type_qual jtq
1061: WHERE jtq.terr_type_id = p_terrtype_id
1062: FOR UPDATE;
1063:
1064: --Declare cursor to get qualifiers Type usages

Line 2521: --dbms_ourtput.put_line('Create_TerrType_Qualifier REC: JTF_TERR_TYPE_QUAL_PKG.Insert_Row');

2517: l_terrtypequal_id := NULL;
2518: END IF;
2519:
2520: -- Call insert terrtype_Qualifier table handler
2521: --dbms_ourtput.put_line('Create_TerrType_Qualifier REC: JTF_TERR_TYPE_QUAL_PKG.Insert_Row');
2522: jtf_terr_type_qual_pkg.insert_row (
2523: x_rowid => l_rowid,
2524: x_terr_type_qual_id => l_terrtypequal_id,
2525: x_last_update_date => p_terrtypequal_rec.last_update_date,

Line 2522: jtf_terr_type_qual_pkg.insert_row (

2518: END IF;
2519:
2520: -- Call insert terrtype_Qualifier table handler
2521: --dbms_ourtput.put_line('Create_TerrType_Qualifier REC: JTF_TERR_TYPE_QUAL_PKG.Insert_Row');
2522: jtf_terr_type_qual_pkg.insert_row (
2523: x_rowid => l_rowid,
2524: x_terr_type_qual_id => l_terrtypequal_id,
2525: x_last_update_date => p_terrtypequal_rec.last_update_date,
2526: x_last_updated_by => p_terrtypequal_rec.last_updated_by,

Line 3790: FROM jtf_terr_type_qual

3786: terr_type_id,
3787: exclusive_use_flag,
3788: overlap_allowed_flag,
3789: in_use_flag
3790: FROM jtf_terr_type_qual
3791: WHERE terr_type_qual_id = l_terrtypequal_id
3792: FOR UPDATE NOWAIT;
3793:
3794: --

Line 3898: --dbms_ourtput.put_line('Update_TerrType_Qualifier REC: Before Calling JTF_TERR_TYPE_QUAL_PKG.Update_Row');

3894: END IF;
3895: --
3896: END IF;
3897:
3898: --dbms_ourtput.put_line('Update_TerrType_Qualifier REC: Before Calling JTF_TERR_TYPE_QUAL_PKG.Update_Row');
3899: jtf_terr_type_qual_pkg.update_row (
3900: x_rowid => l_rowid,
3901: x_terr_type_qual_id => p_terrtypequal_rec.terr_type_qual_id,
3902: x_last_update_date => p_terrtypequal_rec.last_update_date,

Line 3899: jtf_terr_type_qual_pkg.update_row (

3895: --
3896: END IF;
3897:
3898: --dbms_ourtput.put_line('Update_TerrType_Qualifier REC: Before Calling JTF_TERR_TYPE_QUAL_PKG.Update_Row');
3899: jtf_terr_type_qual_pkg.update_row (
3900: x_rowid => l_rowid,
3901: x_terr_type_qual_id => p_terrtypequal_rec.terr_type_qual_id,
3902: x_last_update_date => p_terrtypequal_rec.last_update_date,
3903: x_last_updated_by => p_terrtypequal_rec.last_updated_by,

Line 4583: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: Before Calling JTF_TERR_TYPE_QUAL_PKG.Delete_Row');

4579:
4580: --Initialize the return status to success
4581: x_return_status := fnd_api.g_ret_sts_success;
4582: --
4583: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: Before Calling JTF_TERR_TYPE_QUAL_PKG.Delete_Row');
4584: jtf_terr_type_qual_pkg.delete_row (
4585: x_terr_type_qual_id => p_terrtypequal_id
4586: );
4587: --

Line 4584: jtf_terr_type_qual_pkg.delete_row (

4580: --Initialize the return status to success
4581: x_return_status := fnd_api.g_ret_sts_success;
4582: --
4583: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: Before Calling JTF_TERR_TYPE_QUAL_PKG.Delete_Row');
4584: jtf_terr_type_qual_pkg.delete_row (
4585: x_terr_type_qual_id => p_terrtypequal_id
4586: );
4587: --
4588: --Prepare message name