[Home] [Help]
1: PACKAGE BODY ams_dm_score_pvt as
2: /* $Header: amsvdmsb.pls 120.3 2006/07/17 12:03:25 kbasavar noship $ */
3: -- Start of Comments
4: -- Package name : AMS_DM_SCORE_PVT
5: -- Purpose : PACKAGE BODY FOR PRIVATE API
1: PACKAGE BODY ams_dm_score_pvt as
2: /* $Header: amsvdmsb.pls 120.3 2006/07/17 12:03:25 kbasavar noship $ */
3: -- Start of Comments
4: -- Package name : AMS_DM_SCORE_PVT
5: -- Purpose : PACKAGE BODY FOR PRIVATE API
6: -- History :
7: -- 20-Nov-2000 julou created
8: -- 21-Nov-2000 julou added foreign key validation and lookup validation
8: -- 21-Nov-2000 julou added foreign key validation and lookup validation
9: -- added name and description to insert_row and update_row
10: -- 18-Dec-2000 julou added validation for object_version_number in delete procedure
11: -- 23-Jan-2001 choang Changed ams_dm_models_b to ams_dm_models_all_b in uk validation.
12: -- 24-Jan-2001 choang Changed package name to AMS_DM_SCORE_PVT.
13: -- 26-Jan-2001 choang Added increment of object ver num in update api.
14: -- 29-Jan-2001 choang Removed return statement in req item validation.
15: -- 12-Feb-2001 choang 1) Changed model_score to score. 2) added new columns.
16: -- 19-Feb-2001 choang Replaced top_down_flag with row_selection_type.
80: -- NOTE :
81: -- End of Comments
82:
83:
84: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_SCORE_PVT';
85: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdmsb.pls';
86: G_DEFAULT_STATUS CONSTANT VARCHAR2(30) := 'DRAFT';
87: G_OBJECT_TYPE_SCORE CONSTANT VARCHAR2(30) := 'SCOR';
88: G_STATUS_TYPE_SCORE CONSTANT VARCHAR2(30) := 'AMS_DM_SCORE_STATUS';
397: l_api_version_number CONSTANT NUMBER := 1.0;
398:
399: l_object_version_number NUMBER := 1;
400: l_dummy NUMBER;
401: l_score_rec AMS_DM_SCORE_PVT.Score_Rec_Type := P_Score_Rec;
402:
403: l_access_rec AMS_Access_PVT.access_rec_type;
404:
405: l_model_type VARCHAR2(30);
734: L_SCORE_STATUS_SCHEDULED CONSTANT VARCHAR2(30) := 'SCHEDULED';
735:
736: -- Local Variables
737: l_object_version_number NUMBER;
738: l_tar_score_rec AMS_DM_SCORE_PVT.Score_Rec_Type := p_score_rec;
739: l_rowid ROWID;
740: l_user_timezone_name VARCHAR2(80);
741: l_user_status_id NUMBER;
742: l_monitor_url VARCHAR2(4000);
2569: ;
2570:
2571: l_ref_score_rec c_ref_score%ROWTYPE;
2572:
2573: l_tar_score_rec ams_dm_score_pvt.score_rec_type;
2574:
2575: L_API_NAME CONSTANT VARCHAR2(30) := 'handle_preview_request';
2576:
2577: BEGIN
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,
2879: p_init_msg_list => FND_API.G_FALSE,
2880: p_commit => FND_API.G_FALSE,
2881: p_validation_level => p_validation_level,
3844: END IF;
3845:
3846: END handle_data_selection_changes;
3847:
3848: END ams_dm_score_pvt;