[Home] [Help]
366: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
367: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_calling_fn VARCHAR2(20) := 'update_category';
369:
370: l_trans_rec FA_API_TYPES.trans_rec_type;
371: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
372: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
373: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
374: l_count NUMBER;
367: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_calling_fn VARCHAR2(20) := 'update_category';
369:
370: l_trans_rec FA_API_TYPES.trans_rec_type;
371: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
372: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
373: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
374: l_count NUMBER;
375: l_return_status VARCHAR2(100);
368: l_calling_fn VARCHAR2(20) := 'update_category';
369:
370: l_trans_rec FA_API_TYPES.trans_rec_type;
371: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
372: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
373: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
374: l_count NUMBER;
375: l_return_status VARCHAR2(100);
376: l_msg_count NUMBER := 0;
369:
370: l_trans_rec FA_API_TYPES.trans_rec_type;
371: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
372: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
373: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
374: l_count NUMBER;
375: l_return_status VARCHAR2(100);
376: l_msg_count NUMBER := 0;
377: l_msg_data VARCHAR2(4000);
473: l_return_status varchar2(1);
474: l_msg_count number:= 0;
475: l_msg_data varchar2(4000);
476:
477: l_trans_rec fa_api_types.trans_rec_type;
478: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
479:
480: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
481: i binary_integer;
474: l_msg_count number:= 0;
475: l_msg_data varchar2(4000);
476:
477: l_trans_rec fa_api_types.trans_rec_type;
478: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
479:
480: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
481: i binary_integer;
482: tfr_error EXCEPTION;
476:
477: l_trans_rec fa_api_types.trans_rec_type;
478: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
479:
480: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
481: i binary_integer;
482: tfr_error EXCEPTION;
483: Begin
484:
531: End;
532:
533:
534: -- ------------------------------------------
535: PROCEDURE do_adjustment( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
536: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
537: x_new_life IN NUMBER,
538: p_amortize_flag IN VARCHAR2,
539: x_err_code OUT NOCOPY VARCHAR2 ) IS
532:
533:
534: -- ------------------------------------------
535: PROCEDURE do_adjustment( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
536: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
537: x_new_life IN NUMBER,
538: p_amortize_flag IN VARCHAR2,
539: x_err_code OUT NOCOPY VARCHAR2 ) IS
540:
537: x_new_life IN NUMBER,
538: p_amortize_flag IN VARCHAR2,
539: x_err_code OUT NOCOPY VARCHAR2 ) IS
540:
541: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
542: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
538: p_amortize_flag IN VARCHAR2,
539: x_err_code OUT NOCOPY VARCHAR2 ) IS
540:
541: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
542: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
539: x_err_code OUT NOCOPY VARCHAR2 ) IS
540:
541: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
542: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
540:
541: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
542: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
541: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
542: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
542: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
550: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
543: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
550: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
551: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
544: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
550: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
551: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
552:
545: l_inv_tbl FA_API_TYPES.inv_tbl_type;
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
550: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
551: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
552:
553: l_return_status VARCHAR2(1);
546: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
550: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
551: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
552:
553: l_return_status VARCHAR2(1);
554: l_mesg_count number := 0;
547: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
548: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
549: l_inv_rec FA_API_TYPES.inv_rec_type;
550: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
551: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
552:
553: l_return_status VARCHAR2(1);
554: l_mesg_count number := 0;
555: l_mesg_len number;
654: AND batch_number <= nvl(X_to_batch_number,batch_number)
655: order by creation_date;
656: --FOR UPDATE NOWAIT;
657:
658: l_trans_rec FA_API_TYPES.trans_rec_type;
659:
660: BEGIN
661:
662: retcode := '0';
788: -- Set to Rejected and changes for accepted assets is rolled back
789: -- as if they had not been processed at all
790: -- -------------------------------------------------------------
791:
792: PROCEDURE process_batch( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
793: p_batch_id IN NUMBER ,
794: p_amortize_flag IN VARCHAR2 ) IS
795: l_asset_id number;
796: l_book varchar2(15);
976:
977: End;
978:
979:
980: PROCEDURE process_asset( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
981: p_batch_id IN NUMBER,
982: p_asset_id IN NUMBER,
983: p_book IN VARCHAR2,
984: p_amortize_flag IN VARCHAR2,
1028: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1029: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1030: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1031:
1032: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1033: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1034: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1029: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1030: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1031:
1032: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1033: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1034: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1037: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1030: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1031:
1032: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1033: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1034: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1037: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1038: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1032: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1033: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1034: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1037: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1038: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1039: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1040:
1033: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1034: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1037: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1038: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1039: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1040:
1041: -- Adjustment parameters
1034: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1037: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1038: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1039: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1040:
1041: -- Adjustment parameters
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1035:
1036: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1037: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1038: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1039: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1040:
1041: -- Adjustment parameters
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1038: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1039: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1040:
1041: -- Adjustment parameters
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1039: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1040:
1041: -- Adjustment parameters
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1040:
1041: -- Adjustment parameters
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1041: -- Adjustment parameters
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1042: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1043: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1051: l_inv_rec FA_API_TYPES.inv_rec_type;
1044: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1051: l_inv_rec FA_API_TYPES.inv_rec_type;
1052: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1045: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1051: l_inv_rec FA_API_TYPES.inv_rec_type;
1052: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1053:
1046: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1051: l_inv_rec FA_API_TYPES.inv_rec_type;
1052: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1053:
1054: l_request_id number(15);
1047: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1051: l_inv_rec FA_API_TYPES.inv_rec_type;
1052: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1053:
1054: l_request_id number(15);
1055:
1048: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1049: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1050: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1051: l_inv_rec FA_API_TYPES.inv_rec_type;
1052: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1053:
1054: l_request_id number(15);
1055:
1056: l_update_attribute varchar2(1):= 'N';