DBA Data[Home] [Help]

APPS.OZF_CODE_CONVERSION_PVT dependencies on JTF_NUMBER_TABLE

Line 32: x_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: p_code_conversion_tbl IN code_conversion_tbl_type,
32: x_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
33: )
34: IS
35: l_api_name CONSTANT VARCHAR2(30) := 'create_code_conversion';
36: l_api_version_number CONSTANT NUMBER := 1.0;

Line 117: x_code_conversion_id_tbl := JTF_NUMBER_TABLE();

113:
114: l_code_conversion_id := NULL;
115: l_object_version_number := NULL;
116:
117: x_code_conversion_id_tbl := JTF_NUMBER_TABLE();
118:
119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
120: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_code_conversion_tbl.count);
121: END IF;

Line 263: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE

259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_code_conversion_tbl IN code_conversion_tbl_type ,
263: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE
264: )
265: IS
266: l_api_name CONSTANT VARCHAR2(30) := 'Update_code_conversion';
267: l_api_version_number CONSTANT NUMBER := 1.0;

Line 359: x_object_version_number := JTF_NUMBER_TABLE();

355: END IF;
356:
357: -- Initialize API return status to SUCCESS
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359: x_object_version_number := JTF_NUMBER_TABLE();
360:
361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
362: OZF_UTILITY_PVT.debug_message('p_code_conversion_tbl(1).description: ' || p_code_conversion_tbl(1).description );
363: END IF;

Line 670: v_code_conversion_id JTF_NUMBER_TABLE;

666:
667: p_code_conversion_rec code_conversion_rec_type;
668:
669: l_code_conversion_id NUMBER;
670: v_code_conversion_id JTF_NUMBER_TABLE;
671: v_object_version_number JTF_NUMBER_TABLE;
672:
673: l_create_flag VARCHAR2(10);
674:

Line 671: v_object_version_number JTF_NUMBER_TABLE;

667: p_code_conversion_rec code_conversion_rec_type;
668:
669: l_code_conversion_id NUMBER;
670: v_code_conversion_id JTF_NUMBER_TABLE;
671: v_object_version_number JTF_NUMBER_TABLE;
672:
673: l_create_flag VARCHAR2(10);
674:
675: l_create_code_conv_tbl code_conversion_tbl_type := code_conversion_tbl_type();

Line 725: v_code_conversion_id := JTF_NUMBER_TABLE();

721: END IF;
722: -- Initialize API return status to SUCCESS
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724:
725: v_code_conversion_id := JTF_NUMBER_TABLE();
726: v_object_version_number := JTF_NUMBER_TABLE();
727:
728: FOR i IN P_code_conversion_Tbl.first .. P_code_conversion_Tbl.last
729: LOOP

Line 726: v_object_version_number := JTF_NUMBER_TABLE();

722: -- Initialize API return status to SUCCESS
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724:
725: v_code_conversion_id := JTF_NUMBER_TABLE();
726: v_object_version_number := JTF_NUMBER_TABLE();
727:
728: FOR i IN P_code_conversion_Tbl.first .. P_code_conversion_Tbl.last
729: LOOP
730:

Line 2715: x_supp_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

2711: x_return_status OUT NOCOPY VARCHAR2,
2712: x_msg_count OUT NOCOPY NUMBER,
2713: x_msg_data OUT NOCOPY VARCHAR2,
2714: p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type,
2715: x_supp_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
2716: )
2717: IS
2718: l_api_name CONSTANT VARCHAR2(30) := 'create_supp_code_conversion';
2719: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2800: x_supp_code_conversion_id_tbl := JTF_NUMBER_TABLE();

2796:
2797: l_code_conversion_id := NULL;
2798: l_object_version_number := NULL;
2799:
2800: x_supp_code_conversion_id_tbl := JTF_NUMBER_TABLE();
2801:
2802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2803: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_supp_code_conversion_tbl.count);
2804: END IF;

Line 2945: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE

2941: x_return_status OUT NOCOPY VARCHAR2,
2942: x_msg_count OUT NOCOPY NUMBER,
2943: x_msg_data OUT NOCOPY VARCHAR2,
2944: p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type ,
2945: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE
2946: )
2947: IS
2948: l_api_name CONSTANT VARCHAR2(30) := 'Update_supp_code_conversion';
2949: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3040: x_object_version_number := JTF_NUMBER_TABLE();

3036: END IF;
3037:
3038: -- Initialize API return status to SUCCESS
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;
3040: x_object_version_number := JTF_NUMBER_TABLE();
3041:
3042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3043: OZF_UTILITY_PVT.debug_message('p_supp_code_conversion_tbl(1).description: ' || p_supp_code_conversion_tbl(1).description );
3044: END IF;

Line 3350: v_code_conversion_id JTF_NUMBER_TABLE;

3346:
3347: p_supp_code_conversion_rec supp_code_conversion_rec_type;
3348:
3349: l_code_conversion_id NUMBER;
3350: v_code_conversion_id JTF_NUMBER_TABLE;
3351: v_object_version_number JTF_NUMBER_TABLE;
3352:
3353: l_create_flag VARCHAR2(10);
3354:

Line 3351: v_object_version_number JTF_NUMBER_TABLE;

3347: p_supp_code_conversion_rec supp_code_conversion_rec_type;
3348:
3349: l_code_conversion_id NUMBER;
3350: v_code_conversion_id JTF_NUMBER_TABLE;
3351: v_object_version_number JTF_NUMBER_TABLE;
3352:
3353: l_create_flag VARCHAR2(10);
3354:
3355: l_create_supp_code_conv_tbl supp_code_conversion_tbl_type := supp_code_conversion_tbl_type();

Line 3405: v_code_conversion_id := JTF_NUMBER_TABLE();

3401: END IF;
3402: -- Initialize API return status to SUCCESS
3403: x_return_status := FND_API.G_RET_STS_SUCCESS;
3404:
3405: v_code_conversion_id := JTF_NUMBER_TABLE();
3406: v_object_version_number := JTF_NUMBER_TABLE();
3407:
3408: FOR i IN P_supp_code_conversion_Tbl.first .. P_supp_code_conversion_Tbl.last
3409: LOOP

Line 3406: v_object_version_number := JTF_NUMBER_TABLE();

3402: -- Initialize API return status to SUCCESS
3403: x_return_status := FND_API.G_RET_STS_SUCCESS;
3404:
3405: v_code_conversion_id := JTF_NUMBER_TABLE();
3406: v_object_version_number := JTF_NUMBER_TABLE();
3407:
3408: FOR i IN P_supp_code_conversion_Tbl.first .. P_supp_code_conversion_Tbl.last
3409: LOOP
3410: