DBA Data[Home] [Help]

APPS.AMS_DM_SCORE_PVT dependencies on AMS_CPYUTILITY_PVT

Line 2743: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

2739: x_return_status OUT NOCOPY VARCHAR2,
2740: x_msg_count OUT NOCOPY NUMBER,
2741: x_msg_data OUT NOCOPY VARCHAR2,
2742: p_source_object_id IN NUMBER,
2743: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
2744: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
2745: x_new_object_id OUT NOCOPY NUMBER,
2746: x_custom_setup_id OUT NOCOPY NUMBER
2747: )

Line 2744: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

2740: x_msg_count OUT NOCOPY NUMBER,
2741: x_msg_data OUT NOCOPY VARCHAR2,
2742: p_source_object_id IN NUMBER,
2743: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
2744: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
2745: x_new_object_id OUT NOCOPY NUMBER,
2746: x_custom_setup_id OUT NOCOPY NUMBER
2747: )
2748: IS

Line 2811: -- use ams_cpyutility_pvt.get_column_value to fetch a value

2807: --
2808: -- Start of API body.
2809: --
2810: -- Initialize the new score record
2811: -- use ams_cpyutility_pvt.get_column_value to fetch a value
2812: -- to replace the reference column value with a new value
2813: -- passed in from the UI through p_copy_columns_table.
2814: OPEN c_score (p_source_object_id);
2815: FETCH c_score INTO l_reference_rec;

Line 2860: AMS_CpyUtility_PVT.get_column_value ('owner_user_id', p_copy_columns_table, l_score_rec.owner_user_id);

2856:
2857: -- if field is not passed in from copy_columns_table
2858: -- copy from the base object
2859: -- owner_user_id
2860: AMS_CpyUtility_PVT.get_column_value ('owner_user_id', p_copy_columns_table, l_score_rec.owner_user_id);
2861: l_score_rec.owner_user_id := NVL (l_score_rec.owner_user_id, l_reference_rec.owner_user_id);
2862: -- model_id
2863: AMS_CpyUtility_PVT.get_column_value ('model_id', p_copy_columns_table, l_score_rec.model_id);
2864: l_score_rec.model_id := NVL (l_score_rec.model_id, l_reference_rec.model_id);

Line 2863: AMS_CpyUtility_PVT.get_column_value ('model_id', p_copy_columns_table, l_score_rec.model_id);

2859: -- owner_user_id
2860: AMS_CpyUtility_PVT.get_column_value ('owner_user_id', p_copy_columns_table, l_score_rec.owner_user_id);
2861: l_score_rec.owner_user_id := NVL (l_score_rec.owner_user_id, l_reference_rec.owner_user_id);
2862: -- model_id
2863: AMS_CpyUtility_PVT.get_column_value ('model_id', p_copy_columns_table, l_score_rec.model_id);
2864: l_score_rec.model_id := NVL (l_score_rec.model_id, l_reference_rec.model_id);
2865:
2866: -- if field is not passed in from copy_columns_table
2867: -- don't copy

Line 2868: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_score_rec.score_name);

2864: l_score_rec.model_id := NVL (l_score_rec.model_id, l_reference_rec.model_id);
2865:
2866: -- if field is not passed in from copy_columns_table
2867: -- don't copy
2868: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_score_rec.score_name);
2869: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_score_rec.description);
2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);
2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);
2872: --commented rosharma 04-sep-2003 bug # 3127555

Line 2869: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_score_rec.description);

2865:
2866: -- if field is not passed in from copy_columns_table
2867: -- don't copy
2868: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_score_rec.score_name);
2869: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_score_rec.description);
2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);
2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);
2872: --commented rosharma 04-sep-2003 bug # 3127555
2873: --AMS_CpyUtility_PVT.get_column_value ('minRequested', p_copy_columns_table, l_score_rec.min_records);

Line 2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);

2866: -- if field is not passed in from copy_columns_table
2867: -- don't copy
2868: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_score_rec.score_name);
2869: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_score_rec.description);
2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);
2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);
2872: --commented rosharma 04-sep-2003 bug # 3127555
2873: --AMS_CpyUtility_PVT.get_column_value ('minRequested', p_copy_columns_table, l_score_rec.min_records);
2874: --AMS_CpyUtility_PVT.get_column_value ('maxRequested', p_copy_columns_table, l_score_rec.max_records);

Line 2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);

2867: -- don't copy
2868: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_score_rec.score_name);
2869: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_score_rec.description);
2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);
2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);
2872: --commented rosharma 04-sep-2003 bug # 3127555
2873: --AMS_CpyUtility_PVT.get_column_value ('minRequested', p_copy_columns_table, l_score_rec.min_records);
2874: --AMS_CpyUtility_PVT.get_column_value ('maxRequested', p_copy_columns_table, l_score_rec.max_records);
2875: --end comment rosharma 04-sep-2003 bug # 3127555

Line 2873: --AMS_CpyUtility_PVT.get_column_value ('minRequested', p_copy_columns_table, l_score_rec.min_records);

2869: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_score_rec.description);
2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);
2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);
2872: --commented rosharma 04-sep-2003 bug # 3127555
2873: --AMS_CpyUtility_PVT.get_column_value ('minRequested', p_copy_columns_table, l_score_rec.min_records);
2874: --AMS_CpyUtility_PVT.get_column_value ('maxRequested', p_copy_columns_table, l_score_rec.max_records);
2875: --end comment rosharma 04-sep-2003 bug # 3127555
2876:
2877: AMS_DM_Score_PVT.create_score (

Line 2874: --AMS_CpyUtility_PVT.get_column_value ('maxRequested', p_copy_columns_table, l_score_rec.max_records);

2870: --AMS_CpyUtility_PVT.get_column_value ('mainRandNthRowSel', p_copy_columns_table, l_score_rec.every_nth_row);
2871: --AMS_CpyUtility_PVT.get_column_value ('mainRandPctRowSel', p_copy_columns_table, l_score_rec.pct_random);
2872: --commented rosharma 04-sep-2003 bug # 3127555
2873: --AMS_CpyUtility_PVT.get_column_value ('minRequested', p_copy_columns_table, l_score_rec.min_records);
2874: --AMS_CpyUtility_PVT.get_column_value ('maxRequested', p_copy_columns_table, l_score_rec.max_records);
2875: --end comment rosharma 04-sep-2003 bug # 3127555
2876:
2877: AMS_DM_Score_PVT.create_score (
2878: p_api_version => 1.0,

Line 2897: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_SELC, p_attributes_table) = FND_API.G_TRUE THEN

2893: -- copy data selections
2894:
2895: -- 01-May-2003 nyostos Fixed copying of Data Selections Bug 2934000
2896: -- Used G_ATTRIBUTE_SELC instead of G_ATTRIBUTE_TRNG
2897: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_SELC, p_attributes_table) = FND_API.G_TRUE THEN
2898: --start changes rosharma 20-aug-2003 bug 3104201
2899: OPEN c_data_source (l_reference_rec.model_id);
2900: FETCH c_data_source INTO l_ds_id , l_target_id;
2901: CLOSE c_data_source;

Line 2938: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_TEAM, p_attributes_table) = FND_API.G_TRUE THEN

2934: END IF;
2935: END IF;
2936:
2937: -- copy team
2938: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_CopyElements_PVT.G_ATTRIBUTE_TEAM, p_attributes_table) = FND_API.G_TRUE THEN
2939: AMS_CopyElements_PVT.copy_act_access (
2940: p_src_act_type => G_OBJECT_TYPE_SCORE,
2941: p_new_act_type => G_OBJECT_TYPE_SCORE,
2942: p_src_act_id => p_source_object_id,