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 455: IF (l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE

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

Line 457: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE

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

Line 459: l_attr_metadata_obj.validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE

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

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

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

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

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

Line 467: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

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

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

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

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

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

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

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

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

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

Line 659: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

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

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

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

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

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

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

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

Line 925: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

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

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

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

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

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

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

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

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

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

Line 962: l_attr_metadata_obj.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

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

Line 1165: IF (p_data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

1161:
1162: BEGIN
1163: code_debug(l_api_name|| ' Starting ');
1164:
1165: IF (p_data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
1166: l_data_type_clause := 'ATTR_VALUE_NUM';
1167: ELSIF (p_data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR p_data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1168: l_data_type_clause := 'ATTR_VALUE_DATE';
1169: ELSE

Line 1167: ELSIF (p_data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR p_data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

1163: code_debug(l_api_name|| ' Starting ');
1164:
1165: IF (p_data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
1166: l_data_type_clause := 'ATTR_VALUE_NUM';
1167: ELSIF (p_data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR p_data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1168: l_data_type_clause := 'ATTR_VALUE_DATE';
1169: ELSE
1170: l_data_type_clause := 'ATTR_VALUE_STR';
1171: END IF;

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

3326: 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 '
3327: INTO l_null_date_time_value,l_null_date_value;
3328:
3329: l_dynamic_sql := 'UPDATE ';
3330: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3331: l_dynamic_sql := l_dynamic_sql ||p_interface_table_name||' SET '||' ATTR_VALUE_NUM = DECODE(ATTR_DISP_VALUE, '''||G_NULL_NUM_VAL_STR||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_VALUE_NUM) '||
3332: ' ,ATTR_DISP_VALUE = DECODE(ATTR_DISP_VALUE, '''||G_NULL_NUM_VAL_STR||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_DISP_VALUE) '||
3333: ' ,PROCESS_STATUS = PROCESS_STATUS + DECODE (ATTR_DISP_VALUE,'''||G_NULL_NUM_VAL_STR||''', 0 , '''||G_NULL_CHAR_VAL||''', 0 , '||
3334: ' NULL, 0 , '||G_PS_INVALID_NUMBER_DATA||' )'||

Line 3351: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

3347: USING p_data_set_id, l_attr_metadata_rec(l_var).ATTR_INT_NAME, l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME,
3348: p_attr_group_type, TO_NUMBER(G_NULL_NUM_VAL_STR),--bugFix:5297926
3349: G_NULL_NUM_VAL_STR , G_NULL_NUM_VAL, G_NULL_DATE_VAL,l_null_date_time_value, G_NULL_CHAR_VAL;
3350:
3351: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
3352: OR l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3353: l_dynamic_sql := l_dynamic_sql ||p_interface_table_name||' SET '||' ATTR_VALUE_DATE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL,'||
3354: ' '''||l_null_date_value||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_VALUE_DATE) '||
3355: ' ,ATTR_DISP_VALUE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL, '||

Line 3352: OR l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3348: p_attr_group_type, TO_NUMBER(G_NULL_NUM_VAL_STR),--bugFix:5297926
3349: G_NULL_NUM_VAL_STR , G_NULL_NUM_VAL, G_NULL_DATE_VAL,l_null_date_time_value, G_NULL_CHAR_VAL;
3350:
3351: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
3352: OR l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3353: l_dynamic_sql := l_dynamic_sql ||p_interface_table_name||' SET '||' ATTR_VALUE_DATE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL,'||
3354: ' '''||l_null_date_value||''', NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_VALUE_DATE) '||
3355: ' ,ATTR_DISP_VALUE = DECODE(ATTR_DISP_VALUE, '''||l_null_date_time_value||''', NULL, '||
3356: ' '''||l_null_date_value||''',NULL, '''||G_NULL_CHAR_VAL||''', NULL, NULL, NULL, ATTR_DISP_VALUE) '||

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

3455:
3456:
3457: -- 4043670 added for trans independent type value sets as well
3458: IF (l_attr_metadata_rec(l_var).VALIDATION_TYPE IN
3459: (EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE, EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)
3460: ) THEN
3461:
3462: code_debug(' This attribute has an indipendednt value set, validating for value set id -'||l_attr_metadata_rec(l_var).VALUE_SET_ID ,2);
3463:

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

3460: ) THEN
3461:
3462: code_debug(' This attribute has an indipendednt value set, validating for value set id -'||l_attr_metadata_rec(l_var).VALUE_SET_ID ,2);
3463:
3464: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3465: IF (l_ivs_num_cursor_id IS NULL) THEN
3466: l_ivs_num_cursor_id := DBMS_SQL.Open_Cursor;
3467: l_dynamic_sql :=
3468: 'UPDATE '||p_interface_table_name||'

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

3517: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3518: DBMS_SQL.Bind_Variable(l_ivs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3519: l_dummy := DBMS_SQL.Execute(l_ivs_num_cursor_id);
3520:
3521: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3522: IF (l_ivs_date_cursor_id IS NULL) THEN
3523:
3524: l_ivs_date_cursor_id := DBMS_SQL.Open_Cursor;
3525: l_dynamic_sql :=

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

3574: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_int_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3575: DBMS_SQL.Bind_Variable(l_ivs_date_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3576: l_dummy := DBMS_SQL.Execute(l_ivs_date_cursor_id);
3577:
3578: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3579:
3580: IF (l_ivs_date_time_cursor_id IS NULL) THEN
3581:
3582: l_ivs_date_time_cursor_id := DBMS_SQL.Open_Cursor;

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

3695: DBMS_SQL.Bind_Variable(l_ivs_char_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3696: l_dummy := DBMS_SQL.Execute(l_ivs_char_cursor_id);
3697:
3698: END IF;
3699: ELSIF (l_attr_metadata_rec(l_var).VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
3700:
3701: ------------------------------------------------------------------------------------
3702: -- HERE WE UPDATE THE INTERFACE TABLE SETTING THE ATTR_VAL_(NUM/STR/DATE) COLUMNS --
3703: -- WITH VALUES FETCHED FROM THE TABLE FOR THE VALUE ENTERED AS DISPLAY VALUE i.e. --

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

3714: code_debug(' This attribute has a none value set, validating for before populating the attr_Value* columns from attr_disp_value column' ,2);
3715: ------------------------------------------------------------------------------------
3716: -- HERE WE UPDATE THE INTERFACE TABLE SETTING THE ATTR_VAL_(NUM/STR/DATE) COLUMNS --
3717: -- FROM ATTR_DISP_VALUE FOR ATTRS WITHOUT ANY VALUE SET *OR* WITH VALIDATION TYPE --
3718: -- ='N' (i.e., EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE) --
3719: -- WE ALSO DO THE MAX/MIN VALIDATION IN THIS SEGMENT --
3720: ------------------------------------------------------------------------------------
3721: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3722:

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

3717: -- FROM ATTR_DISP_VALUE FOR ATTRS WITHOUT ANY VALUE SET *OR* WITH VALIDATION TYPE --
3718: -- ='N' (i.e., EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE) --
3719: -- WE ALSO DO THE MAX/MIN VALIDATION IN THIS SEGMENT --
3720: ------------------------------------------------------------------------------------
3721: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3722:
3723: IF (l_nvs_num_cursor_id is NULL) THEN
3724: l_nvs_num_cursor_id := DBMS_SQL.Open_Cursor;
3725: l_dynamic_sql :=

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

3751: DBMS_SQL.Bind_Variable(l_nvs_num_cursor_id, ':attr_group_int_name', l_attr_metadata_rec(l_var).ATTR_GROUP_INT_NAME);
3752:
3753: l_dummy := DBMS_SQL.Execute(l_nvs_num_cursor_id);
3754:
3755: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
3756:
3757: IF (l_nvs_date_cursor_id IS NULL) THEN
3758: l_nvs_date_cursor_id := DBMS_SQL.Open_Cursor;
3759: l_dynamic_sql :=

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

3780: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_min_allowed_val', l_attr_metadata_rec(l_var).MINIMUM_VALUE);
3781: DBMS_SQL.Bind_Variable(l_nvs_date_cursor_id, ':attr_max_allowed_val', l_attr_metadata_rec(l_var).MAXIMUM_VALUE);
3782: l_dummy := DBMS_SQL.Execute(l_nvs_date_cursor_id);
3783:
3784: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3785:
3786: IF (l_nvs_datetime_cursor_id is NULL) THEN
3787: l_nvs_datetime_cursor_id := DBMS_SQL.Open_Cursor;
3788: l_dynamic_sql :=

Line 3851: IF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN

3847:
3848: -- swuppala: START : bug fix 12907500 There is no validation on data type before setting the maximum value. Hence transalatable text which execeeds 150 size is erroring out.
3849: -- with ora-06502: pl/sql: numeric or value error: character string
3850: IF (l_attr_metadata_rec(l_var).MAXIMUM_SIZE IS NULL OR l_attr_metadata_rec(l_var).MAXIMUM_SIZE = 0) THEN
3851: IF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
3852: l_attr_metadata_rec(l_var).MAXIMUM_SIZE := 150; -- 150 is the default Max length of UDA per functional design
3853: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3854: l_attr_metadata_rec(l_var).MAXIMUM_SIZE := 1000; -- 1000 is the default Max length of Translatable text type UDA.
3855: END IF;

Line 3853: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

3849: -- with ora-06502: pl/sql: numeric or value error: character string
3850: IF (l_attr_metadata_rec(l_var).MAXIMUM_SIZE IS NULL OR l_attr_metadata_rec(l_var).MAXIMUM_SIZE = 0) THEN
3851: IF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
3852: l_attr_metadata_rec(l_var).MAXIMUM_SIZE := 150; -- 150 is the default Max length of UDA per functional design
3853: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3854: l_attr_metadata_rec(l_var).MAXIMUM_SIZE := 1000; -- 1000 is the default Max length of Translatable text type UDA.
3855: END IF;
3856: END IF;
3857:

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

3861:
3862: code_debug(' This attribute has a maximum size of '||l_attr_metadata_rec(l_var).MAXIMUM_SIZE,2);
3863:
3864: --------- FOR NUMBER DATATYPE
3865: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3866: IF (l_max_size_num_cursor IS NULL) THEN
3867: l_max_size_num_cursor := DBMS_SQL.Open_Cursor;
3868: l_dynamic_sql :=
3869: 'UPDATE '||p_interface_table_name||'

Line 3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

3884: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':attr_internal_name', l_attr_metadata_rec(l_var).ATTR_INT_NAME);
3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3887: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3889: l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3890:
3891: IF ( l_max_size_char_cursor IS NULL) THEN
3892: l_max_size_char_cursor := DBMS_SQL.Open_Cursor;

Line 3889: l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

3885: DBMS_SQL.Bind_Variable(l_max_size_num_cursor, ':max_allowed_size', l_attr_metadata_rec(l_var).MAXIMUM_SIZE);
3886: l_dummy := DBMS_SQL.Execute(l_max_size_num_cursor);
3887: --------- FOR CHAR OR TRANSLATEBLE TEXT DATATYPE
3888: ELSIF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3889: l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3890:
3891: IF ( l_max_size_char_cursor IS NULL) THEN
3892: l_max_size_char_cursor := DBMS_SQL.Open_Cursor;
3893: l_dynamic_sql :=

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

3921:
3922: code_debug(' Before validating the rows for data in wrong column ' ,2);
3923:
3924: --------- FOR NUMBER DATATYPE
3925: IF(l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3926: IF (l_colcheck_num_cursor_id IS NULL) THEN
3927: l_colcheck_num_cursor_id := DBMS_SQL.Open_Cursor;
3928: l_dynamic_sql :=
3929: 'UPDATE '||p_interface_table_name||'

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

3945:
3946: l_dummy := DBMS_SQL.Execute(l_colcheck_num_cursor_id);
3947:
3948: --------- FOR DATE/DATETIME DATATYPE
3949: ELSIF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3950: IF (l_colcheck_date_cursor_id IS NULL) THEN
3951: l_colcheck_date_cursor_id := DBMS_SQL.Open_Cursor;
3952: l_dynamic_sql :=
3953: 'UPDATE '||p_interface_table_name||'

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

4173: FOR i IN l_attr_metadata_table.FIRST .. l_attr_metadata_table.LAST
4174: LOOP
4175: IF (l_attr_metadata_table(i).UNIQUE_KEY_FLAG = 'Y' ) THEN
4176:
4177: --IF ( l_attr_metadata_table(i).DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR 1=1) THEN
4178: --GNANDA : Since now we are supporting TL UK's we do not need to error out the AG rows with
4179: --TL attrs as UK's in them.
4180: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
4181: l_intf_column_name := ' ATTR_VALUE_NUM ';

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

4176:
4177: --IF ( l_attr_metadata_table(i).DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR 1=1) THEN
4178: --GNANDA : Since now we are supporting TL UK's we do not need to error out the AG rows with
4179: --TL attrs as UK's in them.
4180: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
4181: l_intf_column_name := ' ATTR_VALUE_NUM ';
4182: wierd_constant := G_NULL_TOKEN_NUM;
4183: 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
4184: l_intf_column_name := ' ATTR_VALUE_DATE ';

Line 4183: 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

4179: --TL attrs as UK's in them.
4180: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
4181: l_intf_column_name := ' ATTR_VALUE_NUM ';
4182: wierd_constant := G_NULL_TOKEN_NUM;
4183: 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
4184: l_intf_column_name := ' ATTR_VALUE_DATE ';
4185: wierd_constant := G_NULL_TOKEN_DATE;
4186: ELSE
4187: l_intf_column_name := ' ATTR_VALUE_STR ';

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

4347: l_tvs_where_clause := ' ';
4348: --bug9846845, initialization the l_tvs_where_clause_clob
4349: l_tvs_where_clause_clob := ' ';
4350: 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
4351: IF (l_attr_metadata_table(y).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
4352:
4353: 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);
4354:
4355: SELECT APPLICATION_TABLE_NAME,

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

4456: l_value_from_ext_table := ' (SELECT '|| l_ext_attr_col_name ||'
4457: FROM '||l_ext_table_select||'
4458: AND ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID) ';
4459:
4460: IF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4461: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
4462: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4463: AND DATA_SET_ID = '||p_data_set_id||'
4464: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

Line 4465: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

4461: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
4462: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4463: AND DATA_SET_ID = '||p_data_set_id||'
4464: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';
4465: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4466: l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4467: l_value_from_intftbl := '(SELECT ATTR_VALUE_DATE FROM '||p_interface_table_name||'
4468: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4469: AND DATA_SET_ID = '||p_data_set_id||'

Line 4466: l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

4462: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4463: AND DATA_SET_ID = '||p_data_set_id||'
4464: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';
4465: ELSIF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4466: l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4467: l_value_from_intftbl := '(SELECT ATTR_VALUE_DATE FROM '||p_interface_table_name||'
4468: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
4469: AND DATA_SET_ID = '||p_data_set_id||'
4470: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

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

4632: the meanin col is of type character.
4633: another assumtion is that the user cannot enter the value directly in to the attr_val_* col
4634: he has to enter the data in attr_disp_Value column for which we get the actual attr val.
4635: */
4636: IF (l_attr_metadata_table(y).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4637:
4638: -- Bug 10151142 : Start
4639: /*
4640: l_dynamic_sql_1 :=

Line 4690: p_data_type_code => EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE,

4686: END;
4687: */
4688:
4689: Prepare_Dynamic_Sqls_Clob ( p_data_set_id => p_data_set_id,
4690: p_data_type_code => EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE,
4691: p_interface_table_name => p_interface_table_name,
4692: p_tvs_val_check_sel_clob => l_tvs_num_val_check_sel_clob,
4693: p_tvs_select_clob => l_tvs_select_clob,
4694: p_attr_name => l_attr_metadata_table(y).ATTR_NAME,

Line 4774: 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

4770: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
4771: END;
4772: -- Bug 10151142 : End
4773:
4774: 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
4775:
4776: -- Bug 10151142 : Start
4777: /*
4778: l_dynamic_sql_1 :=

Line 4827: p_data_type_code => EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,

4823: END;
4824: */
4825:
4826: Prepare_Dynamic_Sqls_Clob ( p_data_set_id => p_data_set_id,
4827: p_data_type_code => EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
4828: p_interface_table_name => p_interface_table_name,
4829: p_tvs_val_check_sel_clob => l_tvs_date_val_check_sel_clob,
4830: p_tvs_select_clob => l_tvs_select_clob,
4831: p_attr_name => l_attr_metadata_table(y).ATTR_NAME,

Line 4978: p_data_type_code => EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE,

4974: END;
4975: */
4976:
4977: Prepare_Dynamic_Sqls_Clob ( p_data_set_id => p_data_set_id,
4978: p_data_type_code => EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE,
4979: p_interface_table_name => p_interface_table_name,
4980: p_tvs_val_check_sel_clob => l_tvs_str_val_check_sel_clob,
4981: p_tvs_select_clob => l_tvs_select_clob,
4982: p_attr_name => l_attr_metadata_table(y).ATTR_NAME,

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

5283: /*
5284:
5285: code_debug(' Attribute '||l_attr_metadata_table_1(z).ATTR_NAME|| ' has a default value or is a required attribute' ,2);
5286: --------- FOR NUMBER DATATYPE
5287: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5288: IF (l_default_num_cursor_id IS NULL) THEN
5289: l_default_num_cursor_id := DBMS_SQL.Open_Cursor;
5290: l_dynamic_sql :=
5291: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,

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

5334: l_dist_attrs_in_data_set_table(l_dist_attrs_in_data_set_table.COUNT+1) := l_dist_attr_in_data_set_rec;
5335: END IF;
5336:
5337: --------- FOR DATE DATATYPE
5338: ELSIF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5339: l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5340: IF (l_default_date_cursor_id IS NULL) THEN
5341: l_default_date_cursor_id := DBMS_SQL.Open_Cursor;
5342: l_dynamic_sql :=

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

5335: END IF;
5336:
5337: --------- FOR DATE DATATYPE
5338: ELSIF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5339: l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5340: IF (l_default_date_cursor_id IS NULL) THEN
5341: l_default_date_cursor_id := DBMS_SQL.Open_Cursor;
5342: l_dynamic_sql :=
5343: 'INSERT INTO '||p_interface_table_name||' ( TRANSACTION_ID,

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

5455:
5456: code_debug(' Attribute '||l_attr_metadata_table_1(z).ATTR_NAME|| ' is a required attribute' ,2);
5457:
5458: --------- FOR NUMBER DATATYPE
5459: IF(l_attr_metadata_table_1(z).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5460: IF (l_req_num_cursor_id IS NULL) THEN
5461: l_req_num_cursor_id := DBMS_SQL.Open_Cursor;
5462: l_dynamic_sql :=
5463: 'UPDATE '||p_interface_table_name||'

Line 5482: 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

5478:
5479: l_dummy := DBMS_SQL.Execute(l_req_num_cursor_id);
5480:
5481: --------- FOR DATE AND DATE TIME DATATYPE
5482: 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
5483: IF (l_req_date_cursor_id IS NULL) THEN
5484: l_req_date_cursor_id := DBMS_SQL.Open_Cursor;
5485: l_dynamic_sql :=
5486: 'UPDATE '||p_interface_table_name||'

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

5551: END IF;
5552:
5553: --WE DO THE TVC VALIDATION FOR SRAG ONLY IF THIS ATTR HAS ATLEAST ONE VALID INSTANCE IN THE INTF TABLE
5554: IF (l_attr_exists_in_intf = 'EXISTS') THEN
5555: IF (l_attr_metadata_table_sr(x).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5556:
5557: 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);
5558:
5559: SELECT APPLICATION_TABLE_NAME,

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

5699: END IF;
5700: */
5701: --bug 12397223 end
5702:
5703: IF (l_bind_attr_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5704: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
5705: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
5706: AND DATA_SET_ID = :data_set_id
5707: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

Line 5708: 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

5704: l_value_from_intftbl := '(SELECT ATTR_VALUE_NUM FROM '||p_interface_table_name||'
5705: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
5706: AND DATA_SET_ID = :data_set_id
5707: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';
5708: 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
5709: l_value_from_intftbl := '(SELECT ATTR_VALUE_DATE FROM '||p_interface_table_name||'
5710: WHERE ROW_IDENTIFIER = UAI1.ROW_IDENTIFIER
5711: AND DATA_SET_ID = :data_set_id
5712: AND ATTR_INT_NAME = '''||l_bind_attr_name||''' )';

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

5789: the meanin col is of type character.
5790: another assumtion is that the user cannot enter the value directly in to the attr_val_* col
5791: he has to enter the data in attr_disp_Value column for which we get the actual attr val.
5792: */
5793: IF (l_attr_metadata_table_sr(x).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5794:
5795: l_dynamic_sql_1 :=
5796: 'UPDATE '||p_interface_table_name||' UAI1
5797: SET PROCESS_STATUS = PROCESS_STATUS + DECODE(('||l_tvs_num_val_check_select||'),0,'||G_PS_VALUE_NOT_IN_TVS||',0)

Line 5855: 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

5851: DBMS_SQL.Bind_Variable(l_bad_tvs_sql_cursor_id, ':attr_internal_name', l_attr_metadata_table_sr(x).ATTR_NAME);
5852: l_dummy := DBMS_SQL.Execute(l_bad_tvs_sql_cursor_id);
5853: END;
5854:
5855: 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
5856:
5857: l_dynamic_sql_1 :=
5858: 'UPDATE '||p_interface_table_name||' UAI1
5859: SET PROCESS_STATUS = PROCESS_STATUS + DECODE(('||l_tvs_date_val_check_select||'),0,'||G_PS_VALUE_NOT_IN_TVS||',0)

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

6540: l_defaltening_sql_create := ' ';
6541: FOR i IN l_attr_metadata_table.FIRST .. l_attr_metadata_table.LAST
6542: LOOP
6543: -- abedajna begin
6544: if l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE then
6545: l_correct_date_time_sql_uai := 'to_char(UAI1.ATTR_VALUE_DATE , '||''''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT ||''')';
6546: l_correct_date_time_sql_extvl := 'to_char(EXTVL1.'||l_attr_metadata_table(i).DATABASE_COLUMN||', '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT ||''')';
6547: else
6548: l_correct_date_time_sql_uai := 'UAI1.ATTR_VALUE_DATE';

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

7318: -------------------------------------------------------
7319: -- lets get ready with the correct wierd constant --
7320: -------------------------------------------------------
7321:
7322: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7323: wierd_constant := G_NULL_TOKEN_NUM;
7324: wierd_constant_2 := '8.88E125';
7325: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
7326: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN

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

7321:
7322: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7323: wierd_constant := G_NULL_TOKEN_NUM;
7324: wierd_constant_2 := '8.88E125';
7325: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
7326: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
7327: wierd_constant := G_NULL_TOKEN_DATE;
7328: wierd_constant_2 := 'TO_DATE(''2'',''J'')';
7329: ELSE

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

7322: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7323: wierd_constant := G_NULL_TOKEN_NUM;
7324: wierd_constant_2 := '8.88E125';
7325: ELSIF ( l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
7326: OR l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
7327: wierd_constant := G_NULL_TOKEN_DATE;
7328: wierd_constant_2 := 'TO_DATE(''2'',''J'')';
7329: ELSE
7330: wierd_constant := G_NULL_TOKEN_STR;

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

7335: -- UK clause (note that we only update non-UK Attrs) --
7336: -------------------------------------------------------
7337: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG = 'Y') THEN
7338:
7339: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
7340: --GNANDA: While inserting rows in the TL table for a case where we have a TL Uk we insert rows for
7341: --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.
7342:
7343: --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 7383: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

7379: ---------------------------------
7380: -- Data type-dependent clauses --
7381: ---------------------------------
7382: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7383: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7384:
7385: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
7386: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_NUM,'||wierd_constant||',NULL,ATTR_VALUE_NUM), ATTR_VALUE_NUM)';
7387: -- ...this closes what started above

Line 7446: EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

7442: END IF;
7443: END IF;
7444:
7445: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7446: EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
7447: l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7448: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
7449:
7450: --Bug 4473391(gnanda) : we need to convert the attr_value_date to char in the decode and then convert the final value into

Line 7448: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

7444:
7445: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7446: EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
7447: l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7448: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
7449:
7450: --Bug 4473391(gnanda) : we need to convert the attr_value_date to char in the decode and then convert the final value into
7451: --date otherwise decode would remove the time part from date time attribute.
7452: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||

Line 7498: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

7494: IF (l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG IS NULL
7495: OR l_attr_metadata_table_sr(d).UNIQUE_KEY_FLAG <> 'Y') THEN
7496:
7497: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7498: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
7499:
7500: l_db_col_tbl_set_tl_attrs := l_db_col_tbl_set_tl_attrs||
7501: ',EXT.'||
7502: l_attr_metadata_table_sr(d).DATABASE_COLUMN||

Line 7527: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

7523: ----------------------
7524: -- B vs. TL clauses --
7525: ----------------------
7526: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7527: EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
7528:
7529: l_rtcq_alias_tl_cols_list := l_rtcq_alias_tl_cols_list||',RTCQ.'||
7530: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7531: 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 7557: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

7553: l_rtcq_alias_b_cols_list := l_rtcq_alias_b_cols_list||',RTCQ.'||
7554: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7555:
7556: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7557: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7558: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
7559: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7560: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
7561: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN

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

7556: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7557: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7558: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
7559: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7560: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
7561: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
7562: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
7563: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7564: ELSE

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

7557: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7558: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '''||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM_1||''' '
7559: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7560: ELSIF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE OR
7561: l_attr_metadata_table_sr(d).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
7562: l_rtcq_alias_b_cols_list_1 := l_rtcq_alias_b_cols_list_1||', '||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE_1||' '
7563: ||l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7564: ELSE
7565: 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 9371: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

9367: ----------------------------------------------------------------------
9368: -- Add SELECT list attributes that are specific to NUMBER type --
9369: ----------------------------------------------------------------------
9370:
9371: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
9372: l_template_table_RTCQ := l_template_table_RTCQ ||
9373: ', MAX(DECODE(TEMPL.ATTRIBUTE_ID '||
9374: ','||TO_CHAR(l_attr_metadata_table(i).ATTR_ID)||
9375: ','||'TEMPL.ATTRIBUTE_NUMBER_VALUE'||

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

9406: ----------------------------------------------------------------------
9407: -- Add SELECT list attributes that are specific to DATE TIME type --
9408: ----------------------------------------------------------------------
9409:
9410: ELSIF ( l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
9411: OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
9412: l_template_table_RTCQ := l_template_table_RTCQ ||
9413: ', MAX(DECODE(TEMPL.ATTRIBUTE_ID '||
9414: ','||TO_CHAR(l_attr_metadata_table(i).ATTR_ID)||

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

9407: -- Add SELECT list attributes that are specific to DATE TIME type --
9408: ----------------------------------------------------------------------
9409:
9410: ELSIF ( l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
9411: OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
9412: l_template_table_RTCQ := l_template_table_RTCQ ||
9413: ', MAX(DECODE(TEMPL.ATTRIBUTE_ID '||
9414: ','||TO_CHAR(l_attr_metadata_table(i).ATTR_ID)||
9415: ','||'TEMPL.ATTRIBUTE_DATE_VALUE'||

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

9727: l_dynamic_sql VARCHAR2(200);
9728: l_formated_String VARCHAR2(500);
9729: BEGIN
9730:
9731: IF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE ) THEN
9732: l_error_code := G_PS_INVALID_DATE_DATA ;
9733: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
9734: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
9735: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||

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

9739: ELSE
9740: l_date_value := TO_DATE(p_value_to_convert, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
9741: END IF;
9742:
9743: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
9744: l_error_code := G_PS_INVALID_DATE_TIME_DATA ;
9745: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
9746: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
9747: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||

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

9751: ELSE
9752: l_date_value := TO_DATE(p_value_to_convert,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
9753: END IF;
9754:
9755: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
9756: l_error_code := G_PS_INVALID_NUMBER_DATA ;
9757: l_num_value := TO_NUMBER(p_value_to_convert);
9758: END IF;
9759:

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

9827: the conversion of max min date fails since the format they are in is 2004-07-01 00:00:00.0
9828: this is the format in which the date string we get from the Value set, since this format
9829: for date is not supported in 8i I
9830: */
9831: IF (p_datatype = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR p_datatype = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
9832:
9833: IF (INSTR(p_value_to_check,'$SYSDATE$') > 0 ) THEN
9834: l_formated_string := TRIM(REPLACE(p_value_to_check, '$'));
9835: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||

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

9878: IF ( l_date_value < NVL(l_min_date, l_date_value) ) THEN
9879: RETURN G_PS_MIN_VAL_VIOLATION;
9880: END IF;
9881:
9882: ELSIF (p_datatype = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
9883: l_num_value := TO_NUMBER(p_value_to_check);
9884:
9885: IF (l_num_value > NVL(TO_NUMBER(p_max_value), l_num_value) ) THEN
9886: IF p_min_value IS NULL THEN

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

10332: ' ,:request_id '|| --REQUEST_ID
10333: ' ,:max_row_id + ROW_ID '|| --ROW_IDENTIFIER
10334: ' ,ATTR_TBL.DESCRIPTIVE_FLEX_CONTEXT_CODE '|| --ATTR_GROUP_INT_NAME
10335: ' ,ATTR_TBL.END_USER_COLUMN_NAME '|| --ATTR_INT_NAME
10336: ' ,TO_NUMBER(DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE||''' '||--ATTR_VALUE_NUM
10337: ' ,ATTR_TBL.DEFAULT_VALUE '||
10338: ' ,NULL)) '||
10339: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR
10340: ' ,ATTR_TBL.DEFAULT_VALUE '||

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

10335: ' ,ATTR_TBL.END_USER_COLUMN_NAME '|| --ATTR_INT_NAME
10336: ' ,TO_NUMBER(DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE||''' '||--ATTR_VALUE_NUM
10337: ' ,ATTR_TBL.DEFAULT_VALUE '||
10338: ' ,NULL)) '||
10339: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR
10340: ' ,ATTR_TBL.DEFAULT_VALUE '||
10341: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
10342: ' ,ATTR_TBL.DEFAULT_VALUE '||
10343: ' ,NULL) '||

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

10337: ' ,ATTR_TBL.DEFAULT_VALUE '||
10338: ' ,NULL)) '||
10339: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE||''' '||--ATTR_VALUE_STR
10340: ' ,ATTR_TBL.DEFAULT_VALUE '||
10341: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
10342: ' ,ATTR_TBL.DEFAULT_VALUE '||
10343: ' ,NULL) '||
10344: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
10345: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||

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

10340: ' ,ATTR_TBL.DEFAULT_VALUE '||
10341: ' , '''||EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE||''' '||
10342: ' ,ATTR_TBL.DEFAULT_VALUE '||
10343: ' ,NULL) '||
10344: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
10345: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10346: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
10347: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10348: ' ,NULL) ';

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

10342: ' ,ATTR_TBL.DEFAULT_VALUE '||
10343: ' ,NULL) '||
10344: ' ,DECODE(ATTR_EXT_TBL.DATA_TYPE, '''||EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE||''' '||--ATTR_VALUE_DATE
10345: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10346: ' , '''||EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE||''' '||
10347: ' ,EGO_USER_ATTRS_BULK_PVT.Get_Date(ATTR_TBL.DEFAULT_VALUE,NULL)'||
10348: ' ,NULL) ';
10349:
10350: l_dynamic_sql := l_dynamic_sql || l_pk_cc_select_list;

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

10944:
10945: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND l_attr_metadata_table(i).UNIQUE_KEY_FLAG = 'Y') THEN
10946:
10947: l_uk_attr_list := l_uk_attr_list||' '''||l_attr_metadata_table(i).ATTR_NAME||''', ';
10948: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
10949:
10950: l_uk_where_caluse := l_uk_where_caluse||
10951: ' AND NVL('||l_attr_metadata_table(i).DATABASE_COLUMN||', '||G_NULL_TOKEN_NUM||' ) '||
10952: ' = NVL((SELECT ATTR_VALUE_NUM '||

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

10958: ' AND UAI.ROW_IDENTIFIER = INTRFC.ROW_IDENTIFIER '||
10959: ' ) '||
10960: ' ,'||G_NULL_TOKEN_NUM||' ) ';
10961:
10962: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
10963: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
10964:
10965: l_uk_where_caluse := l_uk_where_caluse||
10966: ' AND NVL('||l_attr_metadata_table(i).DATABASE_COLUMN||', '||G_NULL_TOKEN_DATE||' ) '||

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

10959: ' ) '||
10960: ' ,'||G_NULL_TOKEN_NUM||' ) ';
10961:
10962: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
10963: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
10964:
10965: l_uk_where_caluse := l_uk_where_caluse||
10966: ' AND NVL('||l_attr_metadata_table(i).DATABASE_COLUMN||', '||G_NULL_TOKEN_DATE||' ) '||
10967: ' = NVL((SELECT ATTR_VALUE_DATE '||

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

10991: END IF;
10992:
10993: ELSE -- If the AG is not multi row and the attr being processed is not a UK
10994:
10995: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
10996: 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;
10997: l_num_attr_decode_list_Intf := l_num_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_NUM ';
10998: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
10999: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

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

10994:
10995: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
10996: 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;
10997: l_num_attr_decode_list_Intf := l_num_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_NUM ';
10998: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
10999: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
11000: 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;
11001: l_date_attr_decode_list_Intf := l_date_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_DATE ';
11002: ELSE

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

10995: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
10996: 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;
10997: l_num_attr_decode_list_Intf := l_num_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_NUM ';
10998: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
10999: l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
11000: 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;
11001: l_date_attr_decode_list_Intf := l_date_attr_decode_list_Intf||' ,'''||l_attr_metadata_table(i).ATTR_NAME||''' , INTRFC.ATTR_VALUE_DATE ';
11002: ELSE
11003: 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;