DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on EGO_EXT_FWK_PUB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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