DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PUB dependencies on JTF_TERRITORY_RESOURCE_PVT

Line 538: -- before calling the JTF_TERRITORY_RESOURCE_PVT

534: -- Package Name : Convert_TerRsc_PubToPvt
535: -- -------------------------------------------------
536: -- Purpose : This utility procedure will convert
537: -- jtf_terrResource_Tbl from pub to pvt
538: -- before calling the JTF_TERRITORY_RESOURCE_PVT
539: -- pkg.
540: -- Notes :
541: -- History :
542: -- 08/23/99 VNEDUNGA Created

Line 546: x_terrrsc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrresource_tbl_type

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

Line 606: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.

602: -- Package Name : Convert_TerrRscAcc_PubToPvt
603: -- -------------------------------------------------
604: -- Purpose : This utility procedure will convert
605: -- TerrRsc_Access_tbl from pub to pvt before
606: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.
607: -- Notes :
608: -- History :
609: -- 08/23/99 VNEDUNGA Created
610: -- -------------------------------------------------

Line 613: x_terrrscacc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrrsc_access_tbl_type

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

Line 660: -- after calling JTF_TERRITORY_RESOURCE_PVT

656: -- Package Name : Convert_TerrRscOut_PvtToPub
657: -- -------------------------------------------------
658: -- Purpose : This utility procedure will convert
659: -- jtf_terrResource_Out_Tbl from pvt to pub
660: -- after calling JTF_TERRITORY_RESOURCE_PVT
661: -- pkg.
662: -- Notes :
663: -- History :
664: -- 08/23/99 VNEDUNGA Created

Line 667: p_terrrscout_tbl IN jtf_territory_resource_pvt.terrresource_out_tbl_type,

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

Line 700: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.

696: -- Package Name : Convert_TerRscAccOut_PvtToPub
697: -- -------------------------------------------------
698: -- Purpose : This utility procedure will convert
699: -- TerrRsc_Access_Out_tbl from pub to pvt after
700: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.
701: -- Notes :
702: -- History :
703: -- 08/23/99 VNEDUNGA Created
704: -- -------------------------------------------------

Line 706: p_terrrscaccout_tbl IN jtf_territory_resource_pvt.terrrsc_access_out_tbl_type,

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

Line 1577: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;

1573: IS
1574: l_api_name CONSTANT VARCHAR2(30) := 'Create_TerrResource';
1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_return_status VARCHAR2(1);
1577: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1578: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1579: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1580: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1581: --

Line 1578: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;

1574: l_api_name CONSTANT VARCHAR2(30) := 'Create_TerrResource';
1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_return_status VARCHAR2(1);
1577: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1578: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1579: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1580: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1581: --
1582:

Line 1579: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;

1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_return_status VARCHAR2(1);
1577: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1578: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1579: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1580: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1581: --
1582:
1583: BEGIN

Line 1580: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;

1576: l_return_status VARCHAR2(1);
1577: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1578: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1579: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1580: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1581: --
1582:
1583: BEGIN
1584: -- Standard Start of API savepoint

Line 1626: jtf_territory_resource_pvt.create_terrresource (

1622: );
1623: --
1624: -- API body
1625: --
1626: jtf_territory_resource_pvt.create_terrresource (
1627: p_api_version_number => 1.0,
1628: p_init_msg_list => fnd_api.g_false,
1629: p_commit => fnd_api.g_false,
1630: p_validation_level => fnd_api.g_valid_level_full,

Line 1798: jtf_territory_resource_pvt.delete_terr_resource (

1794: x_return_status := fnd_api.g_ret_sts_success;
1795: --
1796: -- API body
1797: --
1798: jtf_territory_resource_pvt.delete_terr_resource (
1799: p_api_version_number => p_api_version_number,
1800: p_init_msg_list => p_init_msg_list,
1801: p_commit => p_commit,
1802: p_validation_level => fnd_api.g_valid_level_full,

Line 1927: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;

1923: AS
1924: l_api_name CONSTANT VARCHAR2(30) := 'Update_TerrResource';
1925: l_api_version_number CONSTANT NUMBER := 1.0;
1926: l_return_status VARCHAR2(1);
1927: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1928: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1929: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1930: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1931: --

Line 1928: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;

1924: l_api_name CONSTANT VARCHAR2(30) := 'Update_TerrResource';
1925: l_api_version_number CONSTANT NUMBER := 1.0;
1926: l_return_status VARCHAR2(1);
1927: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1928: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1929: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1930: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1931: --
1932:

Line 1929: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;

1925: l_api_version_number CONSTANT NUMBER := 1.0;
1926: l_return_status VARCHAR2(1);
1927: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1928: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1929: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1930: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1931: --
1932:
1933: BEGIN

Line 1930: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;

1926: l_return_status VARCHAR2(1);
1927: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
1928: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
1929: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
1930: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1931: --
1932:
1933: BEGIN
1934: -- Standard Start of API savepoint

Line 1977: jtf_territory_resource_pvt.update_terrresource (

1973: p_terrrscacc_tbl => p_terrrsc_access_tbl,
1974: x_terrrscacc_tbl => l_terrrsc_access_tbl
1975: );
1976: --
1977: jtf_territory_resource_pvt.update_terrresource (
1978: p_api_version_number => 1.0,
1979: p_init_msg_list => fnd_api.g_false,
1980: p_commit => fnd_api.g_false,
1981: p_validation_level => fnd_api.g_valid_level_full,