DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PUB dependencies on JTF_TERRITORY_RESOURCE_PVT

Line 596: -- before calling the JTF_TERRITORY_RESOURCE_PVT

592: -- Package Name : Convert_TerRsc_PubToPvt
593: -- -------------------------------------------------
594: -- Purpose : This utility procedure will convert
595: -- jtf_terrResource_Tbl from pub to pvt
596: -- before calling the JTF_TERRITORY_RESOURCE_PVT
597: -- pkg.
598: -- Notes :
599: -- History :
600: -- 08/23/99 VNEDUNGA Created

Line 604: x_terrrsc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrresource_tbl_type

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

Line 679: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.

675: -- Package Name : Convert_TerrRscAcc_PubToPvt
676: -- -------------------------------------------------
677: -- Purpose : This utility procedure will convert
678: -- TerrRsc_Access_tbl from pub to pvt before
679: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.
680: -- Notes :
681: -- History :
682: -- 08/23/99 VNEDUNGA Created
683: -- -------------------------------------------------

Line 686: x_terrrscacc_tbl OUT NOCOPY jtf_territory_resource_pvt.terrrsc_access_tbl_type

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

Line 735: -- after calling JTF_TERRITORY_RESOURCE_PVT

731: -- Package Name : Convert_TerrRscOut_PvtToPub
732: -- -------------------------------------------------
733: -- Purpose : This utility procedure will convert
734: -- jtf_terrResource_Out_Tbl from pvt to pub
735: -- after calling JTF_TERRITORY_RESOURCE_PVT
736: -- pkg.
737: -- Notes :
738: -- History :
739: -- 08/23/99 VNEDUNGA Created

Line 742: p_terrrscout_tbl IN jtf_territory_resource_pvt.terrresource_out_tbl_type,

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

Line 775: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.

771: -- Package Name : Convert_TerRscAccOut_PvtToPub
772: -- -------------------------------------------------
773: -- Purpose : This utility procedure will convert
774: -- TerrRsc_Access_Out_tbl from pub to pvt after
775: -- calling the JTF_TERRITORY_RESOURCE_PVT pkg.
776: -- Notes :
777: -- History :
778: -- 08/23/99 VNEDUNGA Created
779: -- -------------------------------------------------

Line 781: p_terrrscaccout_tbl IN jtf_territory_resource_pvt.terrrsc_access_out_tbl_type,

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

Line 2516: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;

2512: IS
2513: l_api_name CONSTANT VARCHAR2(30) := 'Create_TerrResource';
2514: l_api_version_number CONSTANT NUMBER := 1.0;
2515: l_return_status VARCHAR2(1);
2516: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2517: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2518: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2519: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2520: --

Line 2517: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;

2513: l_api_name CONSTANT VARCHAR2(30) := 'Create_TerrResource';
2514: l_api_version_number CONSTANT NUMBER := 1.0;
2515: l_return_status VARCHAR2(1);
2516: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2517: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2518: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2519: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2520: --
2521:

Line 2518: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;

2514: l_api_version_number CONSTANT NUMBER := 1.0;
2515: l_return_status VARCHAR2(1);
2516: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2517: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2518: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2519: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2520: --
2521:
2522: BEGIN

Line 2519: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;

2515: l_return_status VARCHAR2(1);
2516: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2517: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2518: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2519: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2520: --
2521:
2522: BEGIN
2523: -- Standard Start of API savepoint

Line 2566: jtf_territory_resource_pvt.create_terrresource (

2562: );
2563: --
2564: -- API body
2565: --
2566: jtf_territory_resource_pvt.create_terrresource (
2567: p_api_version_number => 1.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,

Line 2739: jtf_territory_resource_pvt.delete_terr_resource (

2735: x_return_status := fnd_api.g_ret_sts_success;
2736: --
2737: -- API body
2738: --
2739: jtf_territory_resource_pvt.delete_terr_resource (
2740: p_api_version_number => p_api_version_number,
2741: p_init_msg_list => p_init_msg_list,
2742: p_commit => p_commit,
2743: p_validation_level => fnd_api.g_valid_level_full,

Line 2869: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;

2865: AS
2866: l_api_name CONSTANT VARCHAR2(30) := 'Update_TerrResource';
2867: l_api_version_number CONSTANT NUMBER := 1.0;
2868: l_return_status VARCHAR2(1);
2869: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2870: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2871: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2872: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2873: --

Line 2870: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;

2866: l_api_name CONSTANT VARCHAR2(30) := 'Update_TerrResource';
2867: l_api_version_number CONSTANT NUMBER := 1.0;
2868: l_return_status VARCHAR2(1);
2869: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2870: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2871: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2872: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2873: --
2874:

Line 2871: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;

2867: l_api_version_number CONSTANT NUMBER := 1.0;
2868: l_return_status VARCHAR2(1);
2869: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2870: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2871: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2872: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2873: --
2874:
2875: BEGIN

Line 2872: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;

2868: l_return_status VARCHAR2(1);
2869: l_terrrsc_tbl jtf_territory_resource_pvt.terrresource_tbl_type;
2870: l_terrrsc_access_tbl jtf_territory_resource_pvt.terrrsc_access_tbl_type;
2871: l_terrrsc_out_tbl jtf_territory_resource_pvt.terrresource_out_tbl_type;
2872: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2873: --
2874:
2875: BEGIN
2876: -- Standard Start of API savepoint

Line 2919: jtf_territory_resource_pvt.update_terrresource (

2915: p_terrrscacc_tbl => p_terrrsc_access_tbl,
2916: x_terrrscacc_tbl => l_terrrsc_access_tbl
2917: );
2918: --
2919: jtf_territory_resource_pvt.update_terrresource (
2920: p_api_version_number => 1.0,
2921: p_init_msg_list => fnd_api.g_false,
2922: p_commit => fnd_api.g_false,
2923: p_validation_level => fnd_api.g_valid_level_full,