[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sid, serial#, audsid, username, schemaname, osuser, logon_time, module
INTO l_sid, l_serial, l_audsid, l_user, l_schema, l_os_user, l_logon_time, l_module
FROM v$session
WHERE audsid = (SELECT userenv('SESSIONID') FROM sys.dual);
PUT_LINE ('update_status :'||p_instance_asset_rec.update_status);
PUT_LINE ('update_status :'||p_asset_query_rec.update_status);
SELECT INTERNAL_PARTY_ID
,NULL -- PROJECT_LOCATION_ID
,NULL -- WIP_LOCATION_ID
,NULL -- IN_TRANSIT_LOCATION_ID
,NULL -- PO_LOCATION_ID
,CATEGORY_SET_ID
,nvl(HISTORY_FULL_DUMP_FREQUENCY,10)
,nvl(FREEZE_FLAG,'N')
,FREEZE_DATE
,nvl(SHOW_ALL_PARTY_LOCATION,'N')
,nvl(OWNERSHIP_OVERRIDE_AT_TXN,'N')
,nvl(SFM_QUEUE_BYPASS_FLAG,'N')
,nvl(AUTO_ALLOCATE_COMP_AT_WIP,'N')
,TXN_SEQ_START_DATE
,nvl(OWNERSHIP_CASCADE_AT_TXN,'N')
,'Y'
,FA_CREATION_GROUP_BY
INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
FROM CSI_INSTALL_PARAMETERS;