DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on EGO_EXT_FWK_PUB

Line 1304: OR l_attr_data_tbl(i).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE --G_NUMBER_FORMAT

1300: EXECUTE IMMEDIATE l_temp_query into l_temp using l_disp_val;
1301: l_compare_rec.source_sys_val := l_temp;
1302: Debug_Message('Value in the View table for this Attribute - '|| l_temp);
1303: ELSIF l_attr_data_tbl(i).VALUE_SET_ID = -1
1304: OR l_attr_data_tbl(i).VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE --G_NUMBER_FORMAT
1305: OR l_attr_data_tbl(i).DATABASE_COLUMN IN ( 'DESCRIPTION','ITEM_NUMBER', 'LONG_DESCRIPTION', 'APPROVAL_STATUS', 'CREATION_DATE',
1306: 'STYLE_ITEM_FLAG' , 'STYLE_ITEM_NUMBER', 'GDSN_OUTBOUND_ENABLED_FLAG',
1307: 'TRADE_ITEM_DESCRIPTOR' )
1308: THEN

Line 1471: AND l_attr_meta_tbl(i-1).VALIDATION_CODE <> EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE

1467:
1468: -- To populate into the Compare View Table
1469: IF l_attr_meta_tbl(i-1).VALUE_SET_ID <> -1
1470: AND l_attr_meta_tbl(i-1).VALUE_SET_ID <> 0
1471: AND l_attr_meta_tbl(i-1).VALIDATION_CODE <> EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE
1472: THEN
1473: Debug_Message('Value Set is associated, so getting display value for internal value: ' || l_val);
1474: IF(G_META(i) = G_DATE_FORMAT) THEN
1475: l_val := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (

Line 1699: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN

1695: UOM(l_idx) := rec_ud_attrs.UOM_CLASS;
1696: UOM_USER_CODE(l_idx) := rec_ud_attrs.ATTR_VALUE_UOM;
1697: UOM_DISP_VAL(l_idx) := rec_ud_attrs.ATTR_UOM_DISP_VALUE;
1698:
1699: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN
1700: VSId(l_idx) := 0;
1701: ELSE
1702: VSId(l_idx) := rec_ud_attrs.VALUE_SET_ID;
1703: END IF;

Line 1819: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN

1815: l_compare_rec.PRIV_ITEM3 := l_priv_item3;
1816: l_compare_rec.PRIV_ITEM4 := l_priv_item4;
1817:
1818: -- Saving UOM Class and value set Associated with this attribute
1819: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN
1820: VSId(l_idx) := 0;
1821: ELSE
1822: VSId(l_idx) := rec_ud_attrs.VALUE_SET_ID;
1823: END IF;

Line 2152: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN

2148: -- Saving UOM Class and value set Associated with this attribute
2149: UOM(l_idx) := rec_ud_attrs.UOM_CLASS;
2150: UOM_USER_CODE(l_idx) := rec_ud_attrs.ATTR_VALUE_UOM;
2151: UOM_DISP_VAL(l_idx) := rec_ud_attrs.ATTR_UOM_DISP_VALUE;
2152: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN
2153: VSId(l_idx) := 0;
2154: ELSE
2155: VSId(l_idx) := rec_ud_attrs.VALUE_SET_ID;
2156: END IF;

Line 2253: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN

2249: l_compare_rec.PRIV_ITEM4 := l_priv_item4;
2250: -- Nisar End
2251:
2252: -- Saving UOM Class and value set Associated with this attribute
2253: IF rec_ud_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN
2254: VSId(l_idx) := 0;
2255: ELSE
2256: VSId(l_idx) := rec_ud_attrs.VALUE_SET_ID;
2257: END IF;

Line 2571: IF rec_dd_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN

2567: -- Saving UOM Class and value set Associated with this attribute
2568: UOM(l_idx) := rec_dd_attrs.UOM_CLASS;
2569: UOM_USER_CODE(l_idx) := rec_dd_attrs.ATTR_VALUE_UOM;
2570: UOM_DISP_VAL(l_idx) := rec_dd_attrs.ATTR_UOM_DISP_VALUE;
2571: IF rec_dd_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN
2572: VSId(l_idx) := 0;
2573: ELSE
2574: VSId(l_idx) := rec_dd_attrs.VALUE_SET_ID;
2575: END IF;

Line 2711: IF rec_dd_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN

2707: -- Saving UOM Class and value set Associated with this attribute
2708: UOM(l_idx) := rec_dd_attrs.UOM_CLASS;
2709: UOM_USER_CODE(l_idx) := rec_dd_attrs.ATTR_VALUE_UOM;
2710: UOM_DISP_VAL(l_idx) := rec_dd_attrs.ATTR_UOM_DISP_VALUE;
2711: IF rec_dd_attrs.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_NONE_VALIDATION_CODE THEN
2712: VSId(l_idx) := 0;
2713: ELSE
2714: VSId(l_idx) := rec_dd_attrs.VALUE_SET_ID;
2715: END IF;