APPS.JTF_TERRITORY_TYPE_PUB dependencies on JTF_TERRITORY_TYPE_PUB

Line 1: PACKAGE BODY jtf_territory_type_pub AS

1: PACKAGE BODY jtf_territory_type_pub AS
2: /* $Header: jtfpttyb.pls 120.0 2005/06/02 18:21:03 appldev ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERRITORY_TYPE_PUB

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

Line 32: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TERRITORY_TYPE_PUB';

28: -- End of Comments
29: -- ***************************************************
30: -- GLOBAL VARIABLES
31: -- ***************************************************
32: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TERRITORY_TYPE_PUB';
33: g_file_name CONSTANT VARCHAR2(12) := 'jtfpttyb.pls';
34: g_appl_id NUMBER := fnd_global.prog_appl_id;
35: g_login_id NUMBER := fnd_global.conc_login_id;
36: g_program_id NUMBER := fnd_global.conc_program_id;

Line 51: p_terrtype_rec IN jtf_territory_type_pub.terrtype_rec_type,

47: -- History :
48: -- 08/23/99 VNEDUNGA Created
49: -- -------------------------------------------------
50: PROCEDURE convert_tertyperec_pubtopvt (
51: p_terrtype_rec IN jtf_territory_type_pub.terrtype_rec_type,
52: x_terrtype_rec OUT NOCOPY jtf_territory_type_pvt.terrtype_rec_type
53: )
54: AS
55: BEGIN

Line 102: p_terrtypeusgs_tbl IN jtf_territory_type_pub.terrtypeusgs_tbl_type,

98: -- History :
99: -- 08/23/99 VNEDUNGA Created
100: -- -------------------------------------------------
101: PROCEDURE convert_tertypeusg_pubtopvt (
102: p_terrtypeusgs_tbl IN jtf_territory_type_pub.terrtypeusgs_tbl_type,
103: x_terrtypeusgs_tbl OUT NOCOPY jtf_territory_type_pvt.terrtypeusgs_tbl_type
104: )
105: AS
106: l_counter NUMBER;

Line 153: p_typequaltypeusgs_tbl IN jtf_territory_type_pub.typequaltypeusgs_tbl_type,

149: -- History :
150: -- 08/23/99 VNEDUNGA Created
151: -- -------------------------------------------------
152: PROCEDURE convert_typeqtypeusg_pubtopvt (
153: p_typequaltypeusgs_tbl IN jtf_territory_type_pub.typequaltypeusgs_tbl_type,
154: x_typequaltypeusgs_tbl OUT NOCOPY jtf_territory_type_pvt.typequaltypeusgs_tbl_type
155: )
156: AS
157: l_counter NUMBER;

Line 203: p_terrtypequal_tbl IN jtf_territory_type_pub.terrtypequal_tbl_type,

199: -- History :
200: -- 08/23/99 VNEDUNGA Created
201: -- -------------------------------------------------
202: PROCEDURE convert_terrtypequal_pubtopvt (
203: p_terrtypequal_tbl IN jtf_territory_type_pub.terrtypequal_tbl_type,
204: x_terrtypequal_tbl OUT NOCOPY jtf_territory_type_pvt.terrtypequal_tbl_type
205: )
206: AS
207: l_counter NUMBER;

Line 263: x_terrtype_rec OUT NOCOPY jtf_territory_type_pub.terrtype_out_rec_type

259: -- 08/23/99 VNEDUNGA Created
260: -- -------------------------------------------------
261: PROCEDURE convert_terrtypeout_pubtopvt (
262: p_terrtype_rec IN jtf_territory_type_pvt.terrtype_out_rec_type,
263: x_terrtype_rec OUT NOCOPY jtf_territory_type_pub.terrtype_out_rec_type
264: )
265: AS
266: BEGIN
267: --

Line 285: x_terrtypeusgsout_tbl OUT NOCOPY jtf_territory_type_pub.terrtypeusgs_out_tbl_type

281: -- 08/23/99 VNEDUNGA Created
282: -- -------------------------------------------------
283: PROCEDURE convert_typeusgout_pvttopub (
284: p_terrtypeusgsout_tbl IN jtf_territory_type_pvt.terrtypeusgs_out_tbl_type,
285: x_terrtypeusgsout_tbl OUT NOCOPY jtf_territory_type_pub.terrtypeusgs_out_tbl_type
286: )
287: AS
288: l_counter NUMBER;
289: BEGIN

Line 319: x_typequaltypeusgs_tbl OUT NOCOPY jtf_territory_type_pub.typequaltypeusgs_out_tbl_type

315: -- 08/23/99 VNEDUNGA Created
316: -- -------------------------------------------------
317: PROCEDURE convert_typeqtusgout_pvttopub (
318: p_typequaltypeusgs_tbl IN jtf_territory_type_pvt.typequaltypeusgs_out_tbl_type,
319: x_typequaltypeusgs_tbl OUT NOCOPY jtf_territory_type_pub.typequaltypeusgs_out_tbl_type
320: )
321: AS
322: l_counter NUMBER;
323: BEGIN

Line 356: x_terrtypequal_tbl OUT NOCOPY jtf_territory_type_pub.terrtypequal_out_tbl_type

352: -- 08/23/99 VNEDUNGA Created
353: -- -------------------------------------------------
354: PROCEDURE convert_typequalout_pvttopub (
355: p_terrtypequal_tbl IN jtf_territory_type_pvt.terrtypequal_out_tbl_type,
356: x_terrtypequal_tbl OUT NOCOPY jtf_territory_type_pub.terrtypequal_out_tbl_type
357: )
358: AS
359: l_counter NUMBER;
360: BEGIN

Line 1141: END jtf_territory_type_pub; -- Package body

1137:
1138: END deactivate_terrtype;
1139: --
1140:
1141: END jtf_territory_type_pub; -- Package body