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.8 2010/12/01 06:18:05 srguntur ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERRITORY_PUB

2: /* $Header: jtfpterb.pls 120.8 2010/12/01 06:18:05 srguntur 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_terrqual_rec IN jtf_territory_pub.terr_qual_rec_type,

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

Line 218: p_terrvalues_tbl IN jtf_territory_pub.terr_values_tbl_type,

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

Line 314: p_terrusgs_tbl IN jtf_territory_pub.terr_usgs_tbl_type,

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

Line 363: p_terrqtypeusgs_tbl IN jtf_territory_pub.terr_qualtypeusgs_tbl_type,

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

Line 415: x_terr_rec OUT NOCOPY jtf_territory_pub.terr_all_out_rec_type

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

Line 438: x_terrusgsout_tbl OUT NOCOPY jtf_territory_pub.terr_usgs_out_tbl_type

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

Line 473: x_terrqualtypeusgs_tbl OUT NOCOPY jtf_territory_pub.terr_qualtypeusgs_out_tbl_type

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

Line 507: x_terrqual_tbl OUT NOCOPY jtf_territory_pub.terr_qual_out_tbl_type

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

Line 542: x_terrqual_rec OUT NOCOPY jtf_territory_pub.terr_qual_out_rec_type

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

Line 566: x_terrvaluesout_tbl OUT NOCOPY jtf_territory_pub.terr_values_out_tbl_type

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

Line 603: p_terrrsc_tbl IN jtf_territory_pub.terrresource_tbl_type,

599: -- History :
600: -- 08/23/99 VNEDUNGA Created
601: -- -------------------------------------------------
602: PROCEDURE convert_terrrsc_pubtopvt (
603: p_terrrsc_tbl IN jtf_territory_pub.terrresource_tbl_type,
604: x_terrrsc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrresource_tbl_type
605: )
606: AS
607: l_counter NUMBER;

Line 685: p_terrrscacc_tbl IN jtf_territory_pub.terrrsc_access_tbl_type,

681: -- History :
682: -- 08/23/99 VNEDUNGA Created
683: -- -------------------------------------------------
684: PROCEDURE convert_terrrscacc_pubtopvt (
685: p_terrrscacc_tbl IN jtf_territory_pub.terrrsc_access_tbl_type,
686: x_terrrscacc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrrsc_access_tbl_type
687: )
688: AS
689: l_counter NUMBER;

Line 743: x_terrrscout_tbl OUT NOCOPY jtf_territory_pub.terrresource_out_tbl_type

739: -- 08/23/99 VNEDUNGA Created
740: -- -------------------------------------------------
741: PROCEDURE convert_terrrscout_pvttopub (
742: p_terrrscout_tbl IN jtf_territory_resource_pvt.terrresource_out_tbl_type,
743: x_terrrscout_tbl OUT NOCOPY jtf_territory_pub.terrresource_out_tbl_type
744: )
745: AS
746: l_counter NUMBER;
747: BEGIN

Line 782: x_terrrscaccout_tbl OUT NOCOPY jtf_territory_pub.terrrsc_access_out_tbl_type

778: -- 08/23/99 VNEDUNGA Created
779: -- -------------------------------------------------
780: PROCEDURE convert_terrscaccout_pvttopub (
781: p_terrrscaccout_tbl IN jtf_territory_resource_pvt.terrrsc_access_out_tbl_type,
782: x_terrrscaccout_tbl OUT NOCOPY jtf_territory_pub.terrrsc_access_out_tbl_type
783: )
784: AS
785: l_counter NUMBER;
786: BEGIN

Line 3004: END jtf_territory_pub;

3000:
3001: END update_terrresource;
3002: --
3003:
3004: END jtf_territory_pub;