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.23.12020000.2 2012/08/10 09:14:49 spingali 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 1547: OKC_DEBUG.Set_Indentation('OKC_COPY_CONTRACT_PVT.Copy_Articles ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 12936: END OKC_COPY_CONTRACT_PVT;

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