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_TerrValueTbl_PubToPvt
172: -- -----------------------------------------------------
173: -- Purpose : This utility procedure will convert
174: -- JTF_TERR_VALUES_TBL from pub to pvt
175: -- before calling the JTF_TERRITORY_PVT
176: -- pkg.
177: -- Notes :
178: -- History :
179: -- 08/23/99 VNEDUNGA Created

Line 183: x_terrvalues_tbl OUT NOCOPY jtf_territory_pvt.terr_values_tbl_type

179: -- 08/23/99 VNEDUNGA Created
180: -- -----------------------------------------------------
181: PROCEDURE convert_terrvaluetbl_pubtopvt (
182: p_terrvalues_tbl IN jtf_territory_pub.terr_values_tbl_type,
183: x_terrvalues_tbl OUT NOCOPY jtf_territory_pvt.terr_values_tbl_type
184: )
185: AS
186: --
187: l_counter NUMBER;

Line 271: -- before calling the JTF_TERRITORY_PVT

267: -- Package Name : Convert_TerrUsgsTbl_PubToPvt
268: -- -----------------------------------------------------
269: -- Purpose : This utility procedure will convert
270: -- JTF_TERR_USGS_TBL from pub to pvt
271: -- before calling the JTF_TERRITORY_PVT
272: -- pkg.
273: -- Notes :
274: -- History :
275: -- 08/23/99 VNEDUNGA Created

Line 279: x_terrusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_usgs_tbl_type

275: -- 08/23/99 VNEDUNGA Created
276: -- -----------------------------------------------------
277: PROCEDURE convert_terrusgstbl_pubtopvt (
278: p_terrusgs_tbl IN jtf_territory_pub.terr_usgs_tbl_type,
279: x_terrusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_usgs_tbl_type
280: )
281: AS
282: l_counter NUMBER;
283: BEGIN

Line 320: -- to pvt before calling the JTF_TERRITORY_PVT

316: -- Package Name : Convert_TerQTypUsgTbl_PubToPvt
317: -- -----------------------------------------------------
318: -- Purpose : This utility procedure will convert
319: -- JTF_TERR_QUAL_TYPE_USGS_TBL from pub
320: -- to pvt before calling the JTF_TERRITORY_PVT
321: -- pkg.
322: -- Notes :
323: -- History :
324: -- 08/23/99 VNEDUNGA Created

Line 328: x_terrqtypeusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_qualtypeusgs_tbl_type

324: -- 08/23/99 VNEDUNGA Created
325: -- -----------------------------------------------------
326: PROCEDURE convert_terqtypusgtbl_pubtopvt (
327: p_terrqtypeusgs_tbl IN jtf_territory_pub.terr_qualtypeusgs_tbl_type,
328: x_terrqtypeusgs_tbl OUT NOCOPY jtf_territory_pvt.terr_qualtypeusgs_tbl_type
329: )
330: AS
331: l_counter NUMBER;
332: BEGIN

Line 378: p_terr_rec IN jtf_territory_pvt.terr_all_out_rec_type,

374: -- History :
375: -- 08/23/99 VNEDUNGA Created
376: -- -------------------------------------------------
377: PROCEDURE convert_terrout_pvttopub (
378: p_terr_rec IN jtf_territory_pvt.terr_all_out_rec_type,
379: x_terr_rec OUT NOCOPY jtf_territory_pub.terr_all_out_rec_type
380: )
381: AS
382: BEGIN

Line 395: -- after calling JTF_TERRITORY_PVT pkg.

391: -- Package Name : Convert_TerrUsgOut_PvtToPub
392: -- -------------------------------------------------
393: -- Purpose : This utility procedure will convert
394: -- Terr_Usgs_out_Tbl from pvt to pub
395: -- after calling JTF_TERRITORY_PVT pkg.
396: -- Notes :
397: -- History :
398: -- 08/23/99 VNEDUNGA Created
399: -- -------------------------------------------------

Line 401: p_terrusgsout_tbl IN jtf_territory_pvt.terr_usgs_out_tbl_type,

397: -- History :
398: -- 08/23/99 VNEDUNGA Created
399: -- -------------------------------------------------
400: PROCEDURE convert_terrusgout_pvttopub (
401: p_terrusgsout_tbl IN jtf_territory_pvt.terr_usgs_out_tbl_type,
402: x_terrusgsout_tbl OUT NOCOPY jtf_territory_pub.terr_usgs_out_tbl_type
403: )
404: AS
405: l_counter NUMBER;

Line 429: -- to pub after calling JTF_TERRITORY_PVT

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

Line 436: p_terrqualtypeusgs_tbl IN jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type,

432: -- History :
433: -- 08/23/99 VNEDUNGA Created
434: -- -------------------------------------------------
435: PROCEDURE convert_terrqtusgout_pvttopub (
436: p_terrqualtypeusgs_tbl IN jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type,
437: x_terrqualtypeusgs_tbl OUT NOCOPY jtf_territory_pub.terr_qualtypeusgs_out_tbl_type
438: )
439: AS
440: l_counter NUMBER;

Line 463: -- to pub after calling JTF_TERRITORY_PVT

459:
460: -- -------------------------------------------------
461: -- Purpose : This utility procedure will convert
462: -- Terr_Qual_Out_Tbl from pvt
463: -- to pub after calling JTF_TERRITORY_PVT
464: -- pkg.
465: -- Notes :
466: -- History :
467: -- 08/23/99 VNEDUNGA Created

Line 470: p_terrqual_tbl IN jtf_territory_pvt.terr_qual_out_tbl_type,

466: -- History :
467: -- 08/23/99 VNEDUNGA Created
468: -- -------------------------------------------------
469: PROCEDURE convert_terrqualout_pvttopub (
470: p_terrqual_tbl IN jtf_territory_pvt.terr_qual_out_tbl_type,
471: x_terrqual_tbl OUT NOCOPY jtf_territory_pub.terr_qual_out_tbl_type
472: )
473: AS
474: l_counter NUMBER;

Line 500: -- to pub after calling JTF_TERRITORY_PVT

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

Line 507: p_terrvaluesout_tbl IN jtf_territory_pvt.terr_values_out_tbl_type,

503: -- History :
504: -- 08/23/99 VNEDUNGA Created
505: -- -------------------------------------------------
506: PROCEDURE convert_terrvaluesout_pvttopub (
507: p_terrvaluesout_tbl IN jtf_territory_pvt.terr_values_out_tbl_type,
508: x_terrvaluesout_tbl OUT NOCOPY jtf_territory_pub.terr_values_out_tbl_type
509: )
510: AS
511: l_counter NUMBER;

Line 800: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;

796: IS
797: l_api_name CONSTANT VARCHAR2(30) := 'Create_Territory';
798: l_api_version_number CONSTANT NUMBER := 1.0;
799: l_return_status VARCHAR2(1);
800: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

Line 801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;

797: l_api_name CONSTANT VARCHAR2(30) := 'Create_Territory';
798: l_api_version_number CONSTANT NUMBER := 1.0;
799: l_return_status VARCHAR2(1);
800: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

Line 802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;

798: l_api_version_number CONSTANT NUMBER := 1.0;
799: l_return_status VARCHAR2(1);
800: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

Line 803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

799: l_return_status VARCHAR2(1);
800: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

Line 804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

800: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

Line 805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

801: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
809: --

Line 806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

802: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
809: --
810:

Line 807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

803: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
809: --
810:
811: BEGIN

Line 808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

804: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
805: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
806: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
807: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
809: --
810:
811: BEGIN
812: -- Standard Start of API savepoint

Line 866: jtf_territory_pvt.create_territory (

862: p_terrqtypeusgs_tbl => p_terr_qualtypeusgs_tbl,
863: x_terrqtypeusgs_tbl => l_terr_qualtypeusgs_tbl
864: );
865: -- ******************************************************************
866: jtf_territory_pvt.create_territory (
867: p_api_version_number => 1.0,
868: p_init_msg_list => fnd_api.g_false,
869: p_commit => fnd_api.g_false,
870: p_validation_level => fnd_api.g_valid_level_full,

Line 1050: jtf_territory_pvt.delete_territory (

1046: x_return_status := fnd_api.g_ret_sts_success;
1047: --
1048: -- API body
1049: --
1050: jtf_territory_pvt.delete_territory (
1051: p_api_version_number => p_api_version_number,
1052: p_init_msg_list => p_init_msg_list,
1053: p_commit => p_commit,
1054: x_return_status => x_return_status,

Line 1194: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;

1190: AS
1191: l_api_name CONSTANT VARCHAR2(30) := 'Update_Territory';
1192: l_api_version_number CONSTANT NUMBER := 1.0;
1193: l_return_status VARCHAR2(1);
1194: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

Line 1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;

1191: l_api_name CONSTANT VARCHAR2(30) := 'Update_Territory';
1192: l_api_version_number CONSTANT NUMBER := 1.0;
1193: l_return_status VARCHAR2(1);
1194: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

Line 1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;

1192: l_api_version_number CONSTANT NUMBER := 1.0;
1193: l_return_status VARCHAR2(1);
1194: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

Line 1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;

1193: l_return_status VARCHAR2(1);
1194: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

Line 1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;

1194: l_terr_out_rec jtf_territory_pvt.terr_all_out_rec_type;
1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

Line 1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;

1195: l_terr_usgs_out_tbl jtf_territory_pvt.terr_usgs_out_tbl_type;
1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

Line 1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;

1196: l_terr_qualtypeusgs_out_tbl jtf_territory_pvt.terr_qualtypeusgs_out_tbl_type;
1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1204: BEGIN

Line 1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;

1197: l_terr_qual_out_tbl jtf_territory_pvt.terr_qual_out_tbl_type;
1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1204: BEGIN
1205: --dbms_output.put_line('Update_Territory PUB: Entering API');

Line 1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;

1198: l_terr_values_out_tbl jtf_territory_pvt.terr_values_out_tbl_type;
1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1204: BEGIN
1205: --dbms_output.put_line('Update_Territory PUB: Entering API');
1206:

Line 1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;

1199: l_terr_rec jtf_territory_pvt.terr_all_rec_type;
1200: l_terr_usgs_tbl jtf_territory_pvt.terr_usgs_tbl_type;
1201: l_terr_qualtypeusgs_tbl jtf_territory_pvt.terr_qualtypeusgs_tbl_type;
1202: l_terr_qual_tbl jtf_territory_pvt.terr_qual_tbl_type;
1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1204: BEGIN
1205: --dbms_output.put_line('Update_Territory PUB: Entering API');
1206:
1207: -- Standard Start of API savepoint

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

1258: convert_terqtypusgtbl_pubtopvt (
1259: p_terrqtypeusgs_tbl => p_terr_qualtypeusgs_tbl,
1260: x_terrqtypeusgs_tbl => l_terr_qualtypeusgs_tbl
1261: );
1262: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');
1263: jtf_territory_pvt.update_territory (
1264: p_api_version_number => 1.0,
1265: p_init_msg_list => fnd_api.g_false,
1266: p_commit => fnd_api.g_false,

Line 1263: jtf_territory_pvt.update_territory (

1259: p_terrqtypeusgs_tbl => p_terr_qualtypeusgs_tbl,
1260: x_terrqtypeusgs_tbl => l_terr_qualtypeusgs_tbl
1261: );
1262: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');
1263: jtf_territory_pvt.update_territory (
1264: p_api_version_number => 1.0,
1265: p_init_msg_list => fnd_api.g_false,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,

Line 1449: jtf_territory_pvt.deactivate_territory (

1445: x_return_status := fnd_api.g_ret_sts_success;
1446: --
1447: -- API body
1448: --
1449: jtf_territory_pvt.deactivate_territory (
1450: p_api_version_number => p_api_version_number,
1451: p_init_msg_list => p_init_msg_list,
1452: p_commit => p_commit,
1453: x_return_status => x_return_status,