eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_COPY_CONTRACT_PVT

Line 1: Package body OKC_COPY_CONTRACT_PVT AS

1: Package body OKC_COPY_CONTRACT_PVT AS
2: /*$Header: OKCRCPYB.pls 120.20.12010000.2 2008/10/24 08:02:16 ssreekum ship $*/
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;

Line 1546: OKC_DEBUG.Set_Indentation('OKC_COPY_CONTRACT_PVT.Copy_Articles ');

1542: WHERE cat_id = p_cat_id;
1543:
1544: BEGIN
1545: IF (l_debug = 'Y') THEN
1546: OKC_DEBUG.Set_Indentation('OKC_COPY_CONTRACT_PVT.Copy_Articles ');
1547: OKC_DEBUG.log('100 : Entering Copy_Articles ', 2);
1548: OKC_DEBUG.log('101 : p_cat_id: '||p_cat_id, 2);
1549: OKC_DEBUG.log('101 : p_cle_id: '||p_cle_id, 2);
1550: OKC_DEBUG.log('101 : p_chr_id: '||p_chr_id, 2);

Line 3054: l_string := 'BEGIN OKC_COPY_CONTRACT_PVT.g_rulv_rec.' ||l_col_vals(i).col_name||' := null; END;';

3050: ELSE
3051: l_time_value_copied := 'N';
3052: x_return_status := l_return_status;
3053: /*
3054: l_string := 'BEGIN OKC_COPY_CONTRACT_PVT.g_rulv_rec.' ||l_col_vals(i).col_name||' := null; END;';
3055: EXECUTE IMMEDIATE l_string;
3056: */
3057:
3058: -- skekkar

Line 3063: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := NULL;

3059: -- Bug 2934909 Changed dynamic sql to static
3060: --
3061:
3062: IF l_col_vals(i).col_name = 'RULE_INFORMATION1' THEN
3063: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := NULL;
3064: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION2' THEN
3065: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := NULL;
3066: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3067: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := NULL;

Line 3065: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := NULL;

3061:
3062: IF l_col_vals(i).col_name = 'RULE_INFORMATION1' THEN
3063: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := NULL;
3064: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION2' THEN
3065: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := NULL;
3066: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3067: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := NULL;
3068: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3069: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := NULL;

Line 3067: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := NULL;

3063: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := NULL;
3064: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION2' THEN
3065: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := NULL;
3066: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3067: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := NULL;
3068: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3069: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := NULL;
3070: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3071: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := NULL;

Line 3069: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := NULL;

3065: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := NULL;
3066: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3067: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := NULL;
3068: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3069: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := NULL;
3070: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3071: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := NULL;
3072: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3073: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := NULL;

Line 3071: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := NULL;

3067: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := NULL;
3068: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3069: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := NULL;
3070: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3071: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := NULL;
3072: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3073: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := NULL;
3074: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3075: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := NULL;

Line 3073: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := NULL;

3069: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := NULL;
3070: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3071: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := NULL;
3072: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3073: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := NULL;
3074: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3075: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := NULL;
3076: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3077: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := NULL;

Line 3075: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := NULL;

3071: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := NULL;
3072: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3073: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := NULL;
3074: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3075: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := NULL;
3076: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3077: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := NULL;
3078: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3079: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := NULL;

Line 3077: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := NULL;

3073: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := NULL;
3074: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3075: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := NULL;
3076: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3077: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := NULL;
3078: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3079: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := NULL;
3080: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3081: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := NULL;

Line 3079: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := NULL;

3075: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := NULL;
3076: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3077: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := NULL;
3078: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3079: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := NULL;
3080: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3081: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := NULL;
3082: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3083: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := NULL;

Line 3081: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := NULL;

3077: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := NULL;
3078: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3079: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := NULL;
3080: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3081: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := NULL;
3082: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3083: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := NULL;
3084: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3085: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := NULL;

Line 3083: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := NULL;

3079: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := NULL;
3080: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3081: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := NULL;
3082: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3083: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := NULL;
3084: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3085: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := NULL;
3086: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3087: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := NULL;

Line 3085: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := NULL;

3081: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := NULL;
3082: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3083: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := NULL;
3084: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3085: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := NULL;
3086: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3087: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := NULL;
3088: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3089: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := NULL;

Line 3087: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := NULL;

3083: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := NULL;
3084: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3085: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := NULL;
3086: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3087: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := NULL;
3088: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3089: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := NULL;
3090: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION15' THEN
3091: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := NULL;

Line 3089: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := NULL;

3085: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := NULL;
3086: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3087: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := NULL;
3088: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3089: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := NULL;
3090: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION15' THEN
3091: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := NULL;
3092: END IF;
3093:

Line 3091: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := NULL;

3087: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := NULL;
3088: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3089: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := NULL;
3090: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION15' THEN
3091: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := NULL;
3092: END IF;
3093:
3094:
3095: EXIT;

Line 3101: l_string := 'BEGIN OKC_COPY_CONTRACT_PVT.g_rulv_rec.' ||l_col_vals(i).col_name||' := :l_tve_id_out; END;';

3097: ELSE
3098: add_timevalues(l_tve_id,l_tve_id_out);
3099:
3100: /*
3101: l_string := 'BEGIN OKC_COPY_CONTRACT_PVT.g_rulv_rec.' ||l_col_vals(i).col_name||' := :l_tve_id_out; END;';
3102: -- bug#2256693 ||to_char(l_tve_id_out)||'; END;';
3103: EXECUTE IMMEDIATE l_string USING IN l_tve_id_out;
3104: */
3105:

Line 3111: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := l_tve_id_out;

3107: -- Bug 2934909 Changed dynamic sql to static
3108: --
3109:
3110: IF l_col_vals(i).col_name = 'RULE_INFORMATION1' THEN
3111: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := l_tve_id_out;
3112: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION2' THEN
3113: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := l_tve_id_out;
3114: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3115: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := l_tve_id_out;

Line 3113: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := l_tve_id_out;

3109:
3110: IF l_col_vals(i).col_name = 'RULE_INFORMATION1' THEN
3111: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := l_tve_id_out;
3112: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION2' THEN
3113: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := l_tve_id_out;
3114: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3115: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := l_tve_id_out;
3116: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3117: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := l_tve_id_out;

Line 3115: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := l_tve_id_out;

3111: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION1 := l_tve_id_out;
3112: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION2' THEN
3113: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := l_tve_id_out;
3114: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3115: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := l_tve_id_out;
3116: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3117: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := l_tve_id_out;
3118: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3119: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := l_tve_id_out;

Line 3117: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := l_tve_id_out;

3113: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION2 := l_tve_id_out;
3114: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION3' THEN
3115: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := l_tve_id_out;
3116: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3117: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := l_tve_id_out;
3118: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3119: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := l_tve_id_out;
3120: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3121: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := l_tve_id_out;

Line 3119: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := l_tve_id_out;

3115: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION3 := l_tve_id_out;
3116: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION4' THEN
3117: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := l_tve_id_out;
3118: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3119: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := l_tve_id_out;
3120: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3121: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := l_tve_id_out;
3122: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3123: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := l_tve_id_out;

Line 3121: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := l_tve_id_out;

3117: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION4 := l_tve_id_out;
3118: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION5' THEN
3119: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := l_tve_id_out;
3120: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3121: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := l_tve_id_out;
3122: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3123: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := l_tve_id_out;
3124: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3125: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := l_tve_id_out;

Line 3123: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := l_tve_id_out;

3119: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION5 := l_tve_id_out;
3120: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION6' THEN
3121: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := l_tve_id_out;
3122: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3123: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := l_tve_id_out;
3124: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3125: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := l_tve_id_out;
3126: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3127: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := l_tve_id_out;

Line 3125: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := l_tve_id_out;

3121: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION6 := l_tve_id_out;
3122: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION7' THEN
3123: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := l_tve_id_out;
3124: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3125: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := l_tve_id_out;
3126: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3127: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := l_tve_id_out;
3128: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3129: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := l_tve_id_out;

Line 3127: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := l_tve_id_out;

3123: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION7 := l_tve_id_out;
3124: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION8' THEN
3125: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := l_tve_id_out;
3126: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3127: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := l_tve_id_out;
3128: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3129: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := l_tve_id_out;
3130: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3131: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := l_tve_id_out;

Line 3129: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := l_tve_id_out;

3125: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION8 := l_tve_id_out;
3126: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION9' THEN
3127: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := l_tve_id_out;
3128: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3129: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := l_tve_id_out;
3130: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3131: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := l_tve_id_out;
3132: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3133: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := l_tve_id_out;

Line 3131: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := l_tve_id_out;

3127: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION9 := l_tve_id_out;
3128: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION10' THEN
3129: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := l_tve_id_out;
3130: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3131: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := l_tve_id_out;
3132: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3133: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := l_tve_id_out;
3134: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3135: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := l_tve_id_out;

Line 3133: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := l_tve_id_out;

3129: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION10 := l_tve_id_out;
3130: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION11' THEN
3131: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := l_tve_id_out;
3132: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3133: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := l_tve_id_out;
3134: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3135: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := l_tve_id_out;
3136: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3137: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := l_tve_id_out;

Line 3135: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := l_tve_id_out;

3131: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION11 := l_tve_id_out;
3132: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION12' THEN
3133: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := l_tve_id_out;
3134: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3135: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := l_tve_id_out;
3136: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3137: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := l_tve_id_out;
3138: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION15' THEN
3139: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := l_tve_id_out;

Line 3137: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := l_tve_id_out;

3133: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION12 := l_tve_id_out;
3134: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION13' THEN
3135: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := l_tve_id_out;
3136: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3137: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := l_tve_id_out;
3138: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION15' THEN
3139: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := l_tve_id_out;
3140: END IF;
3141:

Line 3139: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := l_tve_id_out;

3135: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION13 := l_tve_id_out;
3136: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION14' THEN
3137: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION14 := l_tve_id_out;
3138: ELSIF l_col_vals(i).col_name = 'RULE_INFORMATION15' THEN
3139: OKC_COPY_CONTRACT_PVT.g_rulv_rec.RULE_INFORMATION15 := l_tve_id_out;
3140: END IF;
3141:
3142:
3143: EXIT WHEN (i = l_col_vals.LAST);

Line 10517: OKC_DEBUG.log('100 : Entering OKC_COPY_CONTRACT_PVT.copy_components ', 2);

10513: -- Following code is commented out for Bug#2855853.
10514:
10515: IF (l_debug = 'Y') THEN
10516: OKC_DEBUG.Set_Indentation(' copy_components ');
10517: OKC_DEBUG.log('100 : Entering OKC_COPY_CONTRACT_PVT.copy_components ', 2);
10518: OKC_DEBUG.log('l_components_tbl.COUNT : '||l_components_tbl.COUNT,2);
10519: For i IN NVL(l_components_tbl.FIRST,0)..NVL(l_components_tbl.LAST,-1)
10520: LOOP
10521: OKC_DEBUG.log('Component : '||i,2);

Line 11296: OKC_DEBUG.log('10000 : Exiting Procedure OKC_COPY_CONTRACT_PVT.copy_components ', 2);

11292: -- End
11293: -- End - Changes done for Bug 1917514
11294: END IF;
11295: IF (l_debug = 'Y') THEN
11296: OKC_DEBUG.log('10000 : Exiting Procedure OKC_COPY_CONTRACT_PVT.copy_components ', 2);
11297: OKC_DEBUG.ReSet_Indentation;
11298: END IF;
11299:
11300: EXCEPTION

Line 11303: OKC_DEBUG.log('20000 : Exiting Procedure OKC_COPY_CONTRACT_PVT.copy_components ', 2);

11299:
11300: EXCEPTION
11301: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11302: IF (l_debug = 'Y') THEN
11303: OKC_DEBUG.log('20000 : Exiting Procedure OKC_COPY_CONTRACT_PVT.copy_components ', 2);
11304: OKC_DEBUG.ReSet_Indentation;
11305: END IF;
11306: NULL;
11307: WHEN OTHERS THEN

Line 11313: OKC_DEBUG.log('30000 : Exiting Procedure OKC_COPY_CONTRACT_PVT.copy_components ', 2);

11309: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
11310: IF (l_debug = 'Y') THEN
11311: OKC_DEBUG.log('30000 : SQLCODE : '||SQLCODE);
11312: OKC_DEBUG.log('30000 : SQLERRM : '||SQLERRM);
11313: OKC_DEBUG.log('30000 : Exiting Procedure OKC_COPY_CONTRACT_PVT.copy_components ', 2);
11314: OKC_DEBUG.ReSet_Indentation;
11315: END IF;
11316: -- notify caller of an UNEXPECTED error
11317: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 12935: END OKC_COPY_CONTRACT_PVT;

12931: (G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
12932:
12933: END UPDATE_TEMPLATE_CONTRACT ;
12934:
12935: END OKC_COPY_CONTRACT_PVT;