[Home] [Help]
545: THEN Nvl( (Max(tl.LAST_UPDATE_DATE)), (To_Date('01-01-1990','MM-DD-YYYY')) )
546: ELSE Nvl( (Max(b.LAST_UPDATE_DATE)), (To_Date('01-01-1990','MM-DD-YYYY')) )
547: END
548: ) AS LAST_UPDATE_DATE
549: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
550: EGO_ITEM_TP_ATTRS_EXT_TL tl,
551: EGO_UCCNET_EVENTS EV2,
552: HZ_CUST_ACCT_SITES_ALL HCAS
553: WHERE EV2.BATCH_ID = UE.BATCH_ID
694: THEN Nvl( (Max(tl.LAST_UPDATE_DATE)), (To_Date('01-01-1990','MM-DD-YYYY')) )
695: ELSE Nvl( (Max(b.LAST_UPDATE_DATE)), (To_Date('01-01-1990','MM-DD-YYYY')) )
696: END
697: ) AS LAST_UPDATE_DATE
698: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
699: EGO_ITEM_TP_ATTRS_EXT_TL tl,
700: EGO_UCCNET_EVENTS EV2,
701: HZ_CUST_ACCT_SITES_ALL HCAS
702: WHERE EV2.BATCH_ID = UE.BATCH_ID
1570: /*
1571: * This procedure is added as a part of fix for bug: 3983838
1572: * This procedure is called from User Defined attributes EO i.e. EgoMtlSyItemsExtVLEOImpl
1573: * If any Extension GDSN attributes are updated, we update the TP_NEUTRAL_UPDATE_DATE or
1574: * LAST_UPDATE_DATE of EGO_ITEM_TP_ATTRS_EXT_B, depending upon whether the Attibute group
1575: * is TP-Dependant or not.
1576: */
1577: PROCEDURE PROCESS_EXTN_ATTRIBUTE_UPDATES (p_inventory_item_id NUMBER,
1578: p_organization_id NUMBER,
1650: EXECUTE IMMEDIATE l_sql INTO l_value, l_extn_id USING p_inventory_item_id, p_organization_id, i.PARTY_SITE_ID;
1651:
1652: IF l_value IS NULL THEN
1653: write_debug_log('Value is null l_extn_id= '||l_extn_id);
1654: UPDATE EGO_ITEM_TP_ATTRS_EXT_B
1655: SET LAST_UPDATE_DATE = SYSDATE
1656: WHERE EXTENSION_ID = l_extn_id;
1657: END IF;
1658: write_debug_log('Value is not null l_extn_id= '||l_extn_id);
1659: EXCEPTION WHEN NO_DATA_FOUND THEN
1660: write_debug_log('No Data Found - inserting');
1661: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_ext_seq_val FROM DUAL;
1662:
1663: INSERT INTO EGO_ITEM_TP_ATTRS_EXT_B
1664: (
1665: EXTENSION_ID,
1666: INVENTORY_ITEM_ID,
1667: MASTER_ORGANIZATION_ID,