DBA Data[Home] [Help]

APPS.OZF_CODE_CONVERSION_PVT dependencies on JTF_NUMBER_TABLE

Line 34: x_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

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

Line 123: x_code_conversion_id_tbl := JTF_NUMBER_TABLE();

119:
120: l_code_conversion_id := NULL;
121: l_object_version_number := NULL;
122:
123: x_code_conversion_id_tbl := JTF_NUMBER_TABLE();
124:
125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
126: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_code_conversion_tbl.count);
127: END IF;

Line 276: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE

272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_code_conversion_tbl IN code_conversion_tbl_type ,
276: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE
277: )
278: IS
279: l_api_name CONSTANT VARCHAR2(30) := 'Update_code_conversion';
280: l_api_version_number CONSTANT NUMBER := 1.0;

Line 372: x_object_version_number := JTF_NUMBER_TABLE();

368: END IF;
369:
370: -- Initialize API return status to SUCCESS
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372: x_object_version_number := JTF_NUMBER_TABLE();
373:
374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
375: OZF_UTILITY_PVT.debug_message('p_code_conversion_tbl(1).description: ' || p_code_conversion_tbl(1).description );
376: END IF;

Line 683: v_code_conversion_id JTF_NUMBER_TABLE;

679:
680: p_code_conversion_rec code_conversion_rec_type;
681:
682: l_code_conversion_id NUMBER;
683: v_code_conversion_id JTF_NUMBER_TABLE;
684: v_object_version_number JTF_NUMBER_TABLE;
685:
686: l_create_flag VARCHAR2(10);
687:

Line 684: v_object_version_number JTF_NUMBER_TABLE;

680: p_code_conversion_rec code_conversion_rec_type;
681:
682: l_code_conversion_id NUMBER;
683: v_code_conversion_id JTF_NUMBER_TABLE;
684: v_object_version_number JTF_NUMBER_TABLE;
685:
686: l_create_flag VARCHAR2(10);
687:
688: l_create_code_conv_tbl code_conversion_tbl_type := code_conversion_tbl_type();

Line 738: v_code_conversion_id := JTF_NUMBER_TABLE();

734: END IF;
735: -- Initialize API return status to SUCCESS
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:
738: v_code_conversion_id := JTF_NUMBER_TABLE();
739: v_object_version_number := JTF_NUMBER_TABLE();
740:
741: FOR i IN P_code_conversion_Tbl.first .. P_code_conversion_Tbl.last
742: LOOP

Line 739: v_object_version_number := JTF_NUMBER_TABLE();

735: -- Initialize API return status to SUCCESS
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:
738: v_code_conversion_id := JTF_NUMBER_TABLE();
739: v_object_version_number := JTF_NUMBER_TABLE();
740:
741: FOR i IN P_code_conversion_Tbl.first .. P_code_conversion_Tbl.last
742: LOOP
743:

Line 2746: x_supp_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

2742: x_return_status OUT NOCOPY VARCHAR2,
2743: x_msg_count OUT NOCOPY NUMBER,
2744: x_msg_data OUT NOCOPY VARCHAR2,
2745: p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type,
2746: x_supp_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
2747: )
2748: IS
2749: l_api_name CONSTANT VARCHAR2(30) := 'create_supp_code_conversion';
2750: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2831: x_supp_code_conversion_id_tbl := JTF_NUMBER_TABLE();

2827:
2828: l_code_conversion_id := NULL;
2829: l_object_version_number := NULL;
2830:
2831: x_supp_code_conversion_id_tbl := JTF_NUMBER_TABLE();
2832:
2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2834: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_supp_code_conversion_tbl.count);
2835: END IF;

Line 2976: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE

2972: x_return_status OUT NOCOPY VARCHAR2,
2973: x_msg_count OUT NOCOPY NUMBER,
2974: x_msg_data OUT NOCOPY VARCHAR2,
2975: p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type ,
2976: x_object_version_number OUT NOCOPY JTF_NUMBER_TABLE
2977: )
2978: IS
2979: l_api_name CONSTANT VARCHAR2(30) := 'Update_supp_code_conversion';
2980: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3071: x_object_version_number := JTF_NUMBER_TABLE();

3067: END IF;
3068:
3069: -- Initialize API return status to SUCCESS
3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071: x_object_version_number := JTF_NUMBER_TABLE();
3072:
3073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3074: OZF_UTILITY_PVT.debug_message('p_supp_code_conversion_tbl(1).description: ' || p_supp_code_conversion_tbl(1).description );
3075: END IF;

Line 3381: v_code_conversion_id JTF_NUMBER_TABLE;

3377:
3378: p_supp_code_conversion_rec supp_code_conversion_rec_type;
3379:
3380: l_code_conversion_id NUMBER;
3381: v_code_conversion_id JTF_NUMBER_TABLE;
3382: v_object_version_number JTF_NUMBER_TABLE;
3383:
3384: l_create_flag VARCHAR2(10);
3385:

Line 3382: v_object_version_number JTF_NUMBER_TABLE;

3378: p_supp_code_conversion_rec supp_code_conversion_rec_type;
3379:
3380: l_code_conversion_id NUMBER;
3381: v_code_conversion_id JTF_NUMBER_TABLE;
3382: v_object_version_number JTF_NUMBER_TABLE;
3383:
3384: l_create_flag VARCHAR2(10);
3385:
3386: l_create_supp_code_conv_tbl supp_code_conversion_tbl_type := supp_code_conversion_tbl_type();

Line 3436: v_code_conversion_id := JTF_NUMBER_TABLE();

3432: END IF;
3433: -- Initialize API return status to SUCCESS
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;
3435:
3436: v_code_conversion_id := JTF_NUMBER_TABLE();
3437: v_object_version_number := JTF_NUMBER_TABLE();
3438:
3439: FOR i IN P_supp_code_conversion_Tbl.first .. P_supp_code_conversion_Tbl.last
3440: LOOP

Line 3437: v_object_version_number := JTF_NUMBER_TABLE();

3433: -- Initialize API return status to SUCCESS
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;
3435:
3436: v_code_conversion_id := JTF_NUMBER_TABLE();
3437: v_object_version_number := JTF_NUMBER_TABLE();
3438:
3439: FOR i IN P_supp_code_conversion_Tbl.first .. P_supp_code_conversion_Tbl.last
3440: LOOP
3441: