eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERRITORY_PUB dependencies on JTF_TERRITORY_PVT

Line 46: -- calling the JTF_TERRITORY_PVT pkg.

42: -- Package Name : Convert_TerrRec_PubToPvt
43: -- -------------------------------------------------
44: -- Purpose : This utility procedure will convert
45: -- jtf_terr_rec from pub to pvt before
46: -- calling the JTF_TERRITORY_PVT pkg.
47: -- Notes :
48: -- History :
49: -- 08/23/99 VNEDUNGA Created
50: -- -------------------------------------------------

Line 54: x_terr_rec OUT NOCOPY jtf_territory_pvt.terr_all_rec_type

50: -- -------------------------------------------------
51: PROCEDURE convert_terrrec_pubtopvt (
52: p_terr_rec IN jtf_territory_pub.terr_all_rec_type
53: := g_miss_terr_all_rec,
54: x_terr_rec OUT NOCOPY jtf_territory_pvt.terr_all_rec_type
55: )
56: AS
57: BEGIN
58: --dbms_output.put_line('Convert_TerrRec_PubToPvt: Entering API');

Line 116: -- before calling the JTF_TERRITORY_PVT

112: -- Package Name : Convert_TerrQualTbl_PubToPvt
113: -- --------------------------------------------------------
114: -- Purpose : This utility procedure will convert
115: -- JTF_TERR_QUAL_TBL from pub to pvt
116: -- before calling the JTF_TERRITORY_PVT
117: -- pkg.
118: -- Notes :
119: -- History :
120: -- 08/23/99 VNEDUNGA Created

Line 124: x_terrqual_tbl OUT NOCOPY jtf_territory_pvt.terr_qual_tbl_type

120: -- 08/23/99 VNEDUNGA Created
121: -- ---------------------------------------------------------
122: PROCEDURE convert_terrqualtbl_pubtopvt (
123: p_terrqual_tbl IN jtf_territory_pub.terr_qual_tbl_type,
124: x_terrqual_tbl OUT NOCOPY jtf_territory_pvt.terr_qual_tbl_type
125: )
126: AS
127: l_counter NUMBER;
128: --

Line 175: -- before calling the JTF_TERRITORY_PVT

171: -- Package Name : Convert_TerrQualrec_PubToPvt
172: -- --------------------------------------------------------
173: -- Purpose : This utility procedure will convert
174: -- JTF_TERR_QUAL_REC from pub to pvt
175: -- before calling the JTF_TERRITORY_PVT
176: -- pkg.
177: -- Notes :
178: -- History :
179: -- VPALLE Created

Line 183: x_terrqual_rec OUT NOCOPY jtf_territory_pvt.terr_qual_rec_type

179: -- VPALLE Created
180: -- ---------------------------------------------------------
181: PROCEDURE convert_terrqualrec_pubtopvt (
182: p_terrqual_rec IN jtf_territory_pub.terr_qual_rec_type,
183: x_terrqual_rec OUT NOCOPY jtf_territory_pvt.terr_qual_rec_type
184: )
185: AS
186: l_counter NUMBER;
187: --

Line 211: -- before calling the JTF_TERRITORY_PVT

207: -- Package Name : Convert_TerrValueTbl_PubToPvt
208: -- -----------------------------------------------------
209: -- Purpose : This utility procedure will convert
210: -- JTF_TERR_VALUES_TBL from pub to pvt
211: -- before calling the JTF_TERRITORY_PVT
212: -- pkg.
213: -- Notes :
214: -- History :
215: -- 08/23/99 VNEDUNGA Created

Line 219: x_terrvalues_tbl OUT NOCOPY jtf_territory_pvt.terr_values_tbl_type

215: -- 08/23/99 VNEDUNGA Created
216: -- -----------------------------------------------------
217: PROCEDURE convert_terrvaluetbl_pubtopvt (
218: p_terrvalues_tbl IN jtf_territory_pub.terr_values_tbl_type,
219: x_terrvalues_tbl OUT NOCOPY jtf_territory_pvt.terr_values_tbl_type
220: )
221: AS
222: --
223: l_counter NUMBER;

Line 307: -- before calling the JTF_TERRITORY_PVT

303: -- Package Name : Convert_TerrUsgsTbl_PubToPvt
304: -- -----------------------------------------------------
305: -- Purpose : This utility procedure will convert
306: -- JTF_TERR_USGS_TBL from pub to pvt
307: -- before calling the JTF_TERRITORY_PVT
308: -- pkg.
309: -- Notes :
310: -- History :
311: -- 08/23/99 VNEDUNGA Created

Line 315: x_terrusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_usgs_tbl_type

311: -- 08/23/99 VNEDUNGA Created
312: -- -----------------------------------------------------
313: PROCEDURE convert_terrusgstbl_pubtopvt (
314: p_terrusgs_tbl IN jtf_territory_pub.terr_usgs_tbl_type,
315: x_terrusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_usgs_tbl_type
316: )
317: AS
318: l_counter NUMBER;
319: BEGIN

Line 356: -- to pvt before calling the JTF_TERRITORY_PVT

352: -- Package Name : Convert_TerQTypUsgTbl_PubToPvt
353: -- -----------------------------------------------------
354: -- Purpose : This utility procedure will convert
355: -- JTF_TERR_QUAL_TYPE_USGS_TBL from pub
356: -- to pvt before calling the JTF_TERRITORY_PVT
357: -- pkg.
358: -- Notes :
359: -- History :
360: -- 08/23/99 VNEDUNGA Created

Line 364: x_terrqtypeusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_qualtypeusgs_tbl_type

360: -- 08/23/99 VNEDUNGA Created
361: -- -----------------------------------------------------
362: PROCEDURE convert_terqtypusgtbl_pubtopvt (
363: p_terrqtypeusgs_tbl IN jtf_territory_pub.terr_qualtypeusgs_tbl_type,
364: x_terrqtypeusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_qualtypeusgs_tbl_type
365: )
366: AS
367: l_counter NUMBER;
368: BEGIN

Line 414: p_terr_rec IN jtf_territory_pvt.terr_all_out_rec_type,

410: -- History :
411: -- 08/23/99 VNEDUNGA Created
412: -- -------------------------------------------------
413: PROCEDURE convert_terrout_pvttopub (
414: p_terr_rec IN jtf_territory_pvt.terr_all_out_rec_type,
415: x_terr_rec OUT NOCOPY jtf_territory_pub.terr_all_out_rec_type
416: )
417: AS
418: BEGIN

Line 431: -- after calling JTF_TERRITORY_PVT pkg.

427: -- Package Name : Convert_TerrUsgOut_PvtToPub
428: -- -------------------------------------------------
429: -- Purpose : This utility procedure will convert
430: -- Terr_Usgs_out_Tbl from pvt to pub
431: -- after calling JTF_TERRITORY_PVT pkg.
432: -- Notes :
433: -- History :
434: -- 08/23/99 VNEDUNGA Created
435: -- -------------------------------------------------

Line 437: p_terrusgsout_tbl IN jtf_territory_pvt.terr_usgs_out_tbl_type,

433: -- History :
434: -- 08/23/99 VNEDUNGA Created
435: -- -------------------------------------------------
436: PROCEDURE convert_terrusgout_pvttopub (
437: p_terrusgsout_tbl IN jtf_territory_pvt.terr_usgs_out_tbl_type,
438: x_terrusgsout_tbl OUT NOCOPY jtf_territory_pub.terr_usgs_out_tbl_type
439: )
440: AS
441: l_counter NUMBER;

Line 465: -- to pub after calling JTF_TERRITORY_PVT

461: -- Package Name : Convert_TerrQTUsgOut_PvtToPub
462: -- -------------------------------------------------
463: -- Purpose : This utility procedure will convert
464: -- Terr_QualTypeUsgs_Out_Tbl from pvt
465: -- to pub after calling JTF_TERRITORY_PVT
466: -- pkg.
467: -- Notes :
468: -- History :
469: -- 08/23/99 VNEDUNGA Created

Line 472: p_terrqualtypeusgs_tbl IN jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type,

468: -- History :
469: -- 08/23/99 VNEDUNGA Created
470: -- -------------------------------------------------
471: PROCEDURE convert_terrqtusgout_pvttopub (
472: p_terrqualtypeusgs_tbl IN jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type,
473: x_terrqualtypeusgs_tbl OUT NOCOPY jtf_territory_pub.terr_qualtypeusgs_out_tbl_type
474: )
475: AS
476: l_counter NUMBER;

Line 499: -- to pub after calling JTF_TERRITORY_PVT

495:
496: -- -------------------------------------------------
497: -- Purpose : This utility procedure will convert
498: -- Terr_Qual_Out_Tbl from pvt
499: -- to pub after calling JTF_TERRITORY_PVT
500: -- pkg.
501: -- Notes :
502: -- History :
503: -- 08/23/99 VNEDUNGA Created

Line 506: p_terrqual_tbl IN jtf_territory_pvt.terr_qual_out_tbl_type,

502: -- History :
503: -- 08/23/99 VNEDUNGA Created
504: -- -------------------------------------------------
505: PROCEDURE convert_terrqualout_pvttopub (
506: p_terrqual_tbl IN jtf_territory_pvt.terr_qual_out_tbl_type,
507: x_terrqual_tbl OUT NOCOPY jtf_territory_pub.terr_qual_out_tbl_type
508: )
509: AS
510: l_counter NUMBER;

Line 534: -- to pub after calling JTF_TERRITORY_PVT

530:
531: -- -------------------------------------------------
532: -- Purpose : This utility procedure will convert
533: -- Terr_Qual_Out_Tbl from pvt
534: -- to pub after calling JTF_TERRITORY_PVT
535: -- pkg.
536: -- Notes :
537: -- History :
538: -- 08/23/99 VNEDUNGA Created

Line 541: p_terrqual_rec IN jtf_territory_pvt.terr_qual_out_rec_type,

537: -- History :
538: -- 08/23/99 VNEDUNGA Created
539: -- -------------------------------------------------
540: PROCEDURE convert_terrqualout_pvttopub (
541: p_terrqual_rec IN jtf_territory_pvt.terr_qual_out_rec_type,
542: x_terrqual_rec OUT NOCOPY jtf_territory_pub.terr_qual_out_rec_type
543: )
544: AS
545: l_counter NUMBER;

Line 558: -- to pub after calling JTF_TERRITORY_PVT

554: -- Package Name : Convert_TerrValuesOut_PvtToPub
555: -- -------------------------------------------------
556: -- Purpose : This utility procedure will convert
557: -- Terr_Values_Out_Tbl from pvt
558: -- to pub after calling JTF_TERRITORY_PVT
559: -- pkg.
560: -- Notes :
561: -- History :
562: -- 08/23/99 VNEDUNGA Created

Line 565: p_terrvaluesout_tbl IN jtf_territory_pvt.terr_values_out_tbl_type,

561: -- History :
562: -- 08/23/99 VNEDUNGA Created
563: -- -------------------------------------------------
564: PROCEDURE convert_terrvaluesout_pvttopub (
565: p_terrvaluesout_tbl IN jtf_territory_pvt.terr_values_out_tbl_type,
566: x_terrvaluesout_tbl OUT NOCOPY jtf_territory_pub.terr_values_out_tbl_type
567: )
568: AS
569: l_counter NUMBER;

Line 878: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;

874: IS
875: l_api_name CONSTANT VARCHAR2(30) := 'Create_Territory';
876: l_api_version_number CONSTANT NUMBER := 1.0;
877: l_return_status VARCHAR2(1);
878: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

Line 879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;

875: l_api_name CONSTANT VARCHAR2(30) := 'Create_Territory';
876: l_api_version_number CONSTANT NUMBER := 1.0;
877: l_return_status VARCHAR2(1);
878: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

Line 880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;

876: l_api_version_number CONSTANT NUMBER := 1.0;
877: l_return_status VARCHAR2(1);
878: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

Line 881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

877: l_return_status VARCHAR2(1);
878: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

Line 882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

878: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

Line 883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

879: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
887: --

Line 884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

880: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
887: --
888:

Line 885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

881: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
887: --
888:
889: BEGIN

Line 886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

882: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
883: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
884: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
885: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
887: --
888:
889: BEGIN
890: -- Standard Start of API savepoint

Line 944: jtf_territory_pvt.create_territory (

940: p_terrqtypeusgs_tbl => p_terr_qualtypeusgs_tbl,
941: x_terrqtypeusgs_tbl => l_terr_qualtypeusgs_tbl
942: ); */
943: -- ******************************************************************
944: jtf_territory_pvt.create_territory (
945: p_api_version_number => 1.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_false,
948: p_validation_level => fnd_api.g_valid_level_full,

Line 1128: jtf_territory_pvt.delete_territory (

1124: x_return_status := fnd_api.g_ret_sts_success;
1125: --
1126: -- API body
1127: --
1128: jtf_territory_pvt.delete_territory (
1129: p_api_version_number => p_api_version_number,
1130: p_init_msg_list => p_init_msg_list,
1131: p_commit => p_commit,
1132: x_return_status => x_return_status,

Line 1265: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;

1261: AS
1262: l_api_name CONSTANT VARCHAR2(30) := 'Update_Territory';
1263: l_api_version_number CONSTANT NUMBER := 1.0;
1264: l_return_status VARCHAR2(1);
1265: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

Line 1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;

1262: l_api_name CONSTANT VARCHAR2(30) := 'Update_Territory';
1263: l_api_version_number CONSTANT NUMBER := 1.0;
1264: l_return_status VARCHAR2(1);
1265: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

Line 1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;

1263: l_api_version_number CONSTANT NUMBER := 1.0;
1264: l_return_status VARCHAR2(1);
1265: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

Line 1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;

1264: l_return_status VARCHAR2(1);
1265: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

Line 1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

1265: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

Line 1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

1266: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

Line 1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

1267: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1275: BEGIN

Line 1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

1268: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1275: BEGIN
1276: --dbms_output.put_line('Update_Territory PUB: Entering API');

Line 1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

1269: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1275: BEGIN
1276: --dbms_output.put_line('Update_Territory PUB: Entering API');
1277:

Line 1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

1270: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1271: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1272: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1273: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1275: BEGIN
1276: --dbms_output.put_line('Update_Territory PUB: Entering API');
1277:
1278: -- Standard Start of API savepoint

Line 1334: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');

1330: convert_terqtypusgtbl_pubtopvt (
1331: p_terrqtypeusgs_tbl => p_terr_qualtypeusgs_tbl,
1332: x_terrqtypeusgs_tbl => l_terr_qualtypeusgs_tbl
1333: ); */
1334: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');
1335: jtf_territory_pvt.update_territory (
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => fnd_api.g_false,
1338: p_commit => fnd_api.g_false,

Line 1335: jtf_territory_pvt.update_territory (

1331: p_terrqtypeusgs_tbl => p_terr_qualtypeusgs_tbl,
1332: x_terrqtypeusgs_tbl => l_terr_qualtypeusgs_tbl
1333: ); */
1334: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');
1335: jtf_territory_pvt.update_territory (
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => fnd_api.g_false,
1338: p_commit => fnd_api.g_false,
1339: p_validation_level => fnd_api.g_valid_level_full,

Line 1524: jtf_territory_pvt.deactivate_territory (

1520: x_return_status := fnd_api.g_ret_sts_success;
1521: --
1522: -- API body
1523: --
1524: jtf_territory_pvt.deactivate_territory (
1525: p_api_version_number => p_api_version_number,
1526: p_init_msg_list => p_init_msg_list,
1527: p_commit => p_commit,
1528: x_return_status => x_return_status,

Line 1649: l_terr_qual_out_rec jtf_territory_pvt.terr_qual_out_rec_type;

1645: AS
1646: l_api_name CONSTANT VARCHAR2(30) := 'Create_Territory_Qualifier';
1647: l_api_version_number CONSTANT NUMBER := 1.0;
1648: l_return_status VARCHAR2(1);
1649: l_terr_qual_out_rec jtf_territory_pvt.terr_qual_out_rec_type;
1650: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1651: l_terr_qual_rec jtf_territory_pvt.terr_qual_rec_type;
1652: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1653: --

Line 1650: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

1646: l_api_name CONSTANT VARCHAR2(30) := 'Create_Territory_Qualifier';
1647: l_api_version_number CONSTANT NUMBER := 1.0;
1648: l_return_status VARCHAR2(1);
1649: l_terr_qual_out_rec jtf_territory_pvt.terr_qual_out_rec_type;
1650: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1651: l_terr_qual_rec jtf_territory_pvt.terr_qual_rec_type;
1652: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1653: --
1654:

Line 1651: l_terr_qual_rec jtf_territory_pvt.terr_qual_rec_type;

1647: l_api_version_number CONSTANT NUMBER := 1.0;
1648: l_return_status VARCHAR2(1);
1649: l_terr_qual_out_rec jtf_territory_pvt.terr_qual_out_rec_type;
1650: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1651: l_terr_qual_rec jtf_territory_pvt.terr_qual_rec_type;
1652: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1653: --
1654:
1655: BEGIN

Line 1652: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

1648: l_return_status VARCHAR2(1);
1649: l_terr_qual_out_rec jtf_territory_pvt.terr_qual_out_rec_type;
1650: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1651: l_terr_qual_rec jtf_territory_pvt.terr_qual_rec_type;
1652: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1653: --
1654:
1655: BEGIN
1656: -- Standard Start of API savepoint

Line 1697: jtf_territory_pvt.Create_Terr_qualifier (

1693: p_terrvalues_tbl => p_terr_values_tbl,
1694: x_terrvalues_tbl => l_terr_values_tbl
1695: );
1696: -- ******************************************************************
1697: jtf_territory_pvt.Create_Terr_qualifier (
1698: p_api_version_number => 1.0,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_commit => fnd_api.g_false,
1701: p_validation_level => fnd_api.g_valid_level_full,

Line 1865: jtf_territory_pvt.Delete_Terr_Qualifier (

1861: x_return_status := fnd_api.g_ret_sts_success;
1862: --
1863: -- API body
1864: --
1865: jtf_territory_pvt.Delete_Terr_Qualifier (
1866: p_api_version_number => p_api_version_number,
1867: p_init_msg_list => p_init_msg_list,
1868: p_commit => p_commit,
1869: x_return_status => l_return_status,

Line 1987: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

1983: AS
1984: l_api_name CONSTANT VARCHAR2(30) := 'create_terr_values';
1985: l_api_version_number CONSTANT NUMBER := 1.0;
1986: l_return_status VARCHAR2(1);
1987: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1988: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1989: l_Terr_Qual_Id NUMBER;
1990: BEGIN
1991: --dbms_output.put_line('create_terr_value PUB: Entering API');

Line 1988: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

1984: l_api_name CONSTANT VARCHAR2(30) := 'create_terr_values';
1985: l_api_version_number CONSTANT NUMBER := 1.0;
1986: l_return_status VARCHAR2(1);
1987: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1988: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1989: l_Terr_Qual_Id NUMBER;
1990: BEGIN
1991: --dbms_output.put_line('create_terr_value PUB: Entering API');
1992:

Line 2037: jtf_territory_pvt.create_terr_value( P_Api_Version_Number => 1.0,

2033:
2034: -- Check whether ant data is passed for update of value table
2035: If P_Terr_Values_Tbl.Count > 0 Then
2036: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2037: jtf_territory_pvt.create_terr_value( P_Api_Version_Number => 1.0,
2038: P_Init_Msg_List => fnd_api.g_false,
2039: P_Commit => fnd_api.g_false,
2040: p_validation_level => fnd_api.g_valid_level_full,
2041: P_Terr_Id => null,

Line 2170: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

2166: AS
2167: l_api_name CONSTANT VARCHAR2(30) := 'Update_Territory';
2168: l_api_version_number CONSTANT NUMBER := 1.0;
2169: l_return_status VARCHAR2(1);
2170: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
2171: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
2172: BEGIN
2173: --dbms_output.put_line('Update_Territory PUB: Entering API');
2174:

Line 2171: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

2167: l_api_name CONSTANT VARCHAR2(30) := 'Update_Territory';
2168: l_api_version_number CONSTANT NUMBER := 1.0;
2169: l_return_status VARCHAR2(1);
2170: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
2171: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
2172: BEGIN
2173: --dbms_output.put_line('Update_Territory PUB: Entering API');
2174:
2175: -- Standard Start of API savepoint

Line 2219: jtf_territory_pvt.Update_Terr_Value( P_Api_Version_Number => 1.0,

2215:
2216: -- Check whether ant data is passed for update of value table
2217: If P_Terr_Values_Tbl.Count > 0 Then
2218: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2219: jtf_territory_pvt.Update_Terr_Value( P_Api_Version_Number => 1.0,
2220: P_Init_Msg_List => fnd_api.g_false,
2221: P_Commit => fnd_api.g_false,
2222: p_validation_level => fnd_api.g_valid_level_full,
2223: P_Terr_Value_Tbl => l_Terr_Values_Tbl,

Line 2384: jtf_territory_pvt.Delete_Terr_Value (

2380: --
2381: -- API body
2382: --
2383:
2384: jtf_territory_pvt.Delete_Terr_Value (
2385: p_api_version_number => p_api_version_number,
2386: p_init_msg_list => p_init_msg_list,
2387: p_commit => p_commit,
2388: x_return_status => l_return_status,