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_PUB

Line 1: PACKAGE BODY JTF_TERRITORY_PUB AS

1: PACKAGE BODY JTF_TERRITORY_PUB AS
2: /* $Header: jtfpterb.pls 120.0 2005/06/02 18:20:46 appldev ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERRITORY_PUB

2: /* $Header: jtfpterb.pls 120.0 2005/06/02 18:20:46 appldev ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERRITORY_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force core territory manager public api's.
10: -- This package is a public API for inserting territory

Line 38: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TERRITORY_PUB';

34: -- 12/03/04 achanda added value4_id : bug # 3726007
35: --
36: -- End of Comments
37: --
38: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TERRITORY_PUB';
39: g_file_name CONSTANT VARCHAR2(12) := 'jtfpterb.pls';
40:
41: -- -------------------------------------------------
42: -- Package Name : Convert_TerrRec_PubToPvt

Line 52: p_terr_rec IN jtf_territory_pub.terr_all_rec_type

48: -- History :
49: -- 08/23/99 VNEDUNGA Created
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

Line 123: p_terrqual_tbl IN jtf_territory_pub.terr_qual_tbl_type,

119: -- History :
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;

Line 182: p_terrvalues_tbl IN jtf_territory_pub.terr_values_tbl_type,

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

Line 278: p_terrusgs_tbl IN jtf_territory_pub.terr_usgs_tbl_type,

274: -- History :
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;

Line 327: p_terrqtypeusgs_tbl IN jtf_territory_pub.terr_qualtypeusgs_tbl_type,

323: -- History :
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;

Line 379: x_terr_rec OUT NOCOPY jtf_territory_pub.terr_all_out_rec_type

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

Line 402: x_terrusgsout_tbl OUT NOCOPY jtf_territory_pub.terr_usgs_out_tbl_type

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;
406: BEGIN

Line 437: x_terrqualtypeusgs_tbl OUT NOCOPY jtf_territory_pub.terr_qualtypeusgs_out_tbl_type

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;
441: BEGIN

Line 471: x_terrqual_tbl OUT NOCOPY jtf_territory_pub.terr_qual_out_tbl_type

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;
475: BEGIN

Line 508: x_terrvaluesout_tbl OUT NOCOPY jtf_territory_pub.terr_values_out_tbl_type

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;
512: BEGIN

Line 545: p_terrrsc_tbl IN jtf_territory_pub.terrresource_tbl_type,

541: -- History :
542: -- 08/23/99 VNEDUNGA Created
543: -- -------------------------------------------------
544: PROCEDURE convert_terrrsc_pubtopvt (
545: p_terrrsc_tbl IN jtf_territory_pub.terrresource_tbl_type,
546: x_terrrsc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrresource_tbl_type
547: )
548: AS
549: l_counter NUMBER;

Line 612: p_terrrscacc_tbl IN jtf_territory_pub.terrrsc_access_tbl_type,

608: -- History :
609: -- 08/23/99 VNEDUNGA Created
610: -- -------------------------------------------------
611: PROCEDURE convert_terrrscacc_pubtopvt (
612: p_terrrscacc_tbl IN jtf_territory_pub.terrrsc_access_tbl_type,
613: x_terrrscacc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrrsc_access_tbl_type
614: )
615: AS
616: l_counter NUMBER;

Line 668: x_terrrscout_tbl OUT NOCOPY jtf_territory_pub.terrresource_out_tbl_type

664: -- 08/23/99 VNEDUNGA Created
665: -- -------------------------------------------------
666: PROCEDURE convert_terrrscout_pvttopub (
667: p_terrrscout_tbl IN jtf_territory_resource_pvt.terrresource_out_tbl_type,
668: x_terrrscout_tbl OUT NOCOPY jtf_territory_pub.terrresource_out_tbl_type
669: )
670: AS
671: l_counter NUMBER;
672: BEGIN

Line 707: x_terrrscaccout_tbl OUT NOCOPY jtf_territory_pub.terrrsc_access_out_tbl_type

703: -- 08/23/99 VNEDUNGA Created
704: -- -------------------------------------------------
705: PROCEDURE convert_terrscaccout_pvttopub (
706: p_terrrscaccout_tbl IN jtf_territory_resource_pvt.terrrsc_access_out_tbl_type,
707: x_terrrscaccout_tbl OUT NOCOPY jtf_territory_pub.terrrsc_access_out_tbl_type
708: )
709: AS
710: l_counter NUMBER;
711: BEGIN

Line 2061: END jtf_territory_pub;

2057:
2058: END update_terrresource;
2059: --
2060:
2061: END jtf_territory_pub;