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.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_EXT_FWK_PUB

Line 454: IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE

450: l_err_token_table.DELETE();
451: END IF;
452:
453: IF BITAND(error_rec.PROCESS_STATUS,G_PS_VALUE_NOT_IN_VS) <> 0 THEN
454: IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE
455: OR
456: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
457: OR
458: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE

Line 456: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE

452:
453: IF BITAND(error_rec.PROCESS_STATUS,G_PS_VALUE_NOT_IN_VS) <> 0 THEN
454: IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE
455: OR
456: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
457: OR
458: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE
459: ) THEN
460: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';

Line 458: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE

454: IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE
455: OR
456: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
457: OR
458: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE
459: ) THEN
460: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';
461: l_err_token_table(1).TOKEN_NAME := 'VALUE';
462: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

Line 462: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

458: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE
459: ) THEN
460: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';
461: l_err_token_table(1).TOKEN_NAME := 'VALUE';
462: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
463: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
464: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
465: OR
466: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

Line 464: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

460: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';
461: l_err_token_table(1).TOKEN_NAME := 'VALUE';
462: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
463: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
464: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
465: OR
466: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
467: ) THEN
468: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_date);

Line 466: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

462: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
463: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
464: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
465: OR
466: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
467: ) THEN
468: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_date);
469: ELSE
470: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_str);

Line 497: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

493: l_err_token_table(1).TOKEN_NAME := 'ATTR_NAME';
494: l_err_token_table(1).TOKEN_VALUE := l_attr_metadata_obj.attr_disp_name;
495: l_err_token_table(2).TOKEN_NAME := 'AG_NAME';
496: l_err_token_table(2).TOKEN_VALUE := l_attr_grp_disp_name;
497: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
498: l_err_msg_name := 'EGO_EF_MIN_VAL_NUM_VIOLATED';
499: l_err_token_table(3).TOKEN_NAME := 'MIN_NUM_VALUE';
500: l_err_token_table(3).TOKEN_VALUE := l_attr_metadata_obj.MINIMUM_VALUE;
501: ELSE

Line 526: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

522: l_err_token_table(1).TOKEN_NAME := 'ATTR_NAME';
523: l_err_token_table(1).TOKEN_VALUE := l_attr_metadata_obj.attr_disp_name;
524: l_err_token_table(2).TOKEN_NAME := 'AG_NAME';
525: l_err_token_table(2).TOKEN_VALUE := l_attr_grp_disp_name;
526: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
527: l_err_msg_name := 'EGO_EF_MAX_VAL_NUM_VIOLATED';
528: l_err_token_table(3).TOKEN_NAME := 'MAX_NUM_VALUE';
529: l_err_token_table(3).TOKEN_VALUE := l_attr_metadata_obj.MAXIMUM_VALUE;
530: ELSE

Line 654: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

650:
651: IF BITAND(error_rec.PROCESS_STATUS,G_PS_MAX_LENGTH_VIOLATION) <> 0 THEN
652: l_err_msg_name := 'EGO_EF_MAX_SIZE_VIOLATED';
653: l_err_token_table(1).TOKEN_NAME := 'VALUE';
654: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
655: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
656: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
657: OR
658: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

Line 656: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

652: l_err_msg_name := 'EGO_EF_MAX_SIZE_VIOLATED';
653: l_err_token_table(1).TOKEN_NAME := 'VALUE';
654: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
655: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
656: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
657: OR
658: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
659: ) THEN
660: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_date);

Line 658: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

654: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
655: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
656: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
657: OR
658: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
659: ) THEN
660: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_date);
661: ELSE
662: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_str);

Line 794: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_name, error_rec.class_code_value)

790: l_err_token_table(1).TOKEN_NAME := 'AG_NAME';
791: l_err_token_table(1).TOKEN_VALUE := l_attr_grp_disp_name;
792: l_err_token_table(2).TOKEN_NAME := 'CLASS_MEANING';
793: BEGIN
794: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_name, error_rec.class_code_value)
795: INTO l_err_token_table(2).TOKEN_VALUE
796: FROM DUAL;
797: EXCEPTION
798: WHEN OTHERS THEN

Line 920: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

916: l_err_token_table.DELETE();
917: END IF;
918:
919: IF BITAND(error_rec.PROCESS_STATUS,G_PS_DATA_IN_WRONG_COL) <> 0 THEN
920: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
921: l_err_msg_name := 'EGO_EF_NUM_IN_WRONG_COL';
922: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
923: OR
924: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

Line 922: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

918:
919: IF BITAND(error_rec.PROCESS_STATUS,G_PS_DATA_IN_WRONG_COL) <> 0 THEN
920: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
921: l_err_msg_name := 'EGO_EF_NUM_IN_WRONG_COL';
922: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
923: OR
924: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
925: ) THEN
926: l_err_msg_name := 'EGO_EF_DATE_IN_WRONG_COL';

Line 924: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

920: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
921: l_err_msg_name := 'EGO_EF_NUM_IN_WRONG_COL';
922: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
923: OR
924: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
925: ) THEN
926: l_err_msg_name := 'EGO_EF_DATE_IN_WRONG_COL';
927: ELSE
928: l_err_msg_name := 'EGO_EF_CHAR_IN_WRONG_COL';

Line 951: -- IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE

947: END IF;
948:
949: IF BITAND(error_rec.PROCESS_STATUS,G_PS_VALUE_NOT_IN_TVS) <> 0 THEN
950: -- this condition is not required
951: -- IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE
952: -- OR
953: -- l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE
954: -- ) THEN
955: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';

Line 953: -- l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE

949: IF BITAND(error_rec.PROCESS_STATUS,G_PS_VALUE_NOT_IN_TVS) <> 0 THEN
950: -- this condition is not required
951: -- IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE
952: -- OR
953: -- l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE
954: -- ) THEN
955: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';
956: l_err_token_table(1).TOKEN_NAME := 'VALUE';
957: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

Line 957: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

953: -- l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE
954: -- ) THEN
955: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';
956: l_err_token_table(1).TOKEN_NAME := 'VALUE';
957: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
958: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
959: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
960: OR
961: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

Line 959: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

955: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';
956: l_err_token_table(1).TOKEN_NAME := 'VALUE';
957: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
958: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
959: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
960: OR
961: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
962: ) THEN
963: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_date);

Line 961: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

957: IF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
958: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_num);
959: ELSIF (l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
960: OR
961: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
962: ) THEN
963: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_date);
964: ELSE
965: l_err_token_table(1).TOKEN_VALUE := NVL(error_rec.ATTR_DISP_VALUE,error_rec.attr_value_str);

Line 2865: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

2861: EXECUTE IMMEDIATE 'SELECT TO_CHAR('||G_NULL_DATE_VAL||','''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), TO_CHAR('||G_NULL_DATE_VAL||', ''SYYYY-MM-DD'') FROM DUAL '
2862: INTO l_null_date_time_value,l_null_date_value;
2863:
2864: l_dynamic_sql := 'UPDATE '||p_interface_table_name||' SET ';
2865: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2866: l_dynamic_sql := l_dynamic_sql ||' ATTR_VALUE_NUM = DECODE(ATTR_DISP_VALUE, '''||G_NULL_NUM_VAL_STR||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_VALUE_NUM) '||
2867: ' ,ATTR_DISP_VALUE = DECODE(ATTR_DISP_VALUE, '''||G_NULL_NUM_VAL_STR||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_DISP_VALUE) '||
2868: ' ,PROCESS_STATUS = PROCESS_STATUS + DECODE (ATTR_DISP_VALUE,'''||G_NULL_NUM_VAL_STR||''', 0 , '''||G_NULL_CHAR_VAL||''', 0 , '||
2869: ' NULL, 0 , '||G_PS_INVALID_NUMBER_DATA||' )'||

Line 2886: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

2882: USING p_data_set_id, l_attr_metadata_rec.ATTR_INT_NAME, l_attr_metadata_rec.ATTR_GROUP_INT_NAME,
2883: p_attr_group_type, TO_NUMBER(G_NULL_NUM_VAL_STR),--bugFix:5297926
2884: G_NULL_NUM_VAL_STR , G_NULL_NUM_VAL, G_NULL_DATE_VAL,l_null_date_time_value, G_NULL_CHAR_VAL;
2885:
2886: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
2887: OR l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2888: l_dynamic_sql := l_dynamic_sql ||' ATTR_VALUE_DATE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL,'||
2889: ' '''||l_null_date_value||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_VALUE_DATE) '||
2890: ' ,ATTR_DISP_VALUE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL, '||

Line 2887: OR l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

2883: p_attr_group_type, TO_NUMBER(G_NULL_NUM_VAL_STR),--bugFix:5297926
2884: G_NULL_NUM_VAL_STR , G_NULL_NUM_VAL, G_NULL_DATE_VAL,l_null_date_time_value, G_NULL_CHAR_VAL;
2885:
2886: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
2887: OR l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2888: l_dynamic_sql := l_dynamic_sql ||' ATTR_VALUE_DATE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL,'||
2889: ' '''||l_null_date_value||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_VALUE_DATE) '||
2890: ' ,ATTR_DISP_VALUE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL, '||
2891: ' '''||l_null_date_value||''',NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_DISP_VALUE) '||

Line 2992: (EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE, EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)

2988:
2989:
2990: -- 4043670 added for trans independent type value sets as well
2991: IF (l_attr_metadata_rec.VALIDATION_TYPE IN
2992: (EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE, EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)
2993: ) THEN
2994:
2995: code_debug(' This attribute has an indipendednt value set, validating for value set id -'||l_attr_metadata_rec.VALUE_SET_ID ,2);
2996:

Line 2997: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

2993: ) THEN
2994:
2995: code_debug(' This attribute has an indipendednt value set, validating for value set id -'||l_attr_metadata_rec.VALUE_SET_ID ,2);
2996:
2997: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2998: IF (l_ivs_num_cursor_id IS NULL) THEN
2999: l_ivs_num_cursor_id := DBMS_SQL.Open_Cursor;
3000: l_dynamic_sql :=
3001: 'UPDATE '||p_interface_table_name||'

Line 3054: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

3050: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec.ATTR_INT_NAME);
3051: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec.ATTR_GROUP_INT_NAME);
3052: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);
3053:
3054: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3055: IF (l_ivs_date_cursor_id IS NULL) THEN
3056:
3057: l_ivs_date_cursor_id := DBMS_SQL.Open_Cursor;
3058: l_dynamic_sql :=

Line 3112: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3108: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec.ATTR_INT_NAME);
3109: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec.ATTR_GROUP_INT_NAME);
3110: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);
3111:
3112: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3113:
3114: IF (l_ivs_date_time_cursor_id IS NULL) THEN
3115:
3116: l_ivs_date_time_cursor_id := DBMS_SQL.Open_Cursor;

Line 3235: ELSIF (l_attr_metadata_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

3231: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec.ATTR_GROUP_INT_NAME);
3232: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);
3233:
3234: END IF;
3235: ELSIF (l_attr_metadata_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
3236:
3237: ------------------------------------------------------------------------------------
3238: -- HERE WE UPDATE THE INTERFACE TABLE SETTING THE ATTR_VAL_(NUM/STR/DATE) COLUMNS --
3239: -- WITH VALUES FETCHED FROM THE TABLE FOR THE VALUE ENTERED AS DISPLAY VALUE i.e. --

Line 3254: -- ='N' (i.e., EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE) --

3250: code_debug(' This attribute has a none value set, validating for before populating the attr_Value* columns from attr_disp_value column' ,2);
3251: ------------------------------------------------------------------------------------
3252: -- HERE WE UPDATE THE INTERFACE TABLE SETTING THE ATTR_VAL_(NUM/STR/DATE) COLUMNS --
3253: -- FROM ATTR_DISP_VALUE FOR ATTRS WITHOUT ANY VALUE SET *OR* WITH VALIDATION TYPE --
3254: -- ='N' (i.e., EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE) --
3255: -- WE ALSO DO THE MAX/MIN VALIDATION IN THIS SEGMENT --
3256: ------------------------------------------------------------------------------------
3257: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3258:

Line 3257: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

3253: -- FROM ATTR_DISP_VALUE FOR ATTRS WITHOUT ANY VALUE SET *OR* WITH VALIDATION TYPE --
3254: -- ='N' (i.e., EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE) --
3255: -- WE ALSO DO THE MAX/MIN VALIDATION IN THIS SEGMENT --
3256: ------------------------------------------------------------------------------------
3257: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3258:
3259: IF (l_nvs_num_cursor_id is NULL) THEN
3260: l_nvs_num_cursor_id := DBMS_SQL.Open_Cursor;
3261: l_dynamic_sql :=

Line 3291: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

3287: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec.ATTR_GROUP_INT_NAME);
3288:
3289: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);
3290:
3291: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3292:
3293: IF (l_nvs_date_cursor_id IS NULL) THEN
3294: l_nvs_date_cursor_id := DBMS_SQL.Open_Cursor;
3295: l_dynamic_sql :=

Line 3320: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3316: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec.MINIMUM_VALUE);
3317: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec.MAXIMUM_VALUE);
3318: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);
3319:
3320: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3321:
3322: IF (l_nvs_datetime_cursor_id is NULL) THEN
3323: l_nvs_datetime_cursor_id := DBMS_SQL.Open_Cursor;
3324: l_dynamic_sql :=

Line 3387: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

3383:
3384: code_debug(' This attribute has a maximum size of '||l_attr_metadata_rec.MAXIMUM_SIZE,2);
3385:
3386: --------- FOR NUMBER DATATYPE
3387: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3388: IF (l_max_size_num_cursor IS NULL) THEN
3389: l_max_size_num_cursor := DBMS_SQL.Open_Cursor;
3390: l_dynamic_sql :=
3391: 'UPDATE '||p_interface_table_name||'

Line 3410: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

3406: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec.ATTR_INT_NAME);
3407: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec.MAXIMUM_SIZE);
3408: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3409: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3410: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3411: l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3412:
3413: IF ( l_max_size_char_cursor IS NULL) THEN
3414: l_max_size_char_cursor := DBMS_SQL.Open_Cursor;

Line 3411: l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

3407: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec.MAXIMUM_SIZE);
3408: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3409: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3410: ELSIF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3411: l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3412:
3413: IF ( l_max_size_char_cursor IS NULL) THEN
3414: l_max_size_char_cursor := DBMS_SQL.Open_Cursor;
3415: l_dynamic_sql :=

Line 3447: IF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

3443:
3444: code_debug(' Before validating the rows for data in wrong column ' ,2);
3445:
3446: --------- FOR NUMBER DATATYPE
3447: IF(l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3448: IF (l_colcheck_num_cursor_id IS NULL) THEN
3449: l_colcheck_num_cursor_id := DBMS_SQL.Open_Cursor;
3450: l_dynamic_sql :=
3451: 'UPDATE '||p_interface_table_name||'

Line 3471: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3467:
3468: l_dummy := DBMS_SQL.Execute(l_colcheck_num_cursor_id);
3469:
3470: --------- FOR DATE/DATETIME DATATYPE
3471: ELSIF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3472: IF (l_colcheck_date_cursor_id IS NULL) THEN
3473: l_colcheck_date_cursor_id := DBMS_SQL.Open_Cursor;
3474: l_dynamic_sql :=
3475: 'UPDATE '||p_interface_table_name||'

Line 3677: --IF ( l_attr_metadata_table(i).DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR 1=1) THEN

3673: FOR i IN l_attr_metadata_table.FIRST .. l_attr_metadata_table.LAST
3674: LOOP
3675: IF (l_attr_metadata_table(i).UNIQUE_KEY_FLAG = 'Y' ) THEN
3676:
3677: --IF ( l_attr_metadata_table(i).DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR 1=1) THEN
3678: --GNANDA : Since now we are supporting TL UK's we do not need to error out the AG rows with
3679: --TL attrs as UK's in them.
3680: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
3681: l_intf_column_name := ' ATTR_VALUE_NUM ';

Line 3680: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN

3676:
3677: --IF ( l_attr_metadata_table(i).DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR 1=1) THEN
3678: --GNANDA : Since now we are supporting TL UK's we do not need to error out the AG rows with
3679: --TL attrs as UK's in them.
3680: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
3681: l_intf_column_name := ' ATTR_VALUE_NUM ';
3682: wierd_constant := G_NULL_TOKEN_NUM;
3683: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
3684: l_intf_column_name := ' ATTR_VALUE_DATE ';

Line 3683: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN

3679: --TL attrs as UK's in them.
3680: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
3681: l_intf_column_name := ' ATTR_VALUE_NUM ';
3682: wierd_constant := G_NULL_TOKEN_NUM;
3683: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
3684: l_intf_column_name := ' ATTR_VALUE_DATE ';
3685: wierd_constant := G_NULL_TOKEN_DATE;
3686: ELSE
3687: l_intf_column_name := ' ATTR_VALUE_STR ';

Line 3849: IF (l_attr_metadata_table(y).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

3845: END IF;
3846:
3847: l_tvs_where_clause := ' ';
3848: IF (l_attr_exists_in_intf = 'EXISTS') THEN --WE DO THE TVC VALIDATION FOR SRAG ONLY IF THIS ATTR HAS ATLEAST ONE VALID INSTANCE IN THE INTF TABLE
3849: IF (l_attr_metadata_table(y).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
3850:
3851: code_debug(' The attribute '||l_attr_metadata_table(y).ATTR_NAME||' has a table value set attached with value set id :'||l_attr_metadata_table(y).VALUE_SET_ID ,2);
3852:
3853: SELECT APPLICATION_TABLE_NAME,

Line 3945: IF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

3941: l_value_from_ext_table := ' (SELECT '|| l_ext_attr_col_name ||'
3942: FROM '||l_ext_table_select||'
3943: AND ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID) ';
3944:
3945: IF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3946: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
3947: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
3948: AND DATA_SET_ID = '||p_data_set_id||'
3949: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

Line 3950: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

3946: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
3947: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
3948: AND DATA_SET_ID = '||p_data_set_id||'
3949: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';
3950: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3951: l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3952: l_value_from_intftbl := '(SELECT ATTR_VALUE_DATE FROM '||p_interface_table_name||'
3953: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
3954: AND DATA_SET_ID = '||p_data_set_id||'

Line 3951: l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3947: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
3948: AND DATA_SET_ID = '||p_data_set_id||'
3949: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';
3950: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3951: l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3952: l_value_from_intftbl := '(SELECT ATTR_VALUE_DATE FROM '||p_interface_table_name||'
3953: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
3954: AND DATA_SET_ID = '||p_data_set_id||'
3955: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

Line 4040: IF (l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

4036: the meanin col is of type character.
4037: another assumtion is that the user cannot enter the value directly in to the attr_val_* col
4038: he has to enter the data in attr_disp_Value column for which we get the actual attr val.
4039: */
4040: IF (l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4041:
4042: l_dynamic_sql_1 :=
4043: 'UPDATE '||p_interface_table_name||' UAI1
4044: SET PROCESS_STATUS = PROCESS_STATUS + DECODE(('||l_tvs_num_val_check_select||'),0,'||G_PS_VALUE_NOT_IN_TVS||',0)

Line 4090: ELSIF (l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

4086: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table(y).ATTR_NAME);
4087: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4088: END;
4089:
4090: ELSIF (l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4091:
4092: l_dynamic_sql_1 :=
4093: 'UPDATE '||p_interface_table_name||' UAI1
4094: SET PROCESS_STATUS = PROCESS_STATUS + DECODE(('||l_tvs_date_val_check_select||'),0,'||G_PS_VALUE_NOT_IN_TVS||',0)

Line 4281: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

4277: l_attr_metadata_table_1(z).REQUIRED_FLAG = 'Y' AND p_do_req_def_valiadtion) THEN
4278:
4279: code_debug(' Attribute '||l_attr_metadata_table_1(z).ATTR_NAME|| ' has a default value or is a required attribute' ,2);
4280: --------- FOR NUMBER DATATYPE
4281: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4282: IF (l_default_num_cursor_id IS NULL) THEN
4283: l_default_num_cursor_id := DBMS_SQL.Open_Cursor;
4284: l_dynamic_sql :=
4285: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,

Line 4330: ELSIF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

4326: l_dist_attrs_in_data_set_table(l_dist_attrs_in_data_set_table.COUNT+1) := l_dist_attr_in_data_set_rec;
4327: END IF;
4328:
4329: --------- FOR DATE DATATYPE
4330: ELSIF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4331: l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4332: IF (l_default_date_cursor_id IS NULL) THEN
4333: l_default_date_cursor_id := DBMS_SQL.Open_Cursor;
4334: l_dynamic_sql :=

Line 4331: l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

4327: END IF;
4328:
4329: --------- FOR DATE DATATYPE
4330: ELSIF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4331: l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4332: IF (l_default_date_cursor_id IS NULL) THEN
4333: l_default_date_cursor_id := DBMS_SQL.Open_Cursor;
4334: l_dynamic_sql :=
4335: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,

Line 4446: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

4442:
4443: code_debug(' Attribute '||l_attr_metadata_table_1(z).ATTR_NAME|| ' is a required attribute' ,2);
4444:
4445: --------- FOR NUMBER DATATYPE
4446: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4447: IF (l_req_num_cursor_id IS NULL) THEN
4448: l_req_num_cursor_id := DBMS_SQL.Open_Cursor;
4449: l_dynamic_sql :=
4450: 'UPDATE '||p_interface_table_name||'

Line 4469: ELSIF (l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

4465:
4466: l_dummy := DBMS_SQL.Execute(l_req_num_cursor_id);
4467:
4468: --------- FOR DATE AND DATE TIME DATATYPE
4469: ELSIF (l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4470: IF (l_req_date_cursor_id IS NULL) THEN
4471: l_req_date_cursor_id := DBMS_SQL.Open_Cursor;
4472: l_dynamic_sql :=
4473: 'UPDATE '||p_interface_table_name||'

Line 4542: IF (l_attr_metadata_table_sr(x).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

4538: END IF;
4539:
4540: --WE DO THE TVC VALIDATION FOR SRAG ONLY IF THIS ATTR HAS ATLEAST ONE VALID INSTANCE IN THE INTF TABLE
4541: IF (l_attr_exists_in_intf = 'EXISTS') THEN
4542: IF (l_attr_metadata_table_sr(x).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
4543:
4544: code_debug(' The attribute :'||l_attr_metadata_table_sr(x).ATTR_NAME||' has a table value set attached to it with value set id :'||l_attr_metadata_table_sr(x).VALUE_SET_ID ,2);
4545:
4546: SELECT APPLICATION_TABLE_NAME,

Line 4660: IF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

4656: l_value_from_ext_table := l_value_from_ext_table || ' AND NVL('||l_data_level_column_2||',-1) = NVL(UAI1.'||l_data_level_column_2||',-1)';
4657: l_value_from_ext_table := l_value_from_ext_table || ' AND NVL('||l_data_level_column_3||',-1) = NVL(UAI1.'||l_data_level_column_3||',-1)';
4658: END IF;
4659:
4660: IF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4661: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
4662: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4663: AND DATA_SET_ID = :data_set_id
4664: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

Line 4665: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

4661: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
4662: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4663: AND DATA_SET_ID = :data_set_id
4664: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';
4665: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4666: l_value_from_intftbl := '(SELECT ATTR_VALUE_DATE FROM '||p_interface_table_name||'
4667: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4668: AND DATA_SET_ID = :data_set_id
4669: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

Line 4750: IF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

4746: the meanin col is of type character.
4747: another assumtion is that the user cannot enter the value directly in to the attr_val_* col
4748: he has to enter the data in attr_disp_Value column for which we get the actual attr val.
4749: */
4750: IF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4751:
4752: l_dynamic_sql_1 :=
4753: 'UPDATE '||p_interface_table_name||' UAI1
4754: SET PROCESS_STATUS = PROCESS_STATUS + DECODE(('||l_tvs_num_val_check_select||'),0,'||G_PS_VALUE_NOT_IN_TVS||',0)

Line 4812: ELSIF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

4808: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
4809: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4810: END;
4811:
4812: ELSIF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4813:
4814: l_dynamic_sql_1 :=
4815: 'UPDATE '||p_interface_table_name||' UAI1
4816: SET PROCESS_STATUS = PROCESS_STATUS + DECODE(('||l_tvs_date_val_check_select||'),0,'||G_PS_VALUE_NOT_IN_TVS||',0)

Line 5169: if l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE then

5165: l_defaltening_sql_create := ' ';
5166: FOR i IN l_attr_metadata_table.FIRST .. l_attr_metadata_table.LAST
5167: LOOP
5168: -- abedajna begin
5169: if l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE then
5170: l_correct_date_time_sql_uai := 'to_char(UAI1.ATTR_VALUE_DATE , '||''''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT ||''')';
5171: l_correct_date_time_sql_extvl := 'to_char(EXTVL1.'||l_attr_metadata_table(i).DATABASE_COLUMN||', '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT ||''')';
5172: else
5173: l_correct_date_time_sql_uai := 'UAI1.ATTR_VALUE_DATE';

Line 5915: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

5911: -------------------------------------------------------
5912: -- lets get ready with the correct wierd constant --
5913: -------------------------------------------------------
5914:
5915: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5916: wierd_constant := G_NULL_TOKEN_NUM;
5917: wierd_constant_2 := '8.88E125';
5918: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
5919: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN

Line 5918: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

5914:
5915: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5916: wierd_constant := G_NULL_TOKEN_NUM;
5917: wierd_constant_2 := '8.88E125';
5918: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
5919: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
5920: wierd_constant := G_NULL_TOKEN_DATE;
5921: wierd_constant_2 := 'TO_DATE(''2'',''J'')';
5922: ELSE

Line 5919: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN

5915: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5916: wierd_constant := G_NULL_TOKEN_NUM;
5917: wierd_constant_2 := '8.88E125';
5918: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
5919: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
5920: wierd_constant := G_NULL_TOKEN_DATE;
5921: wierd_constant_2 := 'TO_DATE(''2'',''J'')';
5922: ELSE
5923: wierd_constant := G_NULL_TOKEN_STR;

Line 5932: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

5928: -- UK clause (note that we only update non-UK Attrs) --
5929: -------------------------------------------------------
5930: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG = 'Y') THEN
5931:
5932: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5933: --GNANDA: While inserting rows in the TL table for a case where we have a TL Uk we insert rows for
5934: --all the rows int he B table for the given pk's and uk's which do not have a corresponding rows in the TL table.
5935:
5936: --While checking for identical rows in the data_set there is a self join in RTCQ (RTCQ and EXT), contrary to the DML's

Line 5976: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

5972: ---------------------------------
5973: -- Data type-dependent clauses --
5974: ---------------------------------
5975: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
5976: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5977:
5978: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
5979: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_NUM,'||wierd_constant||',NULL,ATTR_VALUE_NUM), ATTR_VALUE_NUM)';
5980: -- ...this closes what started above

Line 6039: EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

6035: END IF;
6036: END IF;
6037:
6038: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6039: EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
6040: l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6041: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
6042:
6043: --Bug 4473391(gnanda) : we need to convert the attr_value_date to char in the decode and then convert the final value into

Line 6041: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

6037:
6038: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6039: EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
6040: l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6041: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
6042:
6043: --Bug 4473391(gnanda) : we need to convert the attr_value_date to char in the decode and then convert the final value into
6044: --date otherwise decode would remove the time part from date time attribute.
6045: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||

Line 6089: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

6085: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
6086: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN
6087:
6088: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6089: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
6090:
6091: l_db_col_tbl_set_tl_attrs := l_db_col_tbl_set_tl_attrs||
6092: ',EXT.'||
6093: l_attr_metadata_table_sr(d).DATABASE_COLUMN||

Line 6118: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

6114: ----------------------
6115: -- B vs. TL clauses --
6116: ----------------------
6117: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6118: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
6119:
6120: l_rtcq_alias_tl_cols_list := l_rtcq_alias_tl_cols_list||',RTCQ.'||
6121: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6122: l_rtcq_alias_tl_cols_list_1 := l_rtcq_alias_tl_cols_list_1||',DECODE(INTF_TL.COLUMN_NAME, '''||l_attr_metadata_table_sr(d).ATTR_NAME||''' ,'

Line 6148: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

6144: l_rtcq_alias_b_cols_list := l_rtcq_alias_b_cols_list||',RTCQ.'||
6145: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6146:
6147: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6148: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6149: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
6150: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6151: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN

Line 6151: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR

6147: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
6148: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6149: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
6150: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6151: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
6153: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
6154: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6155: ELSE

Line 6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN

6148: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6149: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
6150: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6151: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
6152: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
6153: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
6154: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6155: ELSE
6156: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR_1||' '

Line 7685: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

7681: ----------------------------------------------------------------------
7682: -- Add SELECT list attributes that are specific to NUMBER type --
7683: ----------------------------------------------------------------------
7684:
7685: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7686: l_template_table_RTCQ := l_template_table_RTCQ ||
7687: ', MAX(DECODE(TEMPL.ATTRIBUTE_ID '||
7688: ','||TO_CHAR(l_attr_metadata_table(i).ATTR_ID)||
7689: ','||'TEMPL.ATTRIBUTE_NUMBER_VALUE'||

Line 7721: ELSIF ( l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

7717: ----------------------------------------------------------------------
7718: -- Add SELECT list attributes that are specific to DATE TIME type --
7719: ----------------------------------------------------------------------
7720:
7721: ELSIF ( l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
7722: OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
7723: l_template_table_RTCQ := l_template_table_RTCQ ||
7724: ', MAX(DECODE(TEMPL.ATTRIBUTE_ID '||
7725: ','||TO_CHAR(l_attr_metadata_table(i).ATTR_ID)||

Line 7722: OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

7718: -- Add SELECT list attributes that are specific to DATE TIME type --
7719: ----------------------------------------------------------------------
7720:
7721: ELSIF ( l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
7722: OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
7723: l_template_table_RTCQ := l_template_table_RTCQ ||
7724: ', MAX(DECODE(TEMPL.ATTRIBUTE_ID '||
7725: ','||TO_CHAR(l_attr_metadata_table(i).ATTR_ID)||
7726: ','||'TEMPL.ATTRIBUTE_DATE_VALUE'||

Line 8021: IF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN

8017: l_dynamic_sql VARCHAR2(200);
8018: l_formated_String VARCHAR2(500);
8019: BEGIN
8020:
8021: IF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
8022: l_error_code := G_PS_INVALID_DATE_DATA ;
8023: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
8024: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
8025: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||

Line 8033: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

8029: ELSE
8030: l_date_value := TO_DATE(p_value_to_convert, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
8031: END IF;
8032:
8033: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
8034: l_error_code := G_PS_INVALID_DATE_TIME_DATA ;
8035: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
8036: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
8037: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||

Line 8045: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

8041: ELSE
8042: l_date_value := TO_DATE(p_value_to_convert,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
8043: END IF;
8044:
8045: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
8046: l_error_code := G_PS_INVALID_NUMBER_DATA ;
8047: l_num_value := TO_NUMBER(p_value_to_convert);
8048: END IF;
8049:

Line 8121: IF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR p_datatype = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

8117: the conversion of max min date fails since the format they are in is 2004-07-01 00:00:00.0
8118: this is the format in which the date string we get from the Value set, since this format
8119: for date is not supported in 8i I
8120: */
8121: IF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR p_datatype = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
8122:
8123: IF (INSTR(p_value_to_check,'$SYSDATE$') > 0 ) THEN
8124: l_formated_string := TRIM(REPLACE(p_value_to_check, '$'));
8125: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||

Line 8172: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN

8168: IF ( l_date_value < NVL(l_min_date, l_date_value) ) THEN
8169: RETURN G_PS_MIN_VAL_VIOLATION;
8170: END IF;
8171:
8172: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
8173: l_num_value := TO_NUMBER(p_value_to_check);
8174:
8175: IF (l_num_value > NVL(TO_NUMBER(p_max_value), l_num_value) ) THEN
8176: IF p_min_value IS NULL THEN

Line 8599: ' ,TO_NUMBER(DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE||''' '||--ATTR_VALUE_NUM

8595: ' ,:request_id '|| --REQUEST_ID
8596: ' ,:max_row_id + ROW_ID '|| --ROW_IDENTIFIER
8597: ' ,ATTR_TBL.DESCRIPTIVE_FLEX_CONTEXT_CODE '|| --ATTR_GROUP_INT_NAME
8598: ' ,ATTR_TBL.END_USER_COLUMN_NAME '|| --ATTR_INT_NAME
8599: ' ,TO_NUMBER(DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE||''' '||--ATTR_VALUE_NUM
8600: ' ,ATTR_TBL.DEFAULT_VALUE '||
8601: ' ,NULL)) '||
8602: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR
8603: ' ,ATTR_TBL.DEFAULT_VALUE '||

Line 8602: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR

8598: ' ,ATTR_TBL.END_USER_COLUMN_NAME '|| --ATTR_INT_NAME
8599: ' ,TO_NUMBER(DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE||''' '||--ATTR_VALUE_NUM
8600: ' ,ATTR_TBL.DEFAULT_VALUE '||
8601: ' ,NULL)) '||
8602: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR
8603: ' ,ATTR_TBL.DEFAULT_VALUE '||
8604: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
8605: ' ,ATTR_TBL.DEFAULT_VALUE '||
8606: ' ,NULL) '||

Line 8604: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||

8600: ' ,ATTR_TBL.DEFAULT_VALUE '||
8601: ' ,NULL)) '||
8602: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR
8603: ' ,ATTR_TBL.DEFAULT_VALUE '||
8604: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
8605: ' ,ATTR_TBL.DEFAULT_VALUE '||
8606: ' ,NULL) '||
8607: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
8608: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||

Line 8607: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE

8603: ' ,ATTR_TBL.DEFAULT_VALUE '||
8604: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
8605: ' ,ATTR_TBL.DEFAULT_VALUE '||
8606: ' ,NULL) '||
8607: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
8608: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8609: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
8610: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8611: ' ,NULL) ';

Line 8609: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||

8605: ' ,ATTR_TBL.DEFAULT_VALUE '||
8606: ' ,NULL) '||
8607: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
8608: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8609: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
8610: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
8611: ' ,NULL) ';
8612:
8613: l_dynamic_sql := l_dynamic_sql || l_pk_cc_select_list;

Line 9157: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

9153:
9154: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND l_attr_metadata_table(i).UNIQUE_KEY_FLAG = 'Y') THEN
9155:
9156: l_uk_attr_list := l_uk_attr_list||' '''||l_attr_metadata_table(i).ATTR_NAME||''', ';
9157: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
9158:
9159: l_uk_where_caluse := l_uk_where_caluse||
9160: ' AND NVL('||l_attr_metadata_table(i).DATABASE_COLUMN||', '||G_NULL_TOKEN_NUM||' ) '||
9161: ' = NVL((SELECT ATTR_VALUE_NUM '||

Line 9171: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

9167: ' AND UAI.ROW_IDENTIFIER = INTRFC.ROW_IDENTIFIER '||
9168: ' ) '||
9169: ' ,'||G_NULL_TOKEN_NUM||' ) ';
9170:
9171: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
9172: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
9173:
9174: l_uk_where_caluse := l_uk_where_caluse||
9175: ' AND NVL('||l_attr_metadata_table(i).DATABASE_COLUMN||', '||G_NULL_TOKEN_DATE||' ) '||

Line 9172: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

9168: ' ) '||
9169: ' ,'||G_NULL_TOKEN_NUM||' ) ';
9170:
9171: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
9172: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
9173:
9174: l_uk_where_caluse := l_uk_where_caluse||
9175: ' AND NVL('||l_attr_metadata_table(i).DATABASE_COLUMN||', '||G_NULL_TOKEN_DATE||' ) '||
9176: ' = NVL((SELECT ATTR_VALUE_DATE '||

Line 9204: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

9200: END IF;
9201:
9202: ELSE -- If the AG is not multi row and the attr being processed is not a UK
9203:
9204: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
9205: l_num_attr_decode_list_Ext := l_num_attr_decode_list_Ext||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' ,'||l_attr_metadata_table(i).DATABASE_COLUMN;
9206: l_num_attr_decode_list_Intf := l_num_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_NUM ';
9207: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
9208: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 9207: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

9203:
9204: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
9205: l_num_attr_decode_list_Ext := l_num_attr_decode_list_Ext||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' ,'||l_attr_metadata_table(i).DATABASE_COLUMN;
9206: l_num_attr_decode_list_Intf := l_num_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_NUM ';
9207: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
9208: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
9209: l_date_attr_decode_list_Ext := l_date_attr_decode_list_Ext||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' ,'||l_attr_metadata_table(i).DATABASE_COLUMN;
9210: l_date_attr_decode_list_Intf := l_date_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_DATE ';
9211: ELSE

Line 9208: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

9204: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
9205: l_num_attr_decode_list_Ext := l_num_attr_decode_list_Ext||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' ,'||l_attr_metadata_table(i).DATABASE_COLUMN;
9206: l_num_attr_decode_list_Intf := l_num_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_NUM ';
9207: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
9208: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
9209: l_date_attr_decode_list_Ext := l_date_attr_decode_list_Ext||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' ,'||l_attr_metadata_table(i).DATABASE_COLUMN;
9210: l_date_attr_decode_list_Intf := l_date_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_DATE ';
9211: ELSE
9212: l_str_attr_decode_list_Ext := l_str_attr_decode_list_Ext||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' ,'||l_attr_metadata_table(i).DATABASE_COLUMN;