[Home] [Help]
1648: IF UPPER(p_aaev_rec.data_type) = 'DATE' THEN
1649: -- IF UPPER(p_aaev_rec.data_type) = 'D' THEN
1650: SELECT to_char(SYSDATE,NVL(p_aaev_rec.format_mask, 'DD-MON-YYYY'))
1651: INTO l_char_check
1652: FROM DUAL;
1653: ELSIF
1654: UPPER(p_aaev_rec.data_type) = 'NUMBER' AND p_aaev_rec.format_mask IS NOT NULL
1655: --UPPER(p_aaev_rec.data_type) = 'N' AND p_aaev_rec.format_mask IS NOT NULL
1656: THEN
1655: --UPPER(p_aaev_rec.data_type) = 'N' AND p_aaev_rec.format_mask IS NOT NULL
1656: THEN
1657: SELECT to_char(1,p_aaev_rec.format_mask)
1658: INTO l_char_check
1659: FROM DUAL;
1660: IF p_aaev_rec.data_type = 'CHAR' AND
1661: --IF p_aaev_rec.data_type = 'C' AND
1662: p_aaev_rec.format_mask IS NOT NULL THEN
1663: OKC_API.SET_MESSAGE(G_APP_NAME
2207: --UPPER(p_aaev_rec.data_type) = 'D' THEN
2208: SELECT to_date(p_aaev_rec.minimum_value,NVL(p_aaev_rec.format_mask,'XXXXX')),
2209: to_date(p_aaev_rec.maximum_value,NVL(p_aaev_rec.format_mask,'XXXXX'))
2210: INTO l_date_check_min,l_date_check_max
2211: FROM DUAL;
2212: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2213: ELSIF
2214: UPPER(p_aaev_rec.data_type) = 'NUMBER'
2215: --UPPER(p_aaev_rec.data_type) = 'N'
2216: THEN
2217: SELECT to_number(p_aaev_rec.minimum_value,NVL(p_aaev_rec.format_mask,'XXXXX')),
2218: to_number(p_aaev_rec.maximum_value,NVL(p_aaev_rec.format_mask,'XXXXX'))
2219: INTO l_number_check_max,l_number_check_min
2220: FROM DUAL;
2221: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2222: ELSE
2223: OKC_API.SET_MESSAGE(G_APP_NAME
2224: ,G_INVALID_VALUE
2956: l_aaev_rec := null_out_defaults(p_aaev_rec);
2957: -- Set primary key value
2958: -- If action attribute is created by seed then use sequence generated id
2959: IF l_aaev_rec.CREATED_BY = 1 THEN
2960: SELECT OKC_ACTION_ATTRIBUTES_S1.nextval INTO l_id FROM dual;
2961: l_aaev_rec.ID := l_id;
2962: l_aaev_rec.seeded_flag := 'Y';
2963: ELSE
2964: l_aaev_rec.ID := get_seq_id;